SELECT link_links.id, link_links.title, link_links.description, link_links.viewed, link_links.upload_date, link_links.url, link_links.category, link_links.language, link_links.media_type, link_members.id as member_id, link_members.username, link_members.real_name, link_members.private_avatar, COUNT(link_score.id) AS number_of_votes, COUNT(link_comments.id) AS number_of_comments, AVG(link_score.score) AS score
FROM link_links
LEFT JOIN link_comments ON link_links.id = link_comments.link_id
LEFT JOIN link_score ON link_links.id = link_score.link_id
LEFT JOIN link_members ON link_links.uploader = link_members.id
GROUP BY link_links.title
ORDER BY link_links.upload_date DESC, link_links.id DESC
LIMIT 0, 20