Notice: Location: /router.php
Action: sel
Message: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nexthome.departament.departament_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query: SELECT departament_title,departament_id,
SUM(immobile_pieces = 1) AS count1,
SUM(immobile_pieces = 2) AS count2,
SUM(immobile_pieces = 3) AS count3,
SUM(immobile_pieces = 4) AS count4,
SUM(immobile_pieces = 5) AS count5
FROM immobile
INNER JOIN agency ON agency_id = immobile_agency_id
INNER JOIN city ON city_id=immobile_city_id
INNER JOIN departament ON departament_id=city_departament_id
WHERE agency_active =1 AND departament_active=1 AND immobile_active = 1 AND immobile_immobiletype_id=1 AND immobile_nature_id=0 in /var/www/html/nexthome.fr/intranet/class/myres.php on line 191 Achat compte Côte d'Azur / French Riviera - Next Home
