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 '31699,%' OR user_blocklist LIKE '%,31699' OR user_blocklist LIKE '%,31699,%') 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>'1337705732'
&&
friend_user_id1='31699'
ORDER BY se_users.user_username LIMIT 0, 10
Dark Fetish Network - Thomas Reinhard's Profile
