Resultado de Búsqueda

SELECT TOU.id_tour AS id FROM tbl_con_tour_searcher AS TOU INNER JOIN tbl_con_moneda AS MON ON MON.id_moneda = TOU.temp_id_moneda WHERE TOU.estado = 'A' AND TOU.ipublicadox = 1 AND (TOU.codigoxxxxx LIKE '%estrella%' OR TOU.tituloxxxxx LIKE '%estrella%' OR TOU.keywordsxxx LIKE '%estrella%' OR TOU.detalle_min LIKE '%estrella%' OR TOU.html_conten LIKE '%estrella%' OR TOU.detalle_leg LIKE '%estrella%' OR TOU.categorias_titulos LIKE '%estrella%' OR TOU.html_resume LIKE '%estrella%') AND ( TOU.fechasxxxxx_all REGEXP '-' ) ORDER BY LOCATE('-' , TOU.fechasxxxxx_all) DESC