[15/12/2025 18:38:25] [/home/monprot/www/script/traitements.php, runQuery() ligne 2725] 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
JOIN la_annonce_typologie ON la_annonce_typologie.id=la_annonce.id_typologie
WHERE ((la_fr_ville.slug='villeurbanne'
AND SUBSTR(la_fr_ville.zip_code,1,5)=69100) OR (6366*acos(cos(radians(45.771826388889))*cos(radians(la_fr_ville.gps_lat))*cos(radians(la_fr_ville.gps_lng)-radians(4.8927772222222))+sin(radians(45.771826388889))*sin(radians(la_fr_ville.gps_lat))))<=50)
AND (la_annonce.intention='vente' OR 'vente'='')
AND (la_annonce_typologie.url='appartement' OR 'appartement'='' OR 'appartement'='tous-types')
AND !ISNULL(la_annonce.intention) AND !ISNULL(la_annonce_typologie.id)
AND TIMEDIFF(NOW(), IF(!ISNULL(la_annonce.date_modification),la_annonce.date_modification,la_annonce.date_ajout)) < CAST('03:00:00' AS TIME)
) : SQLSTATE[HY000]: General error: 3024 Query execution was interrupted, maximum statement execution time exceeded
Warning: Undefined array key 0 in /home/monprot/www/script/traitements.php on line 2773
Warning: Trying to access array offset on null in /home/monprot/www/script/traitements.php on line 2773
Warning: Undefined array key 0 in /home/monprot/www/script/traitements.php on line 2775
Warning: Trying to access array offset on null in /home/monprot/www/script/traitements.php on line 2775
[15/12/2025 18:38:30] [/home/monprot/www/script/traitements.php, runQuery() ligne 2788] Erreur de requête (SELECT
la_annonce.*,
la_annonce_typologie.nom AS typologie,
la_fr_ville.zip_code,
la_fr_ville.name AS localite,
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_departement.name AS localite_departement_code,
la_fr_region.name AS localite_region,
CONCAT(la_fr_ville.name,'-',la_fr_ville.zip_code) AS localite_url,
CONCAT(la_fr_ville.name, ' ', '(', la_fr_ville.zip_code, ')') AS localite_h1,
'ville' AS localite_type,
CONCAT(la_fr_ville.name,' (',la_fr_ville.zip_code,')') AS localite_title,
(6366*acos(cos(radians(45.771826388889))*cos(radians(la_fr_ville.gps_lat))*cos(radians(la_fr_ville.gps_lng)-radians(4.8927772222222))+sin(radians(45.771826388889))*sin(radians(la_fr_ville.gps_lat)))) AS distance
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
JOIN la_annonce_typologie ON la_annonce_typologie.id=la_annonce.id_typologie
WHERE ((la_fr_ville.slug='villeurbanne'
AND SUBSTR(la_fr_ville.zip_code,1,5)=69100) OR (6366*acos(cos(radians(45.771826388889))*cos(radians(la_fr_ville.gps_lat))*cos(radians(la_fr_ville.gps_lng)-radians(4.8927772222222))+sin(radians(45.771826388889))*sin(radians(la_fr_ville.gps_lat))))<=50)
AND (la_annonce.intention='vente' OR 'vente'='')
AND (la_annonce_typologie.url='appartement' OR 'appartement'='' OR 'appartement'='tous-types')
AND !ISNULL(la_annonce.intention) AND !ISNULL(la_annonce_typologie.id)
AND TIMEDIFF(NOW(), IF(!ISNULL(la_annonce.date_modification),la_annonce.date_modification,la_annonce.date_ajout)) < CAST('03:00:00' AS TIME)
GROUP BY la_annonce.id
ORDER BY distance, la_annonce.id DESC
LIMIT 0,40) : SQLSTATE[HY000]: General error: 3024 Query execution was interrupted, maximum statement execution time exceeded
Warning: Cannot modify header information - headers already sent by (output started at /home/monprot/www/lib/Debug.class.php:76) in /home/monprot/www/script/traitements.php on line 2883
Warning: Cannot modify header information - headers already sent by (output started at /home/monprot/www/lib/Debug.class.php:76) in /home/monprot/www/script/traitements.php on line 2884