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