Anonymous

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, AVG(s.score) AS score,       COUNT(c.id) AS number_of_commentsFROM 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 c.link_id, s.link_idORDER BY l.id DESCLIMIT 0, 30