SELECT content.*, (SELECT COUNT(comments.record_num) FROM comments WHERE comments.type = 0 AND comments.content = content.record_num) AS counter, (SELECT content_views.views FROM content_views WHERE content_views.content = content.record_num) as views , (SELECT images.filename FROM images WHERE images.record_num = content.thumbnail) AS thumbfile FROM content WHERE content.enabled = 1 AND photos = 0 ORDER BY counter DESC LIMIT 288,36 Most Discussed Gay Tube Videos at GayBoysTube