The query took
0.002402seconds 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` = '23') AND (`Category_ID` = '6505') AND (`Selected_filters` = '{\"niveau_etude\":\"niveau_etude_bac_plus_5_et_plus\",\"geoFilterData\":{\"ville\":\"v_s_mar_temara\",\"ville_level1\":\"v_s_mar_temara_derb_askar\"}}') LIMIT 1
The query took
0.004946seconds 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` = 6499 OR (FIND_IN_SET(6499, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6499, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6499` , SUM(IF(`T1`.`Category_ID` = 6505 OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6505` 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` = 6499 OR (FIND_IN_SET(6499, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6499, `T3`.`Parent_IDs`) >0)OR ((`T1`.`Category_ID` = 6505 OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0)) AND `T1`.`niveau_etude` = 'niveau_etude_bac_plus_5_et_plus' AND ((`T1`.`Category_ID` = 6505 OR FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_temara' AND `T1`.`ville_level1` = 'v_s_mar_temara_derb_askar' GROUP BY `T1`.`Category_ID` HAVING COUNT(`T1`.`Category_ID`) >0 ORDER BY `Number` DESC
The query took
0.000790seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`niveau_etude`) AS `Number` , `T1`.`niveau_etude` , SUM(IF(`T1`.`Category_ID` = 6499 OR (FIND_IN_SET(6499, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6499, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6499` , SUM(IF(`T1`.`Category_ID` = 6505 OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6505` 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` = 6499 OR (FIND_IN_SET(6499, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6499, `T3`.`Parent_IDs`) >0)OR ((`T1`.`Category_ID` = 6505 OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0)) AND `T1`.`niveau_etude`<>'' AND `T1`.`niveau_etude`<>'0' AND `T1`.`niveau_etude` = 'niveau_etude_bac_plus_5_et_plus' AND ((`T1`.`Category_ID` = 6505 OR FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_temara' AND `T1`.`ville_level1` = 'v_s_mar_temara_derb_askar' GROUP BY `T1`.`niveau_etude` HAVING COUNT(`T1`.`niveau_etude`) >0 ORDER BY `Number` DESC
The query took
0.001423seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`work_experience`) AS `Number` , `T1`.`work_experience` , SUM(IF(`T1`.`Category_ID` = 6499 OR (FIND_IN_SET(6499, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6499, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6499` , SUM(IF(`T1`.`Category_ID` = 6505 OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6505` 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` = 6499 OR (FIND_IN_SET(6499, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6499, `T3`.`Parent_IDs`) >0)OR ((`T1`.`Category_ID` = 6505 OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0)) AND `T1`.`work_experience`<>'' AND `T1`.`work_experience`<>'0' AND `T1`.`niveau_etude` = 'niveau_etude_bac_plus_5_et_plus' AND ((`T1`.`Category_ID` = 6505 OR FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_temara' AND `T1`.`ville_level1` = 'v_s_mar_temara_derb_askar' GROUP BY `T1`.`work_experience` HAVING COUNT(`T1`.`work_experience`) >0 ORDER BY `Number` DESC
The query took
0.001150seconds to load.
/var/www/vhosts/quicherchequoi.com/httpdocs/includes/classes/rlSmarty.class.php(70) / function: fetch
SELECT COUNT(`T1`.`operating_schedule_stage`) AS `Number` , `T1`.`operating_schedule_stage` , SUM(IF(`T1`.`Category_ID` = 6499 OR (FIND_IN_SET(6499, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6499, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6499` , SUM(IF(`T1`.`Category_ID` = 6505 OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6505` 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` = 6499 OR (FIND_IN_SET(6499, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6499, `T3`.`Parent_IDs`) >0)OR ((`T1`.`Category_ID` = 6505 OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0)) AND `T1`.`operating_schedule_stage`<>'' AND `T1`.`operating_schedule_stage`<>'0' AND `T1`.`niveau_etude` = 'niveau_etude_bac_plus_5_et_plus' AND ((`T1`.`Category_ID` = 6505 OR FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_temara' AND `T1`.`ville_level1` = 'v_s_mar_temara_derb_askar' GROUP BY `T1`.`operating_schedule_stage` HAVING COUNT(`T1`.`operating_schedule_stage`) >0 ORDER BY `Number` DESC
The query took
0.000506seconds 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` = 6499 OR (FIND_IN_SET(6499, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6499, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6499` , SUM(IF(`T1`.`Category_ID` = 6505 OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0) OR (FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0) , 1, 0)) AS `Category_count_6505` 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` = 6499 OR (FIND_IN_SET(6499, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6499, `T3`.`Parent_IDs`) >0)OR ((`T1`.`Category_ID` = 6505 OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0 AND `T2`.`Cross` >0)) OR FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0)) AND `T1`.`ville`<>'' AND `T1`.`ville`<>'0' AND `T1`.`niveau_etude` = 'niveau_etude_bac_plus_5_et_plus' AND ((`T1`.`Category_ID` = 6505 OR FIND_IN_SET(6505, `T3`.`Parent_IDs`) >0) OR (FIND_IN_SET(6505, `T1`.`Crossed`) >0)) AND `T1`.`ville` = 'v_s_mar_temara' AND `T1`.`ville_level1` = 'v_s_mar_temara_derb_askar' GROUP BY `T1`.`ville` HAVING COUNT(`T1`.`ville`) >0 ORDER BY `Number` DESC
The query took
0.000201seconds 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` = 541 AND `T1`.`Status` = 'active'
The query took
0.000086seconds 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` = '6505') LIMIT 1
The query took
0.000089seconds 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` = '6505') LIMIT 1
Stage en Alternance / Apprentissage
The query took
0.000494seconds 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- Temara
- Derb Askar