Untitled.sql

SELECT L1.friend_id, DATE_FORMAT(L1.created_at,'%b %d %Y') as friend_created_at, users.first_name, users.last_name, users.email, users.num_friends, users.level, DATE_FORMAT(users.created_at,'%b %d %Y') as users_created_at FROM   friends L1 left join users ON users.id = L1.friend_id  WHERE user_id = 1 AND EXISTS(SELECT * FROM   friends L2 WHERE not L1.user_id = L2.friend_id AND L1.friend_id = L2.user_id) ORDER BY L1.created_at DESC