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 pd.language_id = '4' order by p.servicesdesk_type desc, pd....' at line 9

select p.*, pd.*, p2c.*, l.* from servicesdesk p, servicesdesk_description pd, prefectures_description l, servicesdesk_to_categories p2c where p.servicesdesk_status = '1' and p.servicesdesk_id = p2c.servicesdesk_id and p.servicesdesk_id = pd.servicesdesk_id and pd.servicesdesk_id = p2c.servicesdesk_id and pd.servicesdesk_service_prefecture_id = l.prefecture_id and p2c.categories_id = and pd.language_id = '4' order by p.servicesdesk_type desc, pd.servicesdesk_service_lastname asc