Cine

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=4) AND (e.id_temporada=20)) ORDER BY d.fecha ASC,d.hora ASC