2025-10-22 20:11##Error en la orden: SELECT * FROM (
SELECT
CASE WHEN empresa LIKE '%distrito capital%' 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 ('+distrito* +capital*' IN BOOLEAN MODE) AS score
FROM DIRECTORIO
WHERE activo='1' AND visible='1' AND eliminado='0' AND (( AND (poblacion LIKE '%Distrito Capital%' OR direccion LIKE '%Distrito Capital%') AND (
MATCH (empresa,direccion,poblacion,descripcion) AGAINST ('+distrito* +capital*' IN BOOLEAN MODE)
OR MATCH (empresa,direccion,poblacion,descripcion) AGAINST ('distrito-capital' IN BOOLEAN MODE)
) AND pais='HN') OR MATCH (keywords) AGAINST ('Distrito Capital'))
) 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####