Вопросы и ответы о сайте для программистов
SELECT * FROM (SELECT "tag"."id" as "tag_id", COUNT("post"."id") as "totalQuestions" FROM "Tags" "tag" LEFT JOIN "PostTags" "post_tag" ON "post_tag"."tagId"="tag"."id" LEFT JOIN "Posts" "post" ON "post"."id"="post_tag"."postId" GROUP BY "tag"."id") "y" LEFT JOIN "Tags" "x" on "x"."id" = "y"."tag_id"