Fatal error: Uncaught SystemException: Unknown column 'comuni.latitudine' in 'field list' - sql:
SELECT COUNT(tmp.id_annuncio) AS num
FROM (
SELECT a.id_annuncio,
IF((a.latitudine = 0 OR a.nascondi_indirizzo = 1), comuni.latitudine, a.latitudine) AS latitudine_ok,
IF((a.longitudine = 0 OR a.nascondi_indirizzo = 1), comuni.longitudine, a.longitudine) AS longitudine_ok
FROM annunci AS a
WHERE a.visualizza=1 AND a.id_comune = 28 AND a.id_contratto = 2 AND a.id_tipologia_frontend = 1 AND a.id_quartiere IN ('262')
GROUP BY a.id_annuncio
) tmp in /var/www/oikia/class/Database.class.php:166
Stack trace:
#0 /var/www/oikia/class/ControllerSite.class.php(2345): Database->query('SELECT COUNT(tm...')
#1 /var/www/oikia/class/ControllerSite.class.php(2044): ControllerSite->getNumAdvertisements(Array, true)
#2 /var in /var/www/oikia/class/Database.class.php on line 166