SELECT e.*, p.Adm_name, p.Adm_id, (SELECT GROUP_CONCAT(a2.Art_nombre) from nv_artistas a2, nv_artistas_eventos ae2 WHERE a2.Art_id = ae2.Art_id AND ae2.Ev_id = e.Ev_id) as lista_artistas FROM nv_eventos e, nv_artistas_eventos ae, nv_adm2 p WHERE e.Ev_id = ae.Ev_id AND e.Ev_moderate = 0 AND e.Adm_id = p.Adm_id AND e.Ev_Fecha_inicio > NOW() AND e.Cou_code = 165 AND e.Ev_entradas_URL = 1 AND e.Ev_cancelado_sn = 0 GROUP BY e.Ev_id ORDER BY Ev_visitas DESC LIMIT 0,75 Tickets directory - 5gig.com

Download the 5gig.com app and be the first to find out when your favorite artists go on tour