2025-04-21 17:53##Error en la orden: SELECT * FROM ( SELECT CASE WHEN empresa LIKE '%santa cruz de tenerife%' THEN 1 ELSE 2 END AS rnk, id, cliente, empresa, direccion, poblacion, pais, img_logo, img_flyer, slug, puntuacion, plan, clase, mail_bienvenida, orden, fecha_registro, last_print , MATCH (empresa,direccion,poblacion,descripcion) AGAINST ('+santa* +cruz* +de* +tenerife*' IN BOOLEAN MODE) AS score FROM DIRECTORIO WHERE activo='1' AND visible='1' AND eliminado='0' AND (( AND (poblacion LIKE '%Santa Cruz de Tenerife%' OR direccion LIKE '%Santa Cruz de Tenerife%') AND ( MATCH (empresa,direccion,poblacion,descripcion) AGAINST ('+santa* +cruz* +de* +tenerife*' IN BOOLEAN MODE) OR MATCH (empresa,direccion,poblacion,descripcion) AGAINST ('santa-cruz-de-tenerife' IN BOOLEAN MODE) ) AND pais='ES') OR MATCH (keywords) AGAINST ('Santa Cruz de Tenerife')) ) AS tab ORDER BY cliente DESC, plan DESC, puntuacion DESC, orden DESC, rnk, score DESC, last_print DESC, fecha_registro DESC, empresa LIMIT 0, 12####