SELECT CN.*, F1.url as url_foto_pres FROM parks.comuni_note CN
	 		LEFT OUTER JOIN  parks.foto F1 ON (CN.id_foto_pres=F1.id AND F1.id_lingua='en')
	 		WHERE CN.id_ap='PRCRO' AND CN.id_lingua='en'