A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'group by article.cat_id' at line 1

SELECT article_cat.*,count(article.id) as scount FROM article_cat,article WHERE article_cat.id=article.cat_id and article_cat.parents= group by article.cat_id