SELECT
a.fol_id, a.fol_b, b.usr_id, b.usr_nick, b.usr_avatar, b.usr_cover,
( SELECT a.fol_a
FROM followers a
WHERE a.fol_a = 0
AND a.fol_b = b.usr_id
) AS following
FROM followers a
LEFT JOIN users b ON a.fol_b = b.usr_id
WHERE a.fol_a = 4
ORDER BY following DESC, usr_id DESC
Connections | Tuetego
