SELECT l.id, l.title, l.description, l.viewed, l.upload_date, l.url, l.category, l.language, l.media_type, m.id as member_id, m.username, m.real_name, m.private_avatar, COUNT(s.id) AS number_of_votes, COUNT(c.id) AS number_of_comments, AVG(s.score) AS scoreFROM link_links AS lLEFT JOIN link_comments AS c ON l.id = c.link_idLEFT JOIN link_score AS s ON l.id = s.link_idLEFT JOIN link_members AS m ON l.uploader = m.idGROUP BY l.titleORDER BY l.upload_date DESC, l.id DESCLIMIT 0, 20