La Torre

SELECT i.cod,i.link, i.alt, m.path FROM gmbanner_3.inserzioni as i JOIN gmbanner_3.zone as z ON i.cod_zona = z.cod JOIN gmbanner_3.media as m ON i.cod_media = m.cod WHERE z.zona = 'scheda' AND z.dominio = 'gustamodena.it' AND i.stato = 1 AND NOW() BETWEEN i.inizio AND i.fine AND i.cod_committente = 8250 LIMIT 1