Unnamed

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 scoreFROM link_linksLEFT JOIN link_comments ON link_links.id = link_comments.link_idLEFT JOIN link_score ON link_links.id = link_score.link_idLEFT JOIN link_members ON link_links.uploader = link_members.idGROUP BY link_links.titleORDER BY link_links.upload_date DESC, link_links.id DESCLIMIT 0, 20