2025-05-07 20:22##Error en la orden: SELECT * FROM (
SELECT
CASE WHEN empresa LIKE '%villanueva%' 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
FROM DIRECTORIO
WHERE activo='1' AND visible='1' AND eliminado='0' AND (( AND (poblacion LIKE '%Villanueva%' OR direccion LIKE '%Villanueva%') AND (
empresa LIKE '%villanueva%' OR
direccion LIKE '%villanueva%' OR
poblacion LIKE '%villanueva%' OR
descripcion LIKE '%villanueva%'
) AND pais='HN') OR MATCH (keywords) AGAINST ('Villanueva'))
) AS tab
ORDER BY cliente DESC, plan DESC, puntuacion DESC, orden DESC, rnk, last_print DESC, fecha_registro DESC, empresa
LIMIT 0, 12####