2025-05-09 16:06##Error en la orden: SELECT * FROM (
SELECT
CASE WHEN empresa LIKE '%cuba, comercial, la habana%' 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 ('+cuba,* +comercial,* +la* +habana*' IN BOOLEAN MODE) AS score
FROM DIRECTORIO
WHERE activo='1' AND visible='1' AND eliminado='0' AND (( AND (poblacion LIKE '%La Habana%' OR direccion LIKE '%La Habana%') AND (
MATCH (empresa,direccion,poblacion,descripcion) AGAINST ('+cuba,* +comercial,* +la* +habana*' IN BOOLEAN MODE)
OR MATCH (empresa,direccion,poblacion,descripcion) AGAINST ('cuba-comercial-la-habana' IN BOOLEAN MODE)
) AND pais='CU') OR MATCH (keywords) AGAINST ('La Habana'))
) AS tab
ORDER BY cliente DESC, plan DESC, puntuacion DESC, orden DESC, rnk, score DESC, last_print DESC, fecha_registro DESC, empresa
LIMIT 36, 12####