Query ML búsqueda tags

MLquerytags

SELECT pl.name, pl.id_product, price
FROM ps_product p
LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product
WHERE pl.id_lang = 1 AND p.id_product IN (
SELECT pt.id_product
FROM ps_product_tag pt, ps_tag pp
WHERE pp.name REGEXP "[[:<:]]Cuerpo|hasta25[[:>:]]" AND pt.id_tag=pp.id_tag)