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 like '%template** %' OR a.software_required REGEXP 'template**')  and adult=0 order by id desc <BR>Got error 'repetition-operator operand invalid' from regexp