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
,
CASE
WHEN (SELECT TRUE FROM se_users AS se_users2 WHERE se_users2.user_id=se_users.user_id AND (user_blocklist LIKE '32507,%' OR user_blocklist LIKE '%,32507' OR user_blocklist LIKE '%,32507,%') 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'
&&
friend_user_id1='32507'
ORDER BY se_users.user_username LIMIT 0, 10