A Database Error Occurred

Error Number: 1054

Unknown column 'sitemap' in 'where clause'

SELECT DISTINCT `cq`.`nom_nl` as `nom_cq`, `cq`.`id` as `id_cq`, GROUP_CONCAT(DISTINCT op.volet SEPARATOR ", ") AS `volets`, `ma`.`id` AS `id_projet`, `ma`.`nom_marche_fr` AS `nom_marche_default`, IF(`ma`.`nom_marche_nl` != "", `ma`.`nom_marche_nl`, CONCAT( `ma`.`nom_marche_fr`, "") )AS `nom_marche`, `ma`.`adresse_rue_nl` AS `adresse_rue`, `ma`.`adresse_num`, `ma`.`descr_nl` AS `descr_projet`, `cq`.`cp`, YEAR(ma.dt_cha_recep) as an_recep, YEAR(NOW())-YEAR(ma.dt_cha_recep) as reception, SUM( op.mnt_region) as mnt_region, SUM( op.mnt_commune) as mnt_commune, SUM( op.mnt_beliris) as mnt_beliris, SUM( op.mnt_autres + op.mnt_prive) as mnt_autres, ST_AsText(ST_centroid(geom_W84)) AS geo_point, ST_AsText(ma.geom) AS geo_geom, SUM( op.nb_log_tot) as logements, IF(ph.`jpg`!="", CONCAT("/db/doc/PHOTO-200C/", IF(LENGTH(cq.id)>1, "0", "00"), `cq`.`id`, '/', `ph`.`jpg`, ""), "" ) AS `url_photo` FROM (`cqd_projets` as `ma`, `cqd_programmes` AS `cq`, `cqd_operations` AS `op`) LEFT JOIN (SELECT * FROM cqd_photos WHERE icone=1 ORDER BY icone ASC, date DESC) AS ph ON `ph`.`id_projet`=`ma`.`id` WHERE `cq`.`id` = `sitemap` AND `op`.`id_projet` = `ma`.`id` AND `ma`.`id_cq` = `cq`.`id` AND `op`.`efface` =0 AND `ma`.`geom` is not null AND `ma`.`geom` <> "" AND `cq`.`serie` >= 1994 AND `cq`.`serie` <= '2024' AND ( `op`.`volet` = 1 OR `op`.`volet` = 2 OR `op`.`volet` = 3 OR `op`.`volet` = 4 OR `op`.`volet` = "5a" OR `op`.`volet` = 6 OR `op`.`volet` = 7 ) GROUP BY `ma`.`id` ORDER BY `cq`.`id` DESC, `ma`.`id` DESC, `ma`.`nom_marche_nl`

Filename: models/Projet_model.php

Line Number: 152