SELECT b.id_bien, IF(b.cache_prix_min > 0, cache_prix_min, 999999) as cache_prix, b.id_station2 as id_station, bp.date_debut, DATE_ADD(NOW(), INTERVAL a.delai DAY)
      FROM bien b 
      LEFT JOIN station2 s ON b.id_station2 = s.id_station2 
      LEFT JOIN agence a ON b.id_agence = a.id_agence 
      LEFT JOIN bien_prix bp ON b.id_bien = bp.id_bien
      LEFT JOIN quartier q ON b.id_quartier = q.id_quartier
      LEFT JOIN secteur sr ON q.id_secteur = sr.id_secteur
      LEFT JOIN bien_service_niveau bsn ON b.id_bien_service_niveau = bsn.id_bien_service_niveau			
      LEFT JOIN bien_etage be ON b.id_bien = be.id_bien			
      LEFT JOIN condition_annulation ca ON b.id_condition_annulation = ca.id_condition_annulation
      LEFT JOIN residence res ON b.id_residence = res.id_residence
      WHERE 
      b.actif = 'oui' AND b.id_station2 IN (2)  AND b.type_bien IN ('appartement')  AND ouverture_to IN ('B2C','Les deux')  AND (b.nb_adultes + b.nb_enfants >= Array)  GROUP BY id_bien  ORDER BY poids_cache DESC, id_bien <br />object(mysqli_sql_exception)#3717 (8) {
  ["message":protected]=>
  string(40) "Unknown column 'Array' in 'where clause'"
  ["string":"Exception":private]=>
  string(0) ""
  ["code":protected]=>
  int(1054)
  ["file":protected]=>
  string(58) "/web/cimalpes.com/modules/database/controller/database.php"
  ["line":protected]=>
  int(35)
  ["trace":"Exception":private]=>
  array(9) {
    [0]=>
    array(4) {
      ["file"]=>
      string(58) "/web/cimalpes.com/modules/database/controller/database.php"
      ["line"]=>
      int(35)
      ["function"]=>
      string(12) "mysqli_query"
      ["args"]=>
      array(2) {
        [0]=>
        object(mysqli)#2 (18) {
          ["affected_rows"]=>
          int(-1)
          ["client_info"]=>
          string(14) "mysqlnd 8.1.27"
          ["client_version"]=>
          int(80127)
          ["connect_errno"]=>
          int(0)
          ["connect_error"]=>
          NULL
          ["errno"]=>
          int(1054)
          ["error"]=>
          string(40) "Unknown column 'Array' in 'where clause'"
          ["error_list"]=>
          array(1) {
            [0]=>
            array(3) {
              ["errno"]=>
              int(1054)
              ["sqlstate"]=>
              string(5) "42S22"
              ["error"]=>
              string(40) "Unknown column 'Array' in 'where clause'"
            }
          }
          ["field_count"]=>
          int(3)
          ["host_info"]=>
          string(22) "10.55.32.70 via TCP/IP"
          ["info"]=>
          NULL
          ["insert_id"]=>
          int(0)
          ["server_info"]=>
          string(13) "5.7.35-38-log"
          ["server_version"]=>
          int(50735)
          ["sqlstate"]=>
          string(5) "42S22"
          ["protocol_version"]=>
          int(10)
          ["thread_id"]=>
          int(60556612)
          ["warning_count"]=>
          int(0)
        }
        [1]=>
        string(1037) "
    	SELECT b.id_bien, IF(b.cache_prix_min > 0, cache_prix_min, 999999) as cache_prix, b.id_station2 as id_station, bp.date_debut, DATE_ADD(NOW(), INTERVAL a.delai DAY)
      FROM bien b 
      LEFT JOIN station2 s ON b.id_station2 = s.id_station2 
      LEFT JOIN agence a ON b.id_agence = a.id_agence 
      LEFT JOIN bien_prix bp ON b.id_bien = bp.id_bien
      LEFT JOIN quartier q ON b.id_quartier = q.id_quartier
      LEFT JOIN secteur sr ON q.id_secteur = sr.id_secteur
      LEFT JOIN bien_service_niveau bsn ON b.id_bien_service_niveau = bsn.id_bien_service_niveau			
      LEFT JOIN bien_etage be ON b.id_bien = be.id_bien			
      LEFT JOIN condition_annulation ca ON b.id_condition_annulation = ca.id_condition_annulation
      LEFT JOIN residence res ON b.id_residence = res.id_residence
      WHERE 
      b.actif = 'oui' AND b.id_station2 IN (2)  AND b.type_bien IN ('appartement')  AND ouverture_to IN ('B2C','Les deux')  AND (b.nb_adultes + b.nb_enfants >= Array)  GROUP BY id_bien  ORDER BY poids_cache DESC, id_bien "
      }
    }
    [1]=>
    array(6) {
      ["file"]=>
      string(46) "/web/cimalpes.com/modules/bien/model/biens.php"
      ["line"]=>
      int(260)
      ["function"]=>
      string(6) "select"
      ["class"]=>
      string(8) "Database"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        string(1037) "
    	SELECT b.id_bien, IF(b.cache_prix_min > 0, cache_prix_min, 999999) as cache_prix, b.id_station2 as id_station, bp.date_debut, DATE_ADD(NOW(), INTERVAL a.delai DAY)
      FROM bien b 
      LEFT JOIN station2 s ON b.id_station2 = s.id_station2 
      LEFT JOIN agence a ON b.id_agence = a.id_agence 
      LEFT JOIN bien_prix bp ON b.id_bien = bp.id_bien
      LEFT JOIN quartier q ON b.id_quartier = q.id_quartier
      LEFT JOIN secteur sr ON q.id_secteur = sr.id_secteur
      LEFT JOIN bien_service_niveau bsn ON b.id_bien_service_niveau = bsn.id_bien_service_niveau			
      LEFT JOIN bien_etage be ON b.id_bien = be.id_bien			
      LEFT JOIN condition_annulation ca ON b.id_condition_annulation = ca.id_condition_annulation
      LEFT JOIN residence res ON b.id_residence = res.id_residence
      WHERE 
      b.actif = 'oui' AND b.id_station2 IN (2)  AND b.type_bien IN ('appartement')  AND ouverture_to IN ('B2C','Les deux')  AND (b.nb_adultes + b.nb_enfants >= Array)  GROUP BY id_bien  ORDER BY poids_cache DESC, id_bien "
      }
    }
    [2]=>
    array(6) {
      ["file"]=>
      string(55) "/web/cimalpes.com/modules/recherche/model/recherche.php"
      ["line"]=>
      int(76)
      ["function"]=>
      string(22) "getBiensBySearchParams"
      ["class"]=>
      string(5) "Biens"
      ["type"]=>
      string(2) "::"
      ["args"]=>
      array(1) {
        [0]=>
        object(BienSearchParams)#3683 (21) {
          ["ids"]=>
          uninitialized(?array)
          ["orderBy"]=>
          NULL
          ["sens"]=>
          NULL
          ["date_debut"]=>
          uninitialized(string)
          ["date_fin"]=>
          uninitialized(string)
          ["limit"]=>
          int(21)
          ["type_user"]=>
          enum(TypeUser::B2C)
          ["langue_suffix"]=>
          string(3) "_en"
          ["montant_min"]=>
          float(0)
          ["prix_min"]=>
          NULL
          ["prix_max"]=>
          NULL
          ["surface_min"]=>
          NULL
          ["surface_max"]=>
          NULL
          ["pagination"]=>
          bool(false)
          ["station_ids"]=>
          array(1) {
            [0]=>
            int(2)
          }
          ["secteurs_ids"]=>
          uninitialized(?array)
          ["nb_chambre"]=>
          int(-1)
          ["offres_speciales"]=>
          NULL
          ["periode"]=>
          uninitialized(?TypePeriode)
          ["quartier_ids"]=>
          uninitialized(?array)
          ["promotion_ids"]=>
          NULL
          ["collection_ids"]=>
          array(0) {
          }
          ["type_biens"]=>
          array(1) {
            [0]=>
            enum(TypeBienEnum::Appartement)
          }
          ["style_id"]=>
          uninitialized(?int)
          ["espace_loisir_ids"]=>
          uninitialized(?array)
          ["is_promotion"]=>
          bool(false)
          ["annulation_flexible"]=>
          NULL
          ["price_changed"]=>
          bool(false)
          ["nb_adultes"]=>
          int(1)
        }
      }
    }
    [3]=>
    array(6) {
      ["file"]=>
      string(55) "/web/cimalpes.com/modules/recherche/model/recherche.php"
      ["line"]=>
      int(60)
      ["function"]=>
      string(8) "getBiens"
      ["class"]=>
      string(9) "Recherche"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        object(BienSearchParams)#3683 (21) {
          ["ids"]=>
          uninitialized(?array)
          ["orderBy"]=>
          NULL
          ["sens"]=>
          NULL
          ["date_debut"]=>
          uninitialized(string)
          ["date_fin"]=>
          uninitialized(string)
          ["limit"]=>
          int(21)
          ["type_user"]=>
          enum(TypeUser::B2C)
          ["langue_suffix"]=>
          string(3) "_en"
          ["montant_min"]=>
          float(0)
          ["prix_min"]=>
          NULL
          ["prix_max"]=>
          NULL
          ["surface_min"]=>
          NULL
          ["surface_max"]=>
          NULL
          ["pagination"]=>
          bool(false)
          ["station_ids"]=>
          array(1) {
            [0]=>
            int(2)
          }
          ["secteurs_ids"]=>
          uninitialized(?array)
          ["nb_chambre"]=>
          int(-1)
          ["offres_speciales"]=>
          NULL
          ["periode"]=>
          uninitialized(?TypePeriode)
          ["quartier_ids"]=>
          uninitialized(?array)
          ["promotion_ids"]=>
          NULL
          ["collection_ids"]=>
          array(0) {
          }
          ["type_biens"]=>
          array(1) {
            [0]=>
            enum(TypeBienEnum::Appartement)
          }
          ["style_id"]=>
          uninitialized(?int)
          ["espace_loisir_ids"]=>
          uninitialized(?array)
          ["is_promotion"]=>
          bool(false)
          ["annulation_flexible"]=>
          NULL
          ["price_changed"]=>
          bool(false)
          ["nb_adultes"]=>
          int(1)
        }
      }
    }
    [4]=>
    array(6) {
      ["file"]=>
      string(55) "/web/cimalpes.com/modules/recherche/model/recherche.php"
      ["line"]=>
      int(28)
      ["function"]=>
      string(7) "execute"
      ["class"]=>
      string(9) "Recherche"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        object(BienSearchParams)#3683 (21) {
          ["ids"]=>
          uninitialized(?array)
          ["orderBy"]=>
          NULL
          ["sens"]=>
          NULL
          ["date_debut"]=>
          uninitialized(string)
          ["date_fin"]=>
          uninitialized(string)
          ["limit"]=>
          int(21)
          ["type_user"]=>
          enum(TypeUser::B2C)
          ["langue_suffix"]=>
          string(3) "_en"
          ["montant_min"]=>
          float(0)
          ["prix_min"]=>
          NULL
          ["prix_max"]=>
          NULL
          ["surface_min"]=>
          NULL
          ["surface_max"]=>
          NULL
          ["pagination"]=>
          bool(false)
          ["station_ids"]=>
          array(1) {
            [0]=>
            int(2)
          }
          ["secteurs_ids"]=>
          uninitialized(?array)
          ["nb_chambre"]=>
          int(-1)
          ["offres_speciales"]=>
          NULL
          ["periode"]=>
          uninitialized(?TypePeriode)
          ["quartier_ids"]=>
          uninitialized(?array)
          ["promotion_ids"]=>
          NULL
          ["collection_ids"]=>
          array(0) {
          }
          ["type_biens"]=>
          array(1) {
            [0]=>
            enum(TypeBienEnum::Appartement)
          }
          ["style_id"]=>
          uninitialized(?int)
          ["espace_loisir_ids"]=>
          uninitialized(?array)
          ["is_promotion"]=>
          bool(false)
          ["annulation_flexible"]=>
          NULL
          ["price_changed"]=>
          bool(false)
          ["nb_adultes"]=>
          int(1)
        }
      }
    }
    [5]=>
    array(6) {
      ["file"]=>
      string(48) "/web/cimalpes.com/modules/contenu/model/page.php"
      ["line"]=>
      int(127)
      ["function"]=>
      string(11) "__construct"
      ["class"]=>
      string(9) "Recherche"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(2) {
        [0]=>
        enum(TypeRecherche::Biens)
        [1]=>
        object(BienSearchParams)#3683 (21) {
          ["ids"]=>
          uninitialized(?array)
          ["orderBy"]=>
          NULL
          ["sens"]=>
          NULL
          ["date_debut"]=>
          uninitialized(string)
          ["date_fin"]=>
          uninitialized(string)
          ["limit"]=>
          int(21)
          ["type_user"]=>
          enum(TypeUser::B2C)
          ["langue_suffix"]=>
          string(3) "_en"
          ["montant_min"]=>
          float(0)
          ["prix_min"]=>
          NULL
          ["prix_max"]=>
          NULL
          ["surface_min"]=>
          NULL
          ["surface_max"]=>
          NULL
          ["pagination"]=>
          bool(false)
          ["station_ids"]=>
          array(1) {
            [0]=>
            int(2)
          }
          ["secteurs_ids"]=>
          uninitialized(?array)
          ["nb_chambre"]=>
          int(-1)
          ["offres_speciales"]=>
          NULL
          ["periode"]=>
          uninitialized(?TypePeriode)
          ["quartier_ids"]=>
          uninitialized(?array)
          ["promotion_ids"]=>
          NULL
          ["collection_ids"]=>
          array(0) {
          }
          ["type_biens"]=>
          array(1) {
            [0]=>
            enum(TypeBienEnum::Appartement)
          }
          ["style_id"]=>
          uninitialized(?int)
          ["espace_loisir_ids"]=>
          uninitialized(?array)
          ["is_promotion"]=>
          bool(false)
          ["annulation_flexible"]=>
          NULL
          ["price_changed"]=>
          bool(false)
          ["nb_adultes"]=>
          int(1)
        }
      }
    }
    [6]=>
    array(6) {
      ["file"]=>
      string(48) "/web/cimalpes.com/modules/contenu/model/page.php"
      ["line"]=>
      int(28)
      ["function"]=>
      string(8) "getBlocs"
      ["class"]=>
      string(4) "Page"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(0) {
      }
    }
    [7]=>
    array(6) {
      ["file"]=>
      string(56) "/web/cimalpes.com/modules/contenu/controller/contenu.php"
      ["line"]=>
      int(6)
      ["function"]=>
      string(11) "__construct"
      ["class"]=>
      string(4) "Page"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        int(29)
      }
    }
    [8]=>
    array(4) {
      ["file"]=>
      string(27) "/web/cimalpes.com/index.php"
      ["line"]=>
      int(4)
      ["args"]=>
      array(1) {
        [0]=>
        string(56) "/web/cimalpes.com/modules/contenu/controller/contenu.php"
      }
      ["function"]=>
      string(12) "require_once"
    }
  }
  ["previous":"Exception":private]=>
  NULL
  ["sqlstate":protected]=>
  string(5) "42S22"
}