Q&A for professional and amateur woodworkers
SELECT post.id,comment.post_count FROM posts as post INNER JOIN ( SELECT postid,count(*) AS post_count FROM comments GROUP BY postid ) as comment on post.id = comment.postid Order by comment.post_count desc