Server shutdown in progressSELECT dslone63_category.category_name as cname,dslone63_category.category_id as cid,
    count(dslone63_articles.article_id) as arr FROM dslone63_articles right join
    dslone63_category on
    dslone63_category.category_id= dslone63_articles.category_id
    and dslone63_articles.status='A' where dslone63_category.category_root='4'
    group by dslone63_category.category_id
    order by cname