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 'AND `ac`.`parentId` = 1 AND ( SELECT COUNT(*) FROM `a' at line 13