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 'AND cd.language_id = 4' at line 1

SELECT cd2.categories_name AS pName, cd.categories_name AS cName FROM kbh_categories c LEFT JOIN kbh_categories_description cd2 ON c.parent_id = cd2.categories_id AND c.parent_id = cd2.categories_id AND cd2.language_id = 4, kbh_categories_description cd WHERE c.categories_id = cd.categories_id AND c.categories_id = AND cd.language_id = 4