The query took
0.001878 seconds 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` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`Category_ID` <> '' AND `T1`.`Category_ID` <> '0' AND ((`T1`.`Category_ID` = 5814 OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0)) AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY `T1`.`Category_ID` HAVING COUNT(`T1`.`Category_ID`) > 0 ORDER BY `Number` DESC
The query took
0.001484 seconds 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` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`price` <> '' AND `T1`.`price` <> '0' AND ((`T1`.`Category_ID` = 5814 OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0)) AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY SUBSTRING_INDEX(`T1`.`price`, '|', 1) HAVING COUNT(`T1`.`price`) > 0 ORDER BY `Number` DESC
The query took
0.001272 seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`condition`) AS `Number` , `T1`.`condition` , SUM(IF(`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`condition` <> '' AND `T1`.`condition` <> '0' AND ((`T1`.`Category_ID` = 5814 OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0)) AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY `T1`.`condition` HAVING COUNT(`T1`.`condition`) > 0 ORDER BY `Number` DESC
The query took
0.001182 seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`body_style`) AS `Number` , `T1`.`body_style` , SUM(IF(`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`body_style` <> '' AND `T1`.`body_style` <> '0' AND ((`T1`.`Category_ID` = 5814 OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0)) AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY `T1`.`body_style` HAVING COUNT(`T1`.`body_style`) > 0 ORDER BY `Number` DESC
The query took
0.000996 seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`puissance_fiscale`) AS `Number` , `T1`.`puissance_fiscale` , SUM(IF(`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`puissance_fiscale` <> '' AND `T1`.`puissance_fiscale` <> '0' AND ((`T1`.`Category_ID` = 5814 OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0)) AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY `T1`.`puissance_fiscale` HAVING COUNT(`T1`.`puissance_fiscale`) > 0 ORDER BY `Number` DESC
The query took
0.000645 seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`built`) AS `Number` , `T1`.`built` , SUM(IF(`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`built` <> '' AND `T1`.`built` <> '0' AND ((`T1`.`Category_ID` = 5814 OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0)) AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY `T1`.`built` HAVING COUNT(`T1`.`built`) > 0 ORDER BY `Number` DESC
The query took
0.000656 seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`fuel`) AS `Number` , `T1`.`fuel` , SUM(IF(`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`fuel` <> '' AND `T1`.`fuel` <> '0' AND ((`T1`.`Category_ID` = 5814 OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0)) AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY `T1`.`fuel` HAVING COUNT(`T1`.`fuel`) > 0 ORDER BY `Number` DESC
The query took
0.000604 seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`transmission`) AS `Number` , `T1`.`transmission` , SUM(IF(`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`transmission` <> '' AND `T1`.`transmission` <> '0' AND ((`T1`.`Category_ID` = 5814 OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0)) AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY `T1`.`transmission` HAVING COUNT(`T1`.`transmission`) > 0 ORDER BY `Number` DESC
The query took
0.000936 seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`couleur`) AS `Number` , `T1`.`couleur` , SUM(IF(`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`couleur` <> '' AND `T1`.`couleur` <> '0' AND ((`T1`.`Category_ID` = 5814 OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0)) AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY `T1`.`couleur` HAVING COUNT(`T1`.`couleur`) > 0 ORDER BY `Number` DESC
The query took
0.000717 seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`origine_vehicule`) AS `Number` , `T1`.`origine_vehicule` , SUM(IF(`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`origine_vehicule` <> '' AND `T1`.`origine_vehicule` <> '0' AND ((`T1`.`Category_ID` = 5814 OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0)) AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY `T1`.`origine_vehicule` HAVING COUNT(`T1`.`origine_vehicule`) > 0 ORDER BY `Number` DESC
The query took
0.001174 seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`premiere_main`) AS `Number` , `T1`.`premiere_main` , SUM(IF(`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`premiere_main` <> '' AND ((`T1`.`Category_ID` = 5814 OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0)) AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY `T1`.`premiere_main` HAVING COUNT(`T1`.`premiere_main`) > 0 ORDER BY `Number` DESC
The query took
0.000588 seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`mileage`) AS `Number` , SUBSTRING_INDEX(`T1`.`mileage`, '|', 1) AS `mileage` , SUM(IF(`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`mileage` <> '' AND `T1`.`mileage` <> '0' AND ((`T1`.`Category_ID` = 5814 OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0)) AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY SUBSTRING_INDEX(`T1`.`mileage`, '|', 1) HAVING COUNT(`T1`.`mileage`) > 0 ORDER BY `Number` DESC
The query took
0.000847 seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`options_voiture`) AS `Number` , `T1`.`options_voiture` , SUM(IF(`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`options_voiture` <> '' AND `T1`.`options_voiture` <> '0' AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY `T1`.`options_voiture` HAVING COUNT(`T1`.`options_voiture`) > 0 ORDER BY `Number` DESC
The query took
0.000496 seconds 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` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5166` , SUM(IF(`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_5814` FROM `qcq_listings` AS `T1` LEFT JOIN `qcq_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `qcq_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `qcq_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` WHERE `T1`.`Status` = 'active' AND (((`T1`.`Category_ID` = 5166 OR (FIND_IN_SET(5166, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5166, `T3`.`Parent_IDs`) > 0)OR ((`T1`.`Category_ID` = 5814 OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0)) AND `T1`.`ville` <> '' AND `T1`.`ville` <> '0' AND ((`T1`.`Category_ID` = 5814 OR FIND_IN_SET(5814, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(5814, `T1`.`Crossed`) > 0)) AND `T1`.`ville` = 'v_s_mar_marrakech' AND `T1`.`ville_level1` = 'v_s_mar_marrakech_av_abdelkrim_el_khattabi' GROUP BY `T1`.`ville` HAVING COUNT(`T1`.`ville`) > 0 ORDER BY `Number` DESC
The query took
0.000209 seconds 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` = 128 AND `T1`.`Status` = 'active' ORDER BY `T1`.`Position`
The query took
0.000346 seconds 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` = '5814') LIMIT 1
The query took
0.000060 seconds 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` = '5814') LIMIT 1
K 2500
The query took
0.000186 seconds 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
-
Marrakech
-
Av Abdelkrim El Khattabi