SELECT distinct *, (SELECT miniatura FROM eventos_galerias WHERE evento = eventos.id AND imagen<>'' ORDER BY orden ASC LIMIT 1) AS miniatura, (SELECT recorte FROM eventos_galerias WHERE evento = eventos.id AND imagen<>'' ORDER BY orden ASC LIMIT 1) AS recorte FROM eventos WHERE estado_evento='1' AND tipo='0' AND fecha_inicio>='01-04-2024 00:00:00' and fecha_inicio<='2024-04-26 18:29:54' AND streaming=1 and pais = 'ecuador' ORDER BY usuario asc ,nombre ASC
No hay Eventos disponibles.