Could not execute SQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.enable=1 GROUP BY c.id ORDER BY c.ordering LIMIT 0,100' at line 2

SELECT c.*, count(a.id) as total_article , c.name,c.alias,c.description FROM lhm_device_categories AS c LEFT JOIN lhm_device AS a ON a.catid = c.id WHERE c.parent= AND c.enable=1 GROUP BY c.id ORDER BY c.ordering LIMIT 0,100