Symfony Profiler

SELECT 
  p0_.id_parametres AS id_parametres_0, 
  p0_.date_connexion AS date_connexion_1, 
  p0_.date_demande AS date_demande_2, 
  p0_.renitialiser AS renitialiser_3, 
  p0_.envoyer AS envoyer_4, 
  p0_.id_credentiel AS id_credentiel_5, 
  p0_.pseudo AS pseudo_6, 
  p0_.mot_de_passe AS mot_de_passe_7, 
  p0_.email AS email_8, 
  p0_.nom AS nom_9, 
  p0_.prenom AS prenom_10, 
  p0_.date_naiss AS date_naiss_11, 
  p0_.ville AS ville_12, 
  p0_.id_liste_pays AS id_liste_pays_13, 
  p0_.langue AS langue_14, 
  p0_.visible AS visible_15, 
  p0_.photo AS photo_16, 
  p0_.voyage_public AS voyage_public_17, 
  p0_.device AS device_18, 
  p0_.latitude AS latitude_19, 
  p0_.longitude AS longitude_20, 
  p0_.lieu_localisation AS lieu_localisation_21, 
  p0_.pays_localisation AS pays_localisation_22, 
  p0_.facebook_id AS facebook_id_23, 
  p0_.google_id AS google_id_24 
FROM 
  parametres p0_ 
WHERE 
  p0_.id_parametres = 15

SELECT p0_.id_parametres AS id_parametres_0, p0_.date_connexion AS date_connexion_1, p0_.date_demande AS date_demande_2, p0_.renitialiser AS renitialiser_3, p0_.envoyer AS envoyer_4, p0_.id_credentiel AS id_credentiel_5, p0_.pseudo AS pseudo_6, p0_.mot_de_passe AS mot_de_passe_7, p0_.email AS email_8, p0_.nom AS nom_9, p0_.prenom AS prenom_10, p0_.date_naiss AS date_naiss_11, p0_.ville AS ville_12, p0_.id_liste_pays AS id_liste_pays_13, p0_.langue AS langue_14, p0_.visible AS visible_15, p0_.photo AS photo_16, p0_.voyage_public AS voyage_public_17, p0_.device AS device_18, p0_.latitude AS latitude_19, p0_.longitude AS longitude_20, p0_.lieu_localisation AS lieu_localisation_21, p0_.pays_localisation AS pays_localisation_22, p0_.facebook_id AS facebook_id_23, p0_.google_id AS google_id_24 FROM parametres p0_ WHERE p0_.id_parametres = 15;

SELECT 
  l0_.id_liste_evenements AS id_liste_evenements_0, 
  l0_.nbre_de_jour AS nbre_de_jour_1, 
  l0_.lieu AS lieu_2, 
  l0_.titre AS titre_3, 
  l0_.descriptions AS descriptions_4, 
  l0_.particularite AS particularite_5, 
  l0_.id_liste_pays AS id_liste_pays_6, 
  l0_.mois_evenement AS mois_evenement_7, 
  l0_.date AS date_8 
FROM 
  liste_evenements l0_ 
WHERE 
  (
    DATE_ADD(
      l0_.date, INTERVAL l0_.nbre_de_jour DAY
    ) BETWEEN CURRENT_DATE 
    AND DATE_ADD(CURRENT_DATE, INTERVAL 5 DAY)
  ) 
  OR (
    l0_.date BETWEEN CURRENT_DATE 
    AND DATE_ADD(CURRENT_DATE, INTERVAL 5 DAY)
  ) 
  OR l0_.date = CURRENT_DATE 
ORDER BY 
  l0_.date ASC

SELECT l0_.id_liste_evenements AS id_liste_evenements_0, l0_.nbre_de_jour AS nbre_de_jour_1, l0_.lieu AS lieu_2, l0_.titre AS titre_3, l0_.descriptions AS descriptions_4, l0_.particularite AS particularite_5, l0_.id_liste_pays AS id_liste_pays_6, l0_.mois_evenement AS mois_evenement_7, l0_.date AS date_8 FROM liste_evenements l0_ WHERE (DATE_ADD(l0_.date, INTERVAL l0_.nbre_de_jour DAY) BETWEEN CURRENT_DATE AND DATE_ADD(CURRENT_DATE, INTERVAL 5 DAY)) OR (l0_.date BETWEEN CURRENT_DATE AND DATE_ADD(CURRENT_DATE, INTERVAL 5 DAY)) OR l0_.date = CURRENT_DATE ORDER BY l0_.date ASC;

