Query execution was interruptedSELECT category.category_name as cname,category.category_id as cid,
    count(articles.article_id) as arr FROM articles right join
    category on
    category.category_id= articles.category_id
    and articles.status='A' where category.category_root='6'
    group by category.category_id
    order by cname