Success!Better check yourself, you're not looking too good.
SELECT immo.*,foto.url,foto.immagine_intro FROM `#__wire_immogest_standard` as immo LEFT JOIN `#__wire_immogest_images` as foto on immo.id=foto.id where (immagine_intro=1 or immagine_intro is null) AND (lottizzazione=1 AND tags NOT LIKE '%coccinella%' AND tags NOT LIKE '%borghetto%') ORDER BY `immo`.id ASC