Select id from tm_templates where visible=1 and (keywords_fr like '%main-d'œuvre%' OR description like '%main-d'œuvre%') and adult=0 order by id desc
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 'œuvre%' OR description like '%main-d'œuvre%') and adult=0 order by id d' at line 1