Martes, 25 de septiembre de 2018

Machu Pichu

SELECT p.ID FROM productos_es as p LEFT JOIN producto_hotel as ph ON ID_Producto = p.ID AND ph.Tipo_Producto = 'Paquete' LEFT JOIN hoteles_es as h ON ph.ID_Hotel = h.ID WHERE Archivado!='1' AND p.Visible='1' AND p.Idioma = 'espanol' AND (Vencimiento='0000-00-00' OR (Alta <= '2018-09-25' AND Vencimiento >= '2018-09-25')) AND MATCH (Tags) AGAINST ('"Machu Pichu"' IN BOOLEAN MODE) GROUP BY p.ID ORDER BY p.Orden

Error: Can't find FULLTEXT index matching the column list