SELECT DISTINCT pl.id_product FROM ms_product_lang pl LEFT JOIN ms_product p ON pl.id_product = p.id_product where (pl.name like '%cobra %' and pl.name like '%space %') or (pl.description like '%cobra %' and pl.description like '%space %') or pl.name like '%cobra space%'or (select count(name) from ms_tag as t LEFT JOIN ms_product_tag as pt on pt.id_tag=t.id_tag where p.id_product=pt.id_product and name like 'cobra space')>0
Rechercher
