Symfony Profiler

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 
  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 
  * 
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 
  t0.id_liste_menu AS id_liste_menu_1, 
  t0.id_liste_menu_parent AS id_liste_menu_parent_2, 
  t0.url AS url_3, 
  t0.ordre AS ordre_4, 
  t0.active AS active_5 
FROM 
  liste_menu t0

SELECT t0.id_liste_menu AS id_liste_menu_1, t0.id_liste_menu_parent AS id_liste_menu_parent_2, t0.url AS url_3, t0.ordre AS ordre_4, t0.active AS active_5 FROM liste_menu t0;

select 
  * 
from 
  liste_menu as m 
  Left join liste_menu_translation as t ON t.id_liste_menu = m.id_liste_menu 
where 
  m.active = 1 
  and t.lang = "en" 
ORDER BY 
  m.id_liste_menu ASC, 
  m.id_liste_menu_parent ASC, 
  m.ordre ASC

select * from liste_menu as m Left join liste_menu_translation as t ON t.id_liste_menu = m.id_liste_menu where m.active =1  and  t.lang = "en"  ORDER BY m.id_liste_menu ASC,m.id_liste_menu_parent ASC, m.ordre ASC;

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 
  `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` = 531 
  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` = 531 AND `etapes`.`num_etape` = 1;

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

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

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` = 530 
  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` = 530 AND `etapes`.`num_etape` = 1;

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

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

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` = 529 
  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` = 529 AND `etapes`.`num_etape` = 1;

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

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

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` = 528 
  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` = 528 AND `etapes`.`num_etape` = 1;

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

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

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` = 527 
  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` = 527 AND `etapes`.`num_etape` = 1;

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

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

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` = 374 
  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` = 374 AND `etapes`.`num_etape` = 1;

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

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

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` = 526 
  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` = 526 AND `etapes`.`num_etape` = 1;

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

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

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` = 525 
  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` = 525 AND `etapes`.`num_etape` = 1;

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

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

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` = 522 
  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` = 522 AND `etapes`.`num_etape` = 1;

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

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

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` = 523 
  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` = 523 AND `etapes`.`num_etape` = 1;

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

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

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` = 504 
  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` = 504 AND `etapes`.`num_etape` = 1;

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

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

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` = 521 
  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` = 521 AND `etapes`.`num_etape` = 1;

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

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

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` = 520 
  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` = 520 AND `etapes`.`num_etape` = 1;

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

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

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` = 519 
  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` = 519 AND `etapes`.`num_etape` = 1;

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

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

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` = 518 
  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` = 518 AND `etapes`.`num_etape` = 1;

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

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

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` = 517 
  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` = 517 AND `etapes`.`num_etape` = 1;

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

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

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` = 516 
  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` = 516 AND `etapes`.`num_etape` = 1;

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

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

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` = 515 
  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` = 515 AND `etapes`.`num_etape` = 1;

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

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

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` = 514 
  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` = 514 AND `etapes`.`num_etape` = 1;

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

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

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` = 513 
  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` = 513 AND `etapes`.`num_etape` = 1;

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

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

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` = 512 
  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` = 512 AND `etapes`.`num_etape` = 1;

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

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

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` = 511 
  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` = 511 AND `etapes`.`num_etape` = 1;

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

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

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` = 510 
  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` = 510 AND `etapes`.`num_etape` = 1;

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

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

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` = 509 
  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` = 509 AND `etapes`.`num_etape` = 1;

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

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

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` = 506 
  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` = 506 AND `etapes`.`num_etape` = 1;

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

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

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` = 507 
  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` = 507 AND `etapes`.`num_etape` = 1;

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

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

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` = 505 
  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` = 505 AND `etapes`.`num_etape` = 1;

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

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

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` = 503 
  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` = 503 AND `etapes`.`num_etape` = 1;

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

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

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` = 479 
  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` = 479 AND `etapes`.`num_etape` = 1;

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

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

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` = 501 
  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` = 501 AND `etapes`.`num_etape` = 1;

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

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

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` = 497 
  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` = 497 AND `etapes`.`num_etape` = 1;

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

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

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` = 494 
  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` = 494 AND `etapes`.`num_etape` = 1;

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

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

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` = 121 
  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` = 121 AND `etapes`.`num_etape` = 1;

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

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

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` = 496 
  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` = 496 AND `etapes`.`num_etape` = 1;

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

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

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` = 486 
  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` = 486 AND `etapes`.`num_etape` = 1;

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

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

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` = 482 
  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` = 482 AND `etapes`.`num_etape` = 1;

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

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

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` = 493 
  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` = 493 AND `etapes`.`num_etape` = 1;

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

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

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` = 492 
  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` = 492 AND `etapes`.`num_etape` = 1;

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

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

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` = 491 
  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` = 491 AND `etapes`.`num_etape` = 1;

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

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

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` = 490 
  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` = 490 AND `etapes`.`num_etape` = 1;

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

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

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` = 488 
  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` = 488 AND `etapes`.`num_etape` = 1;

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

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

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` = 489 
  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` = 489 AND `etapes`.`num_etape` = 1;

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

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

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` = 487 
  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` = 487 AND `etapes`.`num_etape` = 1;

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

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