SELECT
se_friends.friend_id,
se_users.user_id,
se_users.user_username,
se_users.user_fname,
se_users.user_lname,
se_users.user_photo,
se_users.user_lastlogindate,
se_users.user_dateupdated,
se_visitors.visitor_lastactive
,
CASE
WHEN (SELECT TRUE FROM se_users AS se_users2 WHERE se_users2.user_id=se_users.user_id AND (user_blocklist LIKE '33254,%' OR user_blocklist LIKE '%,33254' OR user_blocklist LIKE '%,33254,%') LIMIT 1)
THEN TRUE
ELSE FALSE
END
AS is_viewers_blocklisted
,
se_friends.friend_type,
se_friendexplains.friendexplain_body
FROM
se_friends
LEFT JOIN
se_users ON
se_friends.friend_user_id2=se_users.user_id
LEFT JOIN
se_friendexplains
ON se_friends.friend_id=se_friendexplains.friendexplain_friend_id
WHERE
friend_status='1' AND visitor_invisible=0 AND visitor_lastactive>'1337705805'
&&
friend_user_id1='33254'
ORDER BY se_users.user_username LIMIT 0, 10
Dark Fetish Network - Shaun's Profile
