Select distinct id from tm_templates a, tm_templates_to_categories b where a.visible=1 and a.id = b.template_id and id=template_id and type_id='43' and (a.keywords_fr like '% men's %' OR a.keywords like '% men's %' OR a.software_required like '%men's%') 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 's %' OR a.keywords like '% men's %' OR a.software_required like '%men's%') and ' at line 1