Anonymous

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, AVG( link_score.score ) AS score, COUNT( link_score.id ) AS number_of_votes, COUNT( link_comments.id ) AS number_of_commentsFROM 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.upload_date DESC , link_links.id DESCLIMIT 0 , 20