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 score
FROM link_links AS l
LEFT JOIN link_comments AS c ON l.id = c.link_id
LEFT JOIN link_score AS s ON l.id = s.link_id
LEFT JOIN link_members AS m ON l.uploader = m.id
GROUP BY l.title
ORDER BY l.upload_date DESC, l.id DESC
LIMIT 0, 20