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 contact Côte d'Azur / French Riviera - Next Home
  • FR
  • EN