SELECT e.*,
							 f.path
					FROM portale.elemento as e 
			         LEFT JOIN netring._tab_file AS f ON e.immagine = f.cod_file       
			      WHERE e.news = '30392'	   
				      AND e.pubblica
					  AND e.tipo != 23
					  AND e.visibilita <= 1
					  and (e.scadenza is NULL or e.scadenza > current_date)
				  ORDER BY e.posizione