[25/02/2026 00:06:20] [/home/monprot/www/script/traitements.php, runQuery() ligne 3007] Erreur de requête (SELECT
COUNT(la_annonce.id) AS nb
FROM la_fr_ville
JOIN la_fr_departement ON la_fr_ville.department_code=la_fr_departement.code
JOIN la_fr_region ON la_fr_departement.region_code=la_fr_region.code
LEFT OUTER JOIN la_annonce ON la_annonce.id_ville=la_fr_ville.id
LEFT OUTER JOIN la_agence ON (la_agence.manufacturer_id=la_annonce.manufacturer_id OR la_agence.manufacturer_id2=la_annonce.manufacturer_id) AND la_agence.actif=1
JOIN la_annonce_typologie ON la_annonce_typologie.id=la_annonce.id_typologie
WHERE !ISNULL(la_annonce.intention) AND !ISNULL(la_annonce_typologie.id)
AND (la_annonce.date_modification >= NOW() - INTERVAL 3 HOUR OR (la_annonce.date_modification IS NULL AND la_annonce.date_ajout >= NOW() - INTERVAL 3 HOUR))
AND la_agence.id IN (1,2,3)
AND la_annonce.intention='vente'
) : SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
[25/02/2026 00:06:20] [/home/monprot/www/script/traitements.php, runQuery() ligne 3050] Erreur de requête (SELECT
la_annonce.*,
la_annonce_typologie.nom AS typologie,
la_fr_ville.zip_code,
CONCAT(la_fr_ville.name,' (',IF(la_fr_ville.name='Paris' OR la_fr_ville.name = 'Marseille' OR la_fr_ville.name = 'Lyon',la_fr_ville.zip_code,la_fr_departement.code),')') AS localite_photo,
CONCAT(la_fr_ville.gps_lat,',',la_fr_ville.gps_lng) AS localite_gps,
CONCAT(la_annonce.latitude,',',la_annonce.longitude) AS localite_gps_precise,
la_fr_departement.name AS localite_departement,
la_fr_region.name AS localite_region,
la_agence.enseigne AS agence_enseigne
FROM la_fr_ville
JOIN la_fr_departement ON la_fr_ville.department_code=la_fr_departement.code
JOIN la_fr_region ON la_fr_departement.region_code=la_fr_region.code
LEFT OUTER JOIN la_annonce ON la_annonce.id_ville=la_fr_ville.id
LEFT OUTER JOIN la_agence ON (la_agence.manufacturer_id=la_annonce.manufacturer_id OR la_agence.manufacturer_id2=la_annonce.manufacturer_id) AND la_agence.actif=1
JOIN la_annonce_typologie ON la_annonce_typologie.id=la_annonce.id_typologie
WHERE !ISNULL(la_annonce.intention) AND !ISNULL(la_annonce_typologie.id)
AND (la_annonce.date_modification >= NOW() - INTERVAL 3 HOUR OR (la_annonce.date_modification IS NULL AND la_annonce.date_ajout >= NOW() - INTERVAL 3 HOUR))
AND la_agence.id IN (1,2,3)
AND la_annonce.intention='vente'
GROUP BY la_annonce.id
LIMIT 0,40) : SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
