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 '1401,%' OR user_blocklist LIKE '%,1401' OR user_blocklist LIKE '%,1401,%') 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='1401'
ORDER BY se_users.user_username LIMIT 0, 10