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


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

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