| 0.0004 |
SELECT `stages`.`id_stages`, `id_annee`, `intitule_stage`, `intitule_abrege`, `objectifs`, `contenu`, `pre_requis`, `formateurs_qualite`, `nbre_formateurs`, `nbre_participants`, `nbre_participants_max`, `duree`, `cout`, `mmp`, `pers_concerne`, `n_stage`, `status_stage`, `page_catalogue`, `eligible_dpc`, `promo_new_stage`, (SELECT GROUP_CONCAT(DISTINCT(mots_cles.mot_cle) SEPARATOR ";") AS array_mc
FROM `mots_cles_stages` LEFT JOIN `mots_cles` ON `mots_cles`.`id_mots_cles` = `mots_cles_stages`.`id_mots_cles` WHERE `mots_cles_stages`.`id_stages` = stages.id_stages) AS array_mots_cles
FROM `stages`
LEFT JOIN `mots_cles_stages` ON `mots_cles_stages`.`id_stages` = `stages`.`id_stages`
LEFT JOIN `mots_cles` ON `mots_cles`.`id_mots_cles` = `mots_cles_stages`.`id_mots_cles`
LEFT JOIN `cibles_clients_stages` ON `cibles_clients_stages`.`id_stages` = `stages`.`id_stages`
WHERE SUBSTRING(stages.n_stage,9,2) >= '21'
AND `stages`.`n_stage` LIKE '%21S' ESCAPE '!'
AND `status_stage` = '1'
AND `mots_cles`.`mot_cle` = 'famille'
GROUP BY `stages`.`id_stages`
ORDER BY `stages`.`id_stages`
|
| 0.0002 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '9923'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0002 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '9964'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0002 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '9996'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1332470022S'
|
| 0.0002 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10004'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10023'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10026'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10054'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10079'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1128255022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10084'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1332125022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10091'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10098'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1128265022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10253'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10254'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10255'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0002 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10261'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10284'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10285'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1332675022S'
|
| 0.0027 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10287'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1332645022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10288'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1332665022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10289'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10297'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1332765022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10332'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10340'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1332750022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10359'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '0331340022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10793'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1332720122S'
|
| 0.0002 |
SELECT `stages`.`id_stages`, `id_annee`, `intitule_stage`, `intitule_abrege`, `objectifs`, `contenu`, `pre_requis`, `formateurs_qualite`, `nbre_formateurs`, `nbre_participants`, `nbre_participants_max`, `duree`, `cout`, `mmp`, `pers_concerne`, `n_stage`, `status_stage`, `page_catalogue`, `eligible_dpc`, `promo_new_stage`, (SELECT GROUP_CONCAT(DISTINCT(mots_cles.mot_cle) SEPARATOR ";") AS array_mc
FROM `mots_cles_stages` LEFT JOIN `mots_cles` ON `mots_cles`.`id_mots_cles` = `mots_cles_stages`.`id_mots_cles` WHERE `mots_cles_stages`.`id_stages` = stages.id_stages) AS array_mots_cles
FROM `stages`
LEFT JOIN `mots_cles_stages` ON `mots_cles_stages`.`id_stages` = `stages`.`id_stages`
LEFT JOIN `mots_cles` ON `mots_cles`.`id_mots_cles` = `mots_cles_stages`.`id_mots_cles`
LEFT JOIN `cibles_clients_stages` ON `cibles_clients_stages`.`id_stages` = `stages`.`id_stages`
WHERE SUBSTRING(stages.n_stage,9,2) >= '21'
AND `stages`.`n_stage` LIKE '%21S' ESCAPE '!'
AND `status_stage` = '1'
AND `mots_cles`.`mot_cle` = 'famille'
GROUP BY `stages`.`id_stages`
ORDER BY `stages`.`id_stages`
LIMIT 20
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '9923'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '9964'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '9996'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1332470022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10004'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10023'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10026'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10054'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10079'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1128255022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10084'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1332125022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10091'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10098'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1128265022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10253'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0002 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10254'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10255'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10261'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10284'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10285'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1332675022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10287'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1332645022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10288'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT `stages`.*
FROM `stages`
WHERE `n_stage` = '1332665022S'
|
| 0.0001 |
SELECT *
FROM `sessions`
LEFT JOIN `villes` ON `sessions`.`id_groupe_ville` = `villes`.`id_villes`
WHERE `id_stages` = '10289'
AND `date_debut` >= '2021-07-31'
ORDER BY `date_debut` ASC
|
| 0.0001 |
SELECT *
FROM `villes`
WHERE `display_site` = '1'
|
