[Solved] How to count total comment in a category not a topic

by

[ad_1]

select cat_id, count(1) cnt 
     from category 
     join topic on cat_is = cat_id
     join comment on topic_is = topic_id
  group by cat_id

[ad_2]

solved How to count total comment in a category not a topic