Familiar

SELECT e.* FROM mod_eventos as e INNER JOIN mod_eventos_date as d ON ((e.visible=2) AND (e.id=d.id_evento) AND (d.id_categoria=1) AND (TO_DAYS(CURRENT_DATE) <= TO_DAYS(d.fecha)) ) ORDER BY d.fecha ASC,d.hora ASC