Table 'prefix_articles' is marked as crashed and should be repairedSELECT prefix_category.category_name as cname,prefix_category.category_id as cid,
    count(prefix_articles.article_id) as arr FROM prefix_articles right join
    prefix_category on
    prefix_category.category_id= prefix_articles.category_id
    and prefix_articles.status='A' where prefix_category.category_root='9'
    group by prefix_category.category_id
    order by cname