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 ouverture_to IN ('B2C','Les deux')  GROUP BY id_bien  ORDER BY poids_cache DESC, id_bien  LIMIT 0, 20<br />object(mysqli_sql_exception)#5073 (8) {
  ["message":protected]=>
  string(40) "Table 'extranet.bien_prix' doesn't exist"
  ["string":"Exception":private]=>
  string(0) ""
  ["code":protected]=>
  int(1146)
  ["file":protected]=>
  string(58) "/web/cimalpes.com/modules/database/controller/database.php"
  ["line":protected]=>
  int(35)
  ["trace":"Exception":private]=>
  array(10) {
    [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.28"
          ["client_version"]=>
          int(80128)
          ["connect_errno"]=>
          int(0)
          ["connect_error"]=>
          NULL
          ["errno"]=>
          int(1146)
          ["error"]=>
          string(40) "Table 'extranet.bien_prix' doesn't exist"
          ["error_list"]=>
          array(1) {
            [0]=>
            array(3) {
              ["errno"]=>
              int(1146)
              ["sqlstate"]=>
              string(5) "42S02"
              ["error"]=>
              string(40) "Table 'extranet.bien_prix' doesn't exist"
            }
          }
          ["field_count"]=>
          int(5)
          ["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) "42S02"
          ["protocol_version"]=>
          int(10)
          ["thread_id"]=>
          int(61887295)
          ["warning_count"]=>
          int(0)
        }
        [1]=>
        string(943) "
    	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 ouverture_to IN ('B2C','Les deux')  GROUP BY id_bien  ORDER BY poids_cache DESC, id_bien  LIMIT 0, 20"
      }
    }
    [1]=>
    array(6) {
      ["file"]=>
      string(41) "/web/cimalpes.com/include/ListDBModel.php"
      ["line"]=>
      int(16)
      ["function"]=>
      string(6) "select"
      ["class"]=>
      string(8) "Database"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(3) {
        [0]=>
        string(943) "
    	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 ouverture_to IN ('B2C','Les deux')  GROUP BY id_bien  ORDER BY poids_cache DESC, id_bien  LIMIT 0, 20"
        [1]=>
        string(4) "Bien"
        [2]=>
        array(17) {
          [0]=>
          string(7) "id_bien"
          [1]=>
          array(1) {
            ["with_collection"]=>
            bool(false)
          }
          [2]=>
          array(1) {
            ["with_station"]=>
            bool(true)
          }
          [3]=>
          array(1) {
            ["with_pdfs"]=>
            bool(false)
          }
          [4]=>
          array(1) {
            ["with_url"]=>
            bool(true)
          }
          [5]=>
          array(1) {
            ["with_photos"]=>
            bool(true)
          }
          [6]=>
          array(1) {
            ["with_localisation"]=>
            bool(false)
          }
          [7]=>
          array(1) {
            ["with_services"]=>
            bool(false)
          }
          [8]=>
          array(1) {
            ["with_equipement"]=>
            bool(false)
          }
          [9]=>
          array(1) {
            ["with_agencement"]=>
            bool(false)
          }
          [10]=>
          array(1) {
            ["with_agence"]=>
            bool(false)
          }
          [11]=>
          array(1) {
            ["with_biensProches"]=>
            bool(false)
          }
          [12]=>
          array(1) {
            ["with_condition_annulation"]=>
            bool(false)
          }
          [13]=>
          array(1) {
            ["with_points_forts"]=>
            bool(false)
          }
          [14]=>
          array(1) {
            ["with_presse"]=>
            bool(false)
          }
          [15]=>
          array(1) {
            ["for_smarty"]=>
            bool(false)
          }
          [16]=>
          array(1) {
            ["with_extranet"]=>
            bool(false)
          }
        }
      }
    }
    [2]=>
    array(6) {
      ["file"]=>
      string(41) "/web/cimalpes.com/include/ListDBModel.php"
      ["line"]=>
      int(11)
      ["function"]=>
      string(5) "build"
      ["class"]=>
      string(11) "ListDBModel"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(0) {
      }
    }
    [3]=>
    array(6) {
      ["file"]=>
      string(46) "/web/cimalpes.com/modules/bien/model/biens.php"
      ["line"]=>
      int(10)
      ["function"]=>
      string(6) "getAll"
      ["class"]=>
      string(11) "ListDBModel"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(2) {
        [0]=>
        string(4) "Bien"
        [1]=>
        array(17) {
          [0]=>
          string(7) "id_bien"
          [1]=>
          array(1) {
            ["with_collection"]=>
            bool(false)
          }
          [2]=>
          array(1) {
            ["with_station"]=>
            bool(true)
          }
          [3]=>
          array(1) {
            ["with_pdfs"]=>
            bool(false)
          }
          [4]=>
          array(1) {
            ["with_url"]=>
            bool(true)
          }
          [5]=>
          array(1) {
            ["with_photos"]=>
            bool(true)
          }
          [6]=>
          array(1) {
            ["with_localisation"]=>
            bool(false)
          }
          [7]=>
          array(1) {
            ["with_services"]=>
            bool(false)
          }
          [8]=>
          array(1) {
            ["with_equipement"]=>
            bool(false)
          }
          [9]=>
          array(1) {
            ["with_agencement"]=>
            bool(false)
          }
          [10]=>
          array(1) {
            ["with_agence"]=>
            bool(false)
          }
          [11]=>
          array(1) {
            ["with_biensProches"]=>
            bool(false)
          }
          [12]=>
          array(1) {
            ["with_condition_annulation"]=>
            bool(false)
          }
          [13]=>
          array(1) {
            ["with_points_forts"]=>
            bool(false)
          }
          [14]=>
          array(1) {
            ["with_presse"]=>
            bool(false)
          }
          [15]=>
          array(1) {
            ["for_smarty"]=>
            bool(false)
          }
          [16]=>
          array(1) {
            ["with_extranet"]=>
            bool(false)
          }
        }
      }
    }
    [4]=>
    array(6) {
      ["file"]=>
      string(46) "/web/cimalpes.com/modules/bien/model/biens.php"
      ["line"]=>
      int(276)
      ["function"]=>
      string(11) "__construct"
      ["class"]=>
      string(5) "Biens"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        string(943) "
    	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 ouverture_to IN ('B2C','Les deux')  GROUP BY id_bien  ORDER BY poids_cache DESC, id_bien  LIMIT 0, 20"
      }
    }
    [5]=>
    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)#3676 (19) {
          ["ids"]=>
          uninitialized(?array)
          ["orderBy"]=>
          NULL
          ["sens"]=>
          NULL
          ["date_debut"]=>
          uninitialized(string)
          ["date_fin"]=>
          uninitialized(string)
          ["limit"]=>
          int(1)
          ["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(true)
          ["station_ids"]=>
          uninitialized(?array)
          ["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"]=>
          uninitialized(?array)
          ["style_id"]=>
          uninitialized(?int)
          ["espace_loisir_ids"]=>
          uninitialized(?array)
          ["is_promotion"]=>
          bool(false)
          ["annulation_flexible"]=>
          NULL
          ["price_changed"]=>
          bool(false)
          ["nb_adultes"]=>
          int(0)
        }
      }
    }
    [6]=>
    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)#3676 (19) {
          ["ids"]=>
          uninitialized(?array)
          ["orderBy"]=>
          NULL
          ["sens"]=>
          NULL
          ["date_debut"]=>
          uninitialized(string)
          ["date_fin"]=>
          uninitialized(string)
          ["limit"]=>
          int(1)
          ["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(true)
          ["station_ids"]=>
          uninitialized(?array)
          ["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"]=>
          uninitialized(?array)
          ["style_id"]=>
          uninitialized(?int)
          ["espace_loisir_ids"]=>
          uninitialized(?array)
          ["is_promotion"]=>
          bool(false)
          ["annulation_flexible"]=>
          NULL
          ["price_changed"]=>
          bool(false)
          ["nb_adultes"]=>
          int(0)
        }
      }
    }
    [7]=>
    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)#3676 (19) {
          ["ids"]=>
          uninitialized(?array)
          ["orderBy"]=>
          NULL
          ["sens"]=>
          NULL
          ["date_debut"]=>
          uninitialized(string)
          ["date_fin"]=>
          uninitialized(string)
          ["limit"]=>
          int(1)
          ["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(true)
          ["station_ids"]=>
          uninitialized(?array)
          ["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"]=>
          uninitialized(?array)
          ["style_id"]=>
          uninitialized(?int)
          ["espace_loisir_ids"]=>
          uninitialized(?array)
          ["is_promotion"]=>
          bool(false)
          ["annulation_flexible"]=>
          NULL
          ["price_changed"]=>
          bool(false)
          ["nb_adultes"]=>
          int(0)
        }
      }
    }
    [8]=>
    array(6) {
      ["file"]=>
      string(60) "/web/cimalpes.com/modules/recherche/controller/recherche.php"
      ["line"]=>
      int(134)
      ["function"]=>
      string(11) "__construct"
      ["class"]=>
      string(9) "Recherche"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(2) {
        [0]=>
        enum(TypeRecherche::Biens)
        [1]=>
        object(BienSearchParams)#3676 (19) {
          ["ids"]=>
          uninitialized(?array)
          ["orderBy"]=>
          NULL
          ["sens"]=>
          NULL
          ["date_debut"]=>
          uninitialized(string)
          ["date_fin"]=>
          uninitialized(string)
          ["limit"]=>
          int(1)
          ["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(true)
          ["station_ids"]=>
          uninitialized(?array)
          ["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"]=>
          uninitialized(?array)
          ["style_id"]=>
          uninitialized(?int)
          ["espace_loisir_ids"]=>
          uninitialized(?array)
          ["is_promotion"]=>
          bool(false)
          ["annulation_flexible"]=>
          NULL
          ["price_changed"]=>
          bool(false)
          ["nb_adultes"]=>
          int(0)
        }
      }
    }
    [9]=>
    array(4) {
      ["file"]=>
      string(27) "/web/cimalpes.com/index.php"
      ["line"]=>
      int(4)
      ["args"]=>
      array(1) {
        [0]=>
        string(60) "/web/cimalpes.com/modules/recherche/controller/recherche.php"
      }
      ["function"]=>
      string(12) "require_once"
    }
  }
  ["previous":"Exception":private]=>
  NULL
  ["sqlstate":protected]=>
  string(5) "42S02"
}