SELECT 
  * 
FROM 
  `liste_evenements` `e` 
WHERE 
  TO_DAYS(`e`.`date`) + `e`.`nbre_de_jour` >= TO_DAYS(NOW()) 
ORDER BY 
  `e`.`date` ASC

SELECT * FROM `liste_evenements` `e` WHERE TO_DAYS(`e`.`date`) + `e`.`nbre_de_jour` >= TO_DAYS(NOW()) ORDER BY `e`.`date` ASC;

SELECT 
  p0_.id_parametres AS id_parametres_0, 
  p0_.date_connexion AS date_connexion_1, 
  p0_.date_demande AS date_demande_2, 
  p0_.renitialiser AS renitialiser_3, 
  p0_.envoyer AS envoyer_4, 
  p0_.id_credentiel AS id_credentiel_5, 
  p0_.pseudo AS pseudo_6, 
  p0_.mot_de_passe AS mot_de_passe_7, 
  p0_.email AS email_8, 
  p0_.nom AS nom_9, 
  p0_.prenom AS prenom_10, 
  p0_.date_naiss AS date_naiss_11, 
  p0_.ville AS ville_12, 
  p0_.id_liste_pays AS id_liste_pays_13, 
  p0_.langue AS langue_14, 
  p0_.visible AS visible_15, 
  p0_.photo AS photo_16, 
  p0_.voyage_public AS voyage_public_17, 
  p0_.device AS device_18, 
  p0_.latitude AS latitude_19, 
  p0_.longitude AS longitude_20, 
  p0_.lieu_localisation AS lieu_localisation_21, 
  p0_.pays_localisation AS pays_localisation_22, 
  p0_.facebook_id AS facebook_id_23, 
  p0_.google_id AS google_id_24 
FROM 
  parametres p0_ 
WHERE 
  p0_.id_parametres = 2

SELECT p0_.id_parametres AS id_parametres_0, p0_.date_connexion AS date_connexion_1, p0_.date_demande AS date_demande_2, p0_.renitialiser AS renitialiser_3, p0_.envoyer AS envoyer_4, p0_.id_credentiel AS id_credentiel_5, p0_.pseudo AS pseudo_6, p0_.mot_de_passe AS mot_de_passe_7, p0_.email AS email_8, p0_.nom AS nom_9, p0_.prenom AS prenom_10, p0_.date_naiss AS date_naiss_11, p0_.ville AS ville_12, p0_.id_liste_pays AS id_liste_pays_13, p0_.langue AS langue_14, p0_.visible AS visible_15, p0_.photo AS photo_16, p0_.voyage_public AS voyage_public_17, p0_.device AS device_18, p0_.latitude AS latitude_19, p0_.longitude AS longitude_20, p0_.lieu_localisation AS lieu_localisation_21, p0_.pays_localisation AS pays_localisation_22, p0_.facebook_id AS facebook_id_23, p0_.google_id AS google_id_24 FROM parametres p0_ WHERE p0_.id_parametres = 2;

SELECT 
  p0_.id_parametres AS id_parametres_0, 
  p0_.date_connexion AS date_connexion_1, 
  p0_.date_demande AS date_demande_2, 
  p0_.renitialiser AS renitialiser_3, 
  p0_.envoyer AS envoyer_4, 
  p0_.id_credentiel AS id_credentiel_5, 
  p0_.pseudo AS pseudo_6, 
  p0_.mot_de_passe AS mot_de_passe_7, 
  p0_.email AS email_8, 
  p0_.nom AS nom_9, 
  p0_.prenom AS prenom_10, 
  p0_.date_naiss AS date_naiss_11, 
  p0_.ville AS ville_12, 
  p0_.id_liste_pays AS id_liste_pays_13, 
  p0_.langue AS langue_14, 
  p0_.visible AS visible_15, 
  p0_.photo AS photo_16, 
  p0_.voyage_public AS voyage_public_17, 
  p0_.device AS device_18, 
  p0_.latitude AS latitude_19, 
  p0_.longitude AS longitude_20, 
  p0_.lieu_localisation AS lieu_localisation_21, 
  p0_.pays_localisation AS pays_localisation_22, 
  p0_.facebook_id AS facebook_id_23, 
  p0_.google_id AS google_id_24 
