The query took
0.003259seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT `Data_counts`,`Update_handler` FROM `qcq_category_filter_counts` WHERE (`Filter_ID` = '11') AND (`Category_ID` = '6473') AND (`Selected_filters` = '{\"sale_rent\":\"2\",\"geoFilterData\":{\"ville\":\"v_s_mar_safi\",\"ville_level1\":\"v_s_mar_safi_biyada\"}}') LIMIT 1
The query took
0.000951seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`Category_ID`) AS `Number`, `T1`.`Category_ID`, `T3`.`Parent_IDs` , SUM(IF(`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6473` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0)) AND `T1`.`sale_rent` = '2' AND ((`T1`.`Category_ID` = 6473 OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_safi' AND `T1`.`ville_level1` = 'v_s_mar_safi_biyada' GROUP BY `T1`.`Category_ID` HAVING COUNT(`T1`.`Category_ID`) >0 ORDER BY `Number` DESC
The query took
0.002423seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`sale_rent`) AS `Number` , `T1`.`sale_rent` , SUM(IF(`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6473` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0)) AND `T1`.`sale_rent`<>'' AND `T1`.`sale_rent`<>'0' AND `T1`.`sale_rent` = '2' AND ((`T1`.`Category_ID` = 6473 OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_safi' AND `T1`.`ville_level1` = 'v_s_mar_safi_biyada' GROUP BY `T1`.`sale_rent` HAVING COUNT(`T1`.`sale_rent`) >0 ORDER BY `Number` DESC
The query took
0.003456seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`price`) AS `Number` , SUBSTRING_INDEX(`T1`.`price`, '|', 1) AS `price` , SUM(IF(`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6473` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0)) AND `T1`.`price`<>'' AND `T1`.`price`<>'0' AND `T1`.`sale_rent` = '2' AND ((`T1`.`Category_ID` = 6473 OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_safi' AND `T1`.`ville_level1` = 'v_s_mar_safi_biyada' GROUP BY SUBSTRING_INDEX(`T1`.`price`, '|', 1) HAVING COUNT(`T1`.`price`) >0 ORDER BY `Number` DESC
The query took
0.005215seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`bedrooms`) AS `Number` , `T1`.`bedrooms` , SUM(IF(`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6473` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0)) AND `T1`.`bedrooms`<>'' AND `T1`.`bedrooms`<>'0' AND `T1`.`sale_rent` = '2' AND ((`T1`.`Category_ID` = 6473 OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_safi' AND `T1`.`ville_level1` = 'v_s_mar_safi_biyada' GROUP BY `T1`.`bedrooms` HAVING COUNT(`T1`.`bedrooms`) >0 ORDER BY `Number` DESC
The query took
0.000468seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`salons`) AS `Number` , `T1`.`salons` , SUM(IF(`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6473` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0)) AND `T1`.`salons`<>'' AND `T1`.`salons`<>'0' AND `T1`.`sale_rent` = '2' AND ((`T1`.`Category_ID` = 6473 OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_safi' AND `T1`.`ville_level1` = 'v_s_mar_safi_biyada' GROUP BY `T1`.`salons` HAVING COUNT(`T1`.`salons`) >0 ORDER BY `Number` DESC
The query took
0.001140seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`bathrooms`) AS `Number` , `T1`.`bathrooms` , SUM(IF(`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6473` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0)) AND `T1`.`bathrooms`<>'' AND `T1`.`bathrooms`<>'0' AND `T1`.`sale_rent` = '2' AND ((`T1`.`Category_ID` = 6473 OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_safi' AND `T1`.`ville_level1` = 'v_s_mar_safi_biyada' GROUP BY `T1`.`bathrooms` HAVING COUNT(`T1`.`bathrooms`) >0 ORDER BY `Number` DESC
The query took
0.004533seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`surface_habitable`) AS `Number` , SUBSTRING_INDEX(`T1`.`surface_habitable`, '|', 1) AS `surface_habitable` , SUM(IF(`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6473` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0)) AND `T1`.`surface_habitable`<>'' AND `T1`.`surface_habitable`<>'0' AND `T1`.`sale_rent` = '2' AND ((`T1`.`Category_ID` = 6473 OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_safi' AND `T1`.`ville_level1` = 'v_s_mar_safi_biyada' GROUP BY SUBSTRING_INDEX(`T1`.`surface_habitable`, '|', 1) HAVING COUNT(`T1`.`surface_habitable`) >0 ORDER BY `Number` DESC
The query took
0.001014seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`square_feet`) AS `Number` , SUBSTRING_INDEX(`T1`.`square_feet`, '|', 1) AS `square_feet` , SUM(IF(`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6473` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0)) AND `T1`.`square_feet`<>'' AND `T1`.`square_feet`<>'0' AND `T1`.`sale_rent` = '2' AND ((`T1`.`Category_ID` = 6473 OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_safi' AND `T1`.`ville_level1` = 'v_s_mar_safi_biyada' GROUP BY SUBSTRING_INDEX(`T1`.`square_feet`, '|', 1) HAVING COUNT(`T1`.`square_feet`) >0 ORDER BY `Number` DESC
The query took
0.003181seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`number_of_floors`) AS `Number` , `T1`.`number_of_floors` , SUM(IF(`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6473` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0)) AND `T1`.`number_of_floors`<>'' AND `T1`.`number_of_floors`<>'0' AND `T1`.`sale_rent` = '2' AND ((`T1`.`Category_ID` = 6473 OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_safi' AND `T1`.`ville_level1` = 'v_s_mar_safi_biyada' GROUP BY `T1`.`number_of_floors` HAVING COUNT(`T1`.`number_of_floors`) >0 ORDER BY `Number` DESC
The query took
0.000963seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`age_du_bien`) AS `Number` , `T1`.`age_du_bien` , SUM(IF(`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6473` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0)) AND `T1`.`age_du_bien`<>'' AND `T1`.`age_du_bien`<>'0' AND `T1`.`sale_rent` = '2' AND ((`T1`.`Category_ID` = 6473 OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_safi' AND `T1`.`ville_level1` = 'v_s_mar_safi_biyada' GROUP BY `T1`.`age_du_bien` HAVING COUNT(`T1`.`age_du_bien`) >0 ORDER BY `Number` DESC
The query took
0.002390seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`caracteristiques_immo`) AS `Number` , `T1`.`caracteristiques_immo` , SUM(IF(`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6473` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0)) AND `T1`.`caracteristiques_immo`<>'' AND `T1`.`caracteristiques_immo`<>'0' AND `T1`.`ville` = 'v_s_mar_safi' AND `T1`.`ville_level1` = 'v_s_mar_safi_biyada' GROUP BY `T1`.`caracteristiques_immo` HAVING COUNT(`T1`.`caracteristiques_immo`) >0 ORDER BY `Number` DESC
The query took
0.001113seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`ville`) AS `Number` , `T1`.`ville` , SUM(IF(`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6473` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 6473 OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0)) AND `T1`.`ville`<>'' AND `T1`.`ville`<>'0' AND `T1`.`sale_rent` = '2' AND ((`T1`.`Category_ID` = 6473 OR FIND_IN_SET(6473, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6473, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_safi' AND `T1`.`ville_level1` = 'v_s_mar_safi_biyada' GROUP BY `T1`.`ville` HAVING COUNT(`T1`.`ville`) >0 ORDER BY `Number` DESC
The query took
0.002519seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT `T1`.`ID`, `T1`.`Key`, `T1`.`Default`, `T2`.`Value` as `name`, `T1`.`Parent_IDs` , `Path` FROM `qcq_multi_formats` AS `T1` LEFT JOIN `qcq_multi_formats_lang_fr` AS `T2` ON `T2`.`Key` = `T1`.`Key` WHERE `T1`.`Parent_ID` = 417 AND `T1`.`Status` = 'active'
The query took
0.000885seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT `ID`,`Key`,`Type`,`Path` FROM `qcq_categories` WHERE (`ID` = '6473') LIMIT 1
The query took
0.000149seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT `ID`,`Key`,`Type`,`Path` FROM `qcq_categories` WHERE (`ID` = '6473') LIMIT 1
Maisons
![Annuler le filtre](https://www.quicherchequoi.com/templates/qcq/img/blank.gif)
The query took
0.002057seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT `Value` FROM `qcq_lang_keys` WHERE `Key` = 'blocks+name+geo_filter_box' AND `Code` = 'fr' LIMIT 1
Filtrer par ville et secteur- Safi
![](https://www.quicherchequoi.com/templates/qcq/img/blank.gif)
- Biyada
![](https://www.quicherchequoi.com/templates/qcq/img/blank.gif)