Server shutdown in progress SELECT COUNT(id_article) AS total, id_category FROM eshop_articles_categorys WHERE id_article IN (SELECT id FROM eshop_articles WHERE sold<1) GROUP BY id_category ;