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='PRDPV' AND CN.id_lingua='en'