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-28 01:18:50' AND streaming=1 and pais = 'mexico' ORDER BY usuario asc ,nombre ASC
No hay Eventos disponibles.