Select distinct id  from tm_templates a,  tm_templates_to_categories b  where a.visible=1 and a.id = b.template_id and (a.keywords_fr like '%aujourd'hui%' OR a.description like '%aujourd'hui%')  and adult=0 order by id desc <BR>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 'hui%' OR a.description like '%aujourd'hui%')  and adult=0 order by id desc' at line 1