FROM 
  parametres p0_ 
WHERE 
  p0_.id_parametres = 12

SELECT p0_.id_parametres AS id_parametres_0, p0_.date_connexion AS date_connexion_1, p0_.date_demande AS date_demande_2, p0_.renitialiser AS renitialiser_3, p0_.envoyer AS envoyer_4, p0_.id_credentiel AS id_credentiel_5, p0_.pseudo AS pseudo_6, p0_.mot_de_passe AS mot_de_passe_7, p0_.email AS email_8, p0_.nom AS nom_9, p0_.prenom AS prenom_10, p0_.date_naiss AS date_naiss_11, p0_.ville AS ville_12, p0_.id_liste_pays AS id_liste_pays_13, p0_.langue AS langue_14, p0_.visible AS visible_15, p0_.photo AS photo_16, p0_.voyage_public AS voyage_public_17, p0_.device AS device_18, p0_.latitude AS latitude_19, p0_.longitude AS longitude_20, p0_.lieu_localisation AS lieu_localisation_21, p0_.pays_localisation AS pays_localisation_22, p0_.facebook_id AS facebook_id_23, p0_.google_id AS google_id_24 FROM parametres p0_ WHERE p0_.id_parametres = 12;

SELECT 
  t0.id_voyage_serveur AS id_voyage_serveur_1, 
  t0.id_parametres AS id_parametres_2, 
  t0.id_voyage AS id_voyage_3, 
  t0.id_liste_saison AS id_liste_saison_4, 
  t0.id_liste_type_voyage AS id_liste_type_voyage_5, 
  t0.detail_voyage AS detail_voyage_6, 
  t0.nom_voyage AS nom_voyage_7, 
  t0.photo AS photo_8, 
  t0.date_creation AS date_creation_9, 
  t0.date_maj AS date_maj_10 
FROM 
  voyage t0 
ORDER BY 
  t0.date_maj DESC, 
  t0.id_voyage_serveur DESC

SELECT t0.id_voyage_serveur AS id_voyage_serveur_1, t0.id_parametres AS id_parametres_2, t0.id_voyage AS id_voyage_3, t0.id_liste_saison AS id_liste_saison_4, t0.id_liste_type_voyage AS id_liste_type_voyage_5, t0.detail_voyage AS detail_voyage_6, t0.nom_voyage AS nom_voyage_7, t0.photo AS photo_8, t0.date_creation AS date_creation_9, t0.date_maj AS date_maj_10 FROM voyage t0 ORDER BY t0.date_maj DESC, t0.id_voyage_serveur DESC;

SELECT 
  t0.id_parametres AS id_parametres_1, 
  t0.date_connexion AS date_connexion_2, 
  t0.date_demande AS date_demande_3, 
  t0.renitialiser AS renitialiser_4, 
  t0.envoyer AS envoyer_5, 
  t0.id_credentiel AS id_credentiel_6, 
  t0.pseudo AS pseudo_7, 
  t0.mot_de_passe AS mot_de_passe_8, 
  t0.email AS email_9, 
  t0.nom AS nom_10, 
  t0.prenom AS prenom_11, 
  t0.date_naiss AS date_naiss_12, 
  t0.ville AS ville_13, 
  t0.id_liste_pays AS id_liste_pays_14, 
  t0.langue AS langue_15, 
  t0.visible AS visible_16, 
  t0.photo AS photo_17, 
  t0.voyage_public AS voyage_public_18, 
  t0.device AS device_19, 
  t0.latitude AS latitude_20, 
  t0.longitude AS longitude_21, 
  t0.lieu_localisation AS lieu_localisation_22, 
  t0.pays_localisation AS pays_localisation_23, 
  t0.facebook_id AS facebook_id_24, 
  t0.google_id AS google_id_25 
FROM 
  parametres t0 
WHERE 
  t0.id_parametres = ?

SELECT t0.id_parametres AS id_parametres_1, t0.date_connexion AS date_connexion_2, t0.date_demande AS date_demande_3, t0.renitialiser AS renitialiser_4, t0.envoyer AS envoyer_5, t0.id_credentiel AS id_credentiel_6, t0.pseudo AS pseudo_7, t0.mot_de_passe AS mot_de_passe_8, t0.email AS email_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.date_naiss AS date_naiss_12, t0.ville AS ville_13, t0.id_liste_pays AS id_liste_pays_14, t0.langue AS langue_15, t0.visible AS visible_16, t0.photo AS photo_17, t0.voyage_public AS voyage_public_18, t0.device AS device_19, t0.latitude AS latitude_20, t0.longitude AS longitude_21, t0.lieu_localisation AS lieu_localisation_22, t0.pays_localisation AS pays_localisation_23, t0.facebook_id AS facebook_id_24, t0.google_id AS google_id_25 FROM parametres t0 WHERE t0.id_parametres = 469;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 322

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 322;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 355 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 355 AND `etapes`.`num_etape` = 1;

SELECT 
  m0_.id AS id_0, 
  m0_.id_maitre AS id_maitre_1, 
  m0_.id_pere AS id_pere_2, 
  m0_.id_parametre AS id_parametre_3, 
  m0_.message AS message_4, 
  m0_.date_creation AS date_creation_5, 
  m0_.date_maj AS date_maj_6 
FROM 
  message_parametre m0_ 
ORDER BY 
  m0_.id DESC

SELECT m0_.id AS id_0, m0_.id_maitre AS id_maitre_1, m0_.id_pere AS id_pere_2, m0_.id_parametre AS id_parametre_3, m0_.message AS message_4, m0_.date_creation AS date_creation_5, m0_.date_maj AS date_maj_6 FROM message_parametre m0_ ORDER BY m0_.id DESC;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 307

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 307;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 478

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 478;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 318 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 318 AND `etapes`.`num_etape` = 1;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 34

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 34;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 282

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 282;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 232 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 232 AND `etapes`.`num_etape` = 1;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 355

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 355;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 267 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 267 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 27 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 27 AND `etapes`.`num_etape` = 1;

SELECT 
  i0_.id AS id_0, 
  i0_.lang AS lang_1, 
  i0_.contenu AS contenu_2, 
  i0_.slug AS slug_3 
FROM 
  information_translation i0_

SELECT i0_.id AS id_0, i0_.lang AS lang_1, i0_.contenu AS contenu_2, i0_.slug AS slug_3 FROM information_translation i0_;

SELECT 
  l0_.id_liste_video AS id_liste_video_0, 
  l0_.libelle AS libelle_1, 
  l0_.lien_liste AS lien_liste_2, 
  l0_.publier AS publier_3 
FROM 
  liste_videos l0_ 
WHERE 
  l0_.publier = 0

SELECT l0_.id_liste_video AS id_liste_video_0, l0_.libelle AS libelle_1, l0_.lien_liste AS lien_liste_2, l0_.publier AS publier_3 FROM liste_videos l0_ WHERE l0_.publier = 0;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 272

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 272;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 252

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 252;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 268

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 268;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 77 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 77 AND `etapes`.`num_etape` = 1;

SELECT 
  * 
FROM 
  `message_parametre` 
WHERE 
  `message_parametre`.`id_pere` = 40 
  AND `message_parametre`.`id_maitre` = 1

SELECT * FROM `message_parametre` WHERE `message_parametre`.`id_pere` = 40 AND `message_parametre`.`id_maitre` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 306 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 306 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 36 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 36 AND `etapes`.`num_etape` = 1;

SELECT 
  * 
FROM 
  `message_parametre` 
WHERE 
  `message_parametre`.`id_pere` = 35 
  AND `message_parametre`.`id_maitre` = 1

SELECT * FROM `message_parametre` WHERE `message_parametre`.`id_pere` = 35 AND `message_parametre`.`id_maitre` = 1;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 228

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 228;

SELECT 
  * 
FROM 
  `message_parametre` 
WHERE 
  `message_parametre`.`id_pere` = 36 
  AND `message_parametre`.`id_maitre` = 1

SELECT * FROM `message_parametre` WHERE `message_parametre`.`id_pere` = 36 AND `message_parametre`.`id_maitre` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 223 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 223 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 120 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 120 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 148 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 148 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 136 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 136 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 34 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 34 AND `etapes`.`num_etape` = 1;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 77

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 77;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 161

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 161;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 344 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 344 AND `etapes`.`num_etape` = 1;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 328

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 328;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 293

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 293;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 168 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 168 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 171 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 171 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 321 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 321 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 348 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 348 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 351 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 351 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 275 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 275 AND `etapes`.`num_etape` = 1;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 171

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 171;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 75 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 75 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 57 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 57 AND `etapes`.`num_etape` = 1;

SELECT 
  * 
FROM 
  `message_parametre` 
WHERE 
  `message_parametre`.`id_pere` = 31 
  AND `message_parametre`.`id_maitre` = 1

SELECT * FROM `message_parametre` WHERE `message_parametre`.`id_pere` = 31 AND `message_parametre`.`id_maitre` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 271 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 271 AND `etapes`.`num_etape` = 1;

SELECT 
  * 
FROM 
  `message_parametre` 
WHERE 
  `message_parametre`.`id_pere` = 32 
  AND `message_parametre`.`id_maitre` = 1

SELECT * FROM `message_parametre` WHERE `message_parametre`.`id_pere` = 32 AND `message_parametre`.`id_maitre` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 208 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 208 AND `etapes`.`num_etape` = 1;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 206

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 206;

SELECT 
  * 
FROM 
  `message_parametre` 
WHERE 
  `message_parametre`.`id_pere` = 34 
  AND `message_parametre`.`id_maitre` = 1

SELECT * FROM `message_parametre` WHERE `message_parametre`.`id_pere` = 34 AND `message_parametre`.`id_maitre` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 250 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 250 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 181 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 181 AND `etapes`.`num_etape` = 1;

SELECT 
  * 
FROM 
  `message_parametre` 
WHERE 
  `message_parametre`.`id_pere` = 45 
  AND `message_parametre`.`id_maitre` = 1

SELECT * FROM `message_parametre` WHERE `message_parametre`.`id_pere` = 45 AND `message_parametre`.`id_maitre` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 214 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 214 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 74 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 74 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 42 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 42 AND `etapes`.`num_etape` = 1;

SELECT 
  * 
FROM 
  `message_parametre` 
WHERE 
  `message_parametre`.`id_pere` = 39 
  AND `message_parametre`.`id_maitre` = 1

SELECT * FROM `message_parametre` WHERE `message_parametre`.`id_pere` = 39 AND `message_parametre`.`id_maitre` = 1;

SELECT 
  COUNT(*) 
FROM 
  `jaime` 
WHERE 
  `jaime`.`id_voyage_serveur` = 180

SELECT COUNT(*) FROM `jaime` WHERE `jaime`.`id_voyage_serveur` = 180;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 226 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 226 AND `etapes`.`num_etape` = 1;

SELECT 
  `liste_pays_translation`.`pays` 
FROM 
  `liste_pays_translation` 
  INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` 
WHERE 
  `etapes`.`id_voyage_serveur` = 229 
  AND `etapes`.`num_etape` = 1

SELECT `liste_pays_translation`.`pays` FROM `liste_pays_translation` INNER JOIN `etapes` ON `etapes`.`id_liste_pays` = `liste_pays_translation`.`id_liste_pays` WHERE `etapes`.`id_voyage_serveur` = 229 AND `etapes`.`num_etape` = 1;