LYON NATATION METROPOLE

63 Rue Bellecombe
69006 LYON

Plan Google Maps
Tél : 04 72 74 16 19
Secrétariat contact@lyonnatationmetropole.com
Nous écrire
Correspondant :
Myriam Liobard

FFN : 3 35 069 00220

Accueil

Abcnatation

Le club

Assemblée Générale 2018-2019

Publié le 04/11/2019 à 09h41

Madame, Mademoiselle, Monsieur,

Nous vous informons que l’Assemblée Générale de Lyon Natation Métropole se tiendra le

Mardi 26 novembre 2019 à 19h00

Salle Jean COUTY – 56...
[Lire]

Twitter

Le club

Vacances d'automne

Publié le 11/10/2019 à 17h51

[Lire]

Twitter

Le club

Inscriptions à la piscine Charial !

Publié le 16/09/2019 à 07h46 - Mis à jour le 23/09/2019 à 15h55

Il ne reste que quelques places disponibles !

Pour vous inscrire, 2 possibilités :

- internet, sur notre boutique : https://www.boutiquelyonnatation.fr/

- à la permanence de la piscine Charial, toute la semaine de 17h à 19h

Ne tardez pas, il n'y en aura pas pour tout le monde....

[Lire]

Twitter

Le club

Inscriptions 2019-2020

Publié le 27/08/2019 à 10h00 - Mis à jour le 27/08/2019 à 10h04

Reprise des inscriptions !

Les inscriptions sont de nouveau possibles à partir de cette semaine, au 63 rue Bellecombe 69006 Lyon :

- les mercredis, de 10h à 19h

- les lundis, mardis, jeudis et vendredis de 11h à 14h et de 17h à 19h

Les inscriptions sur internet restent possibles sur notre boutique : [Lire]

Twitter

Le club

Stages d'été Lyon Natation

Publié le 17/04/2019 à 14h51 - Mis à jour le 17/04/2019 à 14h59

En juillet 2019, Lyon Natation Métropole

organise des stages sportifs Natation & Multisports

pour les enfants de 6 à 13 ans.

Pour téléchargez le formulaire d'inscription, cliquez : ici.

Pour vous inscrire en...
[Lire]

Twitter

Le club

Championnat de France juniors

Publié le 18/03/2019 à 11h29 - Mis à jour le 18/03/2019 à 11h31

Championnats de France Juniors : un très bon cru pour Lyon Natation Lyon Natation métropole

- 1 titre de championne de France
- 2 médailles de bronze
- 4 finale A
- 4 finales B
- 1 finale C

3 nageurs...
[Lire]

Twitter

Voir toutes les actualités

Bienvenue à Lyon Natation Métropole !

Menu

  Accueil
Accueil
  Actualités
  Le Club
Historique
Conseil d’Administration
Équipe technique
  Activités
Loisirs
Compétitions
Sport-santé
  Photos
  Boutique
Accéder à la boutique
  Contact

Notice (8): Constant RACINE_CLUB already defined [APP/Controller/AppController.php, line 452]
Code Context
                                      define('RACINE_CLUB', 'https://' . $domain . '/');
$controller = 'club_partenaires' $domain = 'lyonnatationmetropole.com' $Club = array( 'Club' => array( ), 'Coordonnee' => array( ), 'ScfStructureType' => array( ), 'ScfStructureStatut' => array( ), 'Departement' => array( ), 'Region' => array( ), 'Profil' => array( ), 'Piscine' => array( ), 'ClubActiv' => array( ) )
define - [internal], line ?? AppController::detectNdd() - APP/Controller/AppController.php, line 452 AppController::beforeFilter() - APP/Controller/AppController.php, line 45 ClubManagerAppController::beforeFilter() - APP/Plugin/ClubManager/Controller/ClubManagerAppController.php, line 8 ClubPartenairesController::beforeFilter() - APP/Plugin/ClubManager/Controller/ClubPartenairesController.php, line 17 call_user_func - [internal], line ?? CakeEventManager::dispatch() - APP/cakephp/lib/Cake/Event/CakeEventManager.php, line 246 Controller::startupProcess() - APP/cakephp/lib/Cake/Controller/Controller.php, line 670 Dispatcher::_invoke() - APP/cakephp/lib/Cake/Routing/Dispatcher.php, line 100 Dispatcher::dispatch() - APP/cakephp/lib/Cake/Routing/Dispatcher.php, line 85 Object::requestAction() - APP/cakephp/lib/Cake/Core/Object.php, line 97 include - APP/Plugin/SiteClub/View/Elements/partenaires.ctp, line 2 View::_evaluate() - APP/cakephp/lib/Cake/View/View.php, line 908 View::_render() - APP/cakephp/lib/Cake/View/View.php, line 872 View::element() - APP/cakephp/lib/Cake/View/View.php, line 412 include - APP/Plugin/SiteClub/View/Layouts/default.ctp, line 387 View::_evaluate() - APP/cakephp/lib/Cake/View/View.php, line 908 View::_render() - APP/cakephp/lib/Cake/View/View.php, line 872
Notice (8): Constant RACINE_ABC already defined [APP/Controller/AppController.php, line 474]
Code Context
            define('RACINE_ABC', 'https://preprod.abcnatation.fr');         else             define('RACINE_ABC', 'https://www.abcnatation.fr');
$controller = 'club_partenaires' $domain = 'lyonnatationmetropole.com' $Club = array( 'Club' => array( ), 'Coordonnee' => array( ), 'ScfStructureType' => array( ), 'ScfStructureStatut' => array( ), 'Departement' => array( ), 'Region' => array( ), 'Profil' => array( ), 'Piscine' => array( ), 'ClubActiv' => array( ) )
define - [internal], line ?? AppController::detectNdd() - APP/Controller/AppController.php, line 474 AppController::beforeFilter() - APP/Controller/AppController.php, line 45 ClubManagerAppController::beforeFilter() - APP/Plugin/ClubManager/Controller/ClubManagerAppController.php, line 8 ClubPartenairesController::beforeFilter() - APP/Plugin/ClubManager/Controller/ClubPartenairesController.php, line 17 call_user_func - [internal], line ?? CakeEventManager::dispatch() - APP/cakephp/lib/Cake/Event/CakeEventManager.php, line 246 Controller::startupProcess() - APP/cakephp/lib/Cake/Controller/Controller.php, line 670 Dispatcher::_invoke() - APP/cakephp/lib/Cake/Routing/Dispatcher.php, line 100 Dispatcher::dispatch() - APP/cakephp/lib/Cake/Routing/Dispatcher.php, line 85 Object::requestAction() - APP/cakephp/lib/Cake/Core/Object.php, line 97 include - APP/Plugin/SiteClub/View/Elements/partenaires.ctp, line 2 View::_evaluate() - APP/cakephp/lib/Cake/View/View.php, line 908 View::_render() - APP/cakephp/lib/Cake/View/View.php, line 872 View::element() - APP/cakephp/lib/Cake/View/View.php, line 412 include - APP/Plugin/SiteClub/View/Layouts/default.ctp, line 387 View::_evaluate() - APP/cakephp/lib/Cake/View/View.php, line 908 View::_render() - APP/cakephp/lib/Cake/View/View.php, line 872

(default) 83 queries took 641 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`sous_domaine` = 'lyonnatationmetropole.com' LIMIT 1	1	1	0
2	SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')	6	6	0
3	SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '170690532' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`)	14	14	0
4	SELECT `Clubs`.`id`, `Clubs`.`statut`, `Clubs`.`abonne_depuis`, `Clubs`.`name`, `Clubs`.`name_officiel`, `Clubs`.`offre_v2`, `Clubs`.`siret`, `Clubs`.`cnil`, `Clubs`.`agrement`, `Clubs`.`code_parrain`, `Clubs`.`nation`, `Clubs`.`correspondant_licencie_id`, `Clubs`.`scf_structure_type_id`, `Clubs`.`scf_structure_statut_id`, `Clubs`.`sport_id`, `Clubs`.`profil_id`, `Clubs`.`coordonnee_id`, `Clubs`.`departement_id`, `Clubs`.`region_id`, `Clubs`.`correspondant`, `Clubs`.`content_id`, `Clubs`.`content_type_id`, `Clubs`.`maj_ffn`, `Clubs`.`maj_csv`, `Clubs`.`logo_upload`, `Clubs`.`signature_upload`, `Clubs`.`site_web`, `Clubs`.`sous_domaine`, `Clubs`.`assurance`, `Clubs`.`label`, `Clubs`.`email`, `Clubs`.`email_webmaster`, `Clubs`.`email_expediteur`, `Clubs`.`option_membre_illimite`, `Clubs`.`option_scoring_pro`, `Clubs`.`option_inscriptions`, `Clubs`.`option_convocations`, `Clubs`.`option_domaine`, `Clubs`.`date_fin_membre_illimite`, `Clubs`.`date_fin_scoring_pro`, `Clubs`.`date_fin_inscriptions`, `Clubs`.`date_fin_convocations`, `Clubs`.`date_fin_option_domaine`, `Clubs`.`date_fin_site_web`, `Clubs`.`forcer_recevoir_news`, `Clubs`.`IdCISS`, `Clubs`.`PassCISS`, `Clubs`.`idWallet`, `Clubs`.`url_swimcommunity`, `Clubs`.`activer_sc`, `Clubs`.`activer_pagesc`, `Clubs`.`txtbtn_swimcommunity`, `Clubs`.`h1_sc`, `Clubs`.`page1_swimcommunity`, `Clubs`.`page2_swimcommunity` FROM `abcnatation-fr`.`clubs` AS `Clubs` WHERE `Clubs`.`id` IS NULL LIMIT 1	0	0	0
5	SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC	9	9	0
6	SELECT `SiteWeb`.`id`, `SiteWeb`.`club_id`, `SiteWeb`.`statut`, `SiteWeb`.`url_bandeau`, `SiteWeb`.`msg_bandeau`, `SiteWeb`.`saison_id`, `SiteWeb`.`degroupe_menu_activite`, `SiteWeb`.`degroupe_menu_evenements`, `SiteWeb`.`degroupe_menu_commissions`, `SiteWeb`.`actualites`, `SiteWeb`.`cache_auteur_actu`, `SiteWeb`.`cache_pictos_menu`, `SiteWeb`.`cache_accueil`, `SiteWeb`.`cache_email`, `SiteWeb`.`publication`, `SiteWeb`.`cache_email_web`, `SiteWeb`.`nom_medias`, `SiteWeb`.`widget_part`, `SiteWeb`.`widget_part_top_position`, `SiteWeb`.`widget_photos`, `SiteWeb`.`widget_res`, `SiteWeb`.`widget_pages`, `SiteWeb`.`widget_cal`, `SiteWeb`.`widget_act`, `SiteWeb`.`gestion_droits`, `SiteWeb`.`boutique`, `SiteWeb`.`forcer_recevoir_news`, `SiteWeb`.`flickr_user_id`, `SiteWeb`.`template`, `SiteWeb`.`recaptcha`, `SiteWeb`.`meta_description` FROM `abcnatation-fr`.`site_webs` AS `SiteWeb` WHERE `SiteWeb`.`club_id` IS NULL LIMIT 1	0	0	0
7	SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE `date_debut` <= '2019-12-06' AND `date_fin` > '2019-12-06' LIMIT 1	1	1	0
8	SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE ((`Club`.`sous_domaine` = '170690532') OR (`Club`.`id` = '170690532')) LIMIT 1	1	1	0
9	SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')	6	6	0
10	SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '170690532' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`)	14	14	0
11	SELECT `Clubs`.`id`, `Clubs`.`statut`, `Clubs`.`abonne_depuis`, `Clubs`.`name`, `Clubs`.`name_officiel`, `Clubs`.`offre_v2`, `Clubs`.`siret`, `Clubs`.`cnil`, `Clubs`.`agrement`, `Clubs`.`code_parrain`, `Clubs`.`nation`, `Clubs`.`correspondant_licencie_id`, `Clubs`.`scf_structure_type_id`, `Clubs`.`scf_structure_statut_id`, `Clubs`.`sport_id`, `Clubs`.`profil_id`, `Clubs`.`coordonnee_id`, `Clubs`.`departement_id`, `Clubs`.`region_id`, `Clubs`.`correspondant`, `Clubs`.`content_id`, `Clubs`.`content_type_id`, `Clubs`.`maj_ffn`, `Clubs`.`maj_csv`, `Clubs`.`logo_upload`, `Clubs`.`signature_upload`, `Clubs`.`site_web`, `Clubs`.`sous_domaine`, `Clubs`.`assurance`, `Clubs`.`label`, `Clubs`.`email`, `Clubs`.`email_webmaster`, `Clubs`.`email_expediteur`, `Clubs`.`option_membre_illimite`, `Clubs`.`option_scoring_pro`, `Clubs`.`option_inscriptions`, `Clubs`.`option_convocations`, `Clubs`.`option_domaine`, `Clubs`.`date_fin_membre_illimite`, `Clubs`.`date_fin_scoring_pro`, `Clubs`.`date_fin_inscriptions`, `Clubs`.`date_fin_convocations`, `Clubs`.`date_fin_option_domaine`, `Clubs`.`date_fin_site_web`, `Clubs`.`forcer_recevoir_news`, `Clubs`.`IdCISS`, `Clubs`.`PassCISS`, `Clubs`.`idWallet`, `Clubs`.`url_swimcommunity`, `Clubs`.`activer_sc`, `Clubs`.`activer_pagesc`, `Clubs`.`txtbtn_swimcommunity`, `Clubs`.`h1_sc`, `Clubs`.`page1_swimcommunity`, `Clubs`.`page2_swimcommunity` FROM `abcnatation-fr`.`clubs` AS `Clubs` WHERE `Clubs`.`id` IS NULL LIMIT 1	0	0	0
12	SELECT `SiteWeb`.`id`, `SiteWeb`.`club_id`, `SiteWeb`.`statut`, `SiteWeb`.`url_bandeau`, `SiteWeb`.`msg_bandeau`, `SiteWeb`.`saison_id`, `SiteWeb`.`degroupe_menu_activite`, `SiteWeb`.`degroupe_menu_evenements`, `SiteWeb`.`degroupe_menu_commissions`, `SiteWeb`.`actualites`, `SiteWeb`.`cache_auteur_actu`, `SiteWeb`.`cache_pictos_menu`, `SiteWeb`.`cache_accueil`, `SiteWeb`.`cache_email`, `SiteWeb`.`publication`, `SiteWeb`.`cache_email_web`, `SiteWeb`.`nom_medias`, `SiteWeb`.`widget_part`, `SiteWeb`.`widget_part_top_position`, `SiteWeb`.`widget_photos`, `SiteWeb`.`widget_res`, `SiteWeb`.`widget_pages`, `SiteWeb`.`widget_cal`, `SiteWeb`.`widget_act`, `SiteWeb`.`gestion_droits`, `SiteWeb`.`boutique`, `SiteWeb`.`forcer_recevoir_news`, `SiteWeb`.`flickr_user_id`, `SiteWeb`.`template`, `SiteWeb`.`recaptcha`, `SiteWeb`.`meta_description` FROM `abcnatation-fr`.`site_webs` AS `SiteWeb` WHERE `SiteWeb`.`club_id` = '170690532' LIMIT 1	1	1	0
13	SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`id` = '170690532' LIMIT 1	1	1	0
14	SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')	6	6	0
15	SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '170690532' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`)	14	14	0
16	SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`club_inscription_parametres` AS `ClubInscriptionParametre` WHERE `ClubInscriptionParametre`.`club_id` = '170690532' AND `ClubInscriptionParametre`.`activer` = '1'	1	1	0
17	SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`club_inscription_parametres` AS `ClubInscriptionParametre` WHERE `ClubInscriptionParametre`.`club_id` = '170690532' AND `ClubInscriptionParametre`.`activer_reinscriptions` = '1'	1	1	0
18	SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE `date_debut` <= '2019-12-06' AND `date_fin` > '2019-12-06' LIMIT 1	1	1	0
19	SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '170690532' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = '' ORDER BY `Content`.`position` ASC	3	3	0
20	SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '170690532' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'boutique' ORDER BY `Content`.`position` ASC	1	1	0
21	SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '170690532' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'partenaire' ORDER BY `Content`.`position` ASC	0	0	0
22	SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '170690532' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'footer' ORDER BY `Content`.`position` ASC	0	0	0
23	SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '170690532' AND ((`Content`.`content_type_id` = 7) OR (`Content`.`content_type_id` = 10)) AND `ClubPage`.`menu` = 'home' ORDER BY `Content`.`position` ASC	1	1	0
24	SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '170690532' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'activite' ORDER BY `Content`.`position` ASC	1	1	0
25	SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 7	1	1	0
26	SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 39073	0	0	0
27	SELECT `MentionsLegale`.`id`, `MentionsLegale`.`content_type_id`, `MentionsLegale`.`content_id`, `MentionsLegale`.`adresse_site_web`, `MentionsLegale`.`raison_sociale`, `MentionsLegale`.`forme_juridique`, `MentionsLegale`.`num_siren`, `MentionsLegale`.`code_naf`, `MentionsLegale`.`adresse_siege`, `MentionsLegale`.`responsable_publication`, `MentionsLegale`.`num_cnil`, `MentionsLegale`.`webmaster`, `MentionsLegale`.`createur`, `MentionsLegale`.`hebergeur` FROM `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` WHERE `MentionsLegale`.`content_id` = 39073	0	0	0
28	SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 39073	0	0	0
29	SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 39073	0	0	0
30	SELECT `MediaManagerMedia`.`id`, `MediaManagerMedia`.`content_type_id`, `MediaManagerMedia`.`media_type_id`, `MediaManagerMedia`.`content_id`, `MediaManagerMedia`.`local`, `MediaManagerMedia`.`extention`, `MediaManagerMedia`.`poids`, `MediaManagerMedia`.`nom_fichier`, `MediaManagerMedia`.`nom`, `MediaManagerMedia`.`dossier`, `MediaManagerMedia`.`code_embed` FROM `abcnatation-fr`.`media` AS `MediaManagerMedia` WHERE `MediaManagerMedia`.`content_id` = 39073	0	0	0
31	SELECT `ClubPage`.`id`, `ClubPage`.`content_id`, `ClubPage`.`content_type_id`, `ClubPage`.`club_id`, `ClubPage`.`module`, `ClubPage`.`menu`, `ClubPage`.`activite_id`, `ClubPage`.`commission_id`, `ClubPage`.`edition_id` FROM `abcnatation-fr`.`club_pages` AS `ClubPage` WHERE `ClubPage`.`content_id` = 39073	1	1	0
32	SELECT `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` WHERE `Content`.`id` = 39073	1	1	0
33	SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`clubs` AS `Club` WHERE `Club`.`id` = '170690532'	1	1	0
34	SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 7	1	1	0
35	SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '170690532' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'commission' ORDER BY `Content`.`position` ASC	0	0	0
36	SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '170690532' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'edition' ORDER BY `Content`.`position` ASC	0	0	0
37	SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '170690532' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'medias' ORDER BY `Content`.`position` ASC	0	0	0
38	SELECT `ClubActu`.`id`, `ClubActu`.`club_id`, `ClubActu`.`profil_id`, `ClubActu`.`content_id`, `ClubActu`.`epingler`, `ClubActu`.`cache_accueil`, `ClubActu`.`image`, `ClubActu`.`content_type_id`, `ClubActu`.`clubactivites_club_id`, `ClubActu`.`club_group_id`, `ClubActu`.`clubevenements_club_id`, `ClubActu`.`clubcommissions_club_id`, `ClubActu`.`club_edition_id`, `ClubActu`.`email`, `ClubActu`.`sc_competition_id`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `ClubEdition`.`id`, `ClubEdition`.`nom`, `ClubEdition`.`etat_id`, `ClubEdition`.`saison_id`, `ClubEdition`.`club_id`, `ClubEdition`.`clubevenements_club_id`, `ClubEdition`.`startdate`, `ClubEdition`.`stopdate`, `ClubEdition`.`presentation`, `ClubEdition`.`url_affiche`, `ClubEdition`.`coordonnee_id`, `ClubEdition`.`rght`, `ClubEdition`.`lft`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre`, `ClubGroup`.`id`, `ClubGroup`.`nom`, `ClubGroup`.`ordre`, `ClubGroup`.`saison_id`, `ClubGroup`.`club_id`, `ClubGroup`.`clubactivites_club_id`, `ClubGroup`.`club_niveau_pratique_id`, `ClubGroup`.`inscription_niveau_seance`, `ClubGroup`.`inscription_niveau_lot_seance`, `ClubGroup`.`seances_lots`, `ClubGroup`.`nb_seances_min`, `ClubGroup`.`nb_seances_max`, `ClubGroup`.`type_categorie`, `ClubGroup`.`age_min`, `ClubGroup`.`age_max`, `ClubGroup`.`annee_min`, `ClubGroup`.`annee_max`, `ClubGroup`.`categories`, `ClubGroup`.`nbr_place`, `ClubGroup`.`presentation`, `ClubGroup`.`presentation_courte`, `ClubGroup`.`criteres_acces`, `ClubGroup`.`obj_sportif`, `ClubGroup`.`parent_id`, `ClubGroup`.`rght`, `ClubGroup`.`lft`, `ClubGroup`.`affiche_membres`, `ClubGroup`.`affiche_membres_affectes`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`club_actus` AS `ClubActu` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubActu`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubActu`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` ON (`ClubActu`.`clubevenements_club_id` = `ClubevenementsClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_editions` AS `ClubEdition` ON (`ClubActu`.`club_edition_id` = `ClubEdition`.`id`) LEFT JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubActu`.`clubactivites_club_id` = `ClubactivitesClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_groups` AS `ClubGroup` ON (`ClubActu`.`club_group_id` = `ClubGroup`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubActu`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`ClubActu`.`profil_id` = `Profil`.`id`) WHERE `ClubActu`.`club_id` = '170690532' AND ((NOT (`Content`.`etat_id` = '0')) OR (`Content`.`etat_id` = '1'))	22	22	1
39	SELECT `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` WHERE `ClubactivitesClub`.`club_id` = '170690532' AND `ClubactivitesClub`.`saison_id` = '2019-2020' ORDER BY `ClubactivitesClub`.`ordre` ASC	3	3	0
40	SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE `date_debut` <= '2019-12-06' AND `date_fin` > '2019-12-06' LIMIT 1	1	1	0
41	SELECT `ClubcommissionsClub`.`id`, `ClubcommissionsClub`.`clubcommission_id`, `ClubcommissionsClub`.`club_id`, `ClubcommissionsClub`.`libelle`, `ClubcommissionsClub`.`saison_id`, `ClubcommissionsClub`.`presentation`, `ClubcommissionsClub`.`ordre`, `Clubcommission`.`id`, `Clubcommission`.`description`, `Clubcommission`.`type`, `Clubcommission`.`activite_id`, `Clubcommission`.`ordre` FROM `abcnatation-fr`.`clubcommissions_clubs` AS `ClubcommissionsClub` LEFT JOIN `abcnatation-fr`.`clubcommissions` AS `Clubcommission` ON (`ClubcommissionsClub`.`clubcommission_id` = `Clubcommission`.`id`) WHERE `ClubcommissionsClub`.`club_id` = '170690532' AND `ClubcommissionsClub`.`saison_id` = '2019-2020' ORDER BY `ClubcommissionsClub`.`ordre` ASC	0	0	0
42	SELECT `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `Clubevenement`.`id`, `Clubevenement`.`description` FROM `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` LEFT JOIN `abcnatation-fr`.`clubevenements` AS `Clubevenement` ON (`ClubevenementsClub`.`clubevenement_id` = `Clubevenement`.`id`) WHERE `ClubevenementsClub`.`club_id` = '170690532' AND `ClubevenementsClub`.`etat_id` = '1'	0	0	0
43	SELECT `ClubAlbum`.`id`, `ClubAlbum`.`name`, `ClubAlbum`.`description`, `ClubAlbum`.`lien_externe`, `ClubAlbum`.`club_id`, `ClubAlbum`.`cache_accueil`, `ClubAlbum`.`profil_id`, `ClubAlbum`.`date`, `ClubAlbum`.`created`, `ClubAlbum`.`updated` FROM `abcnatation-fr`.`club_albums` AS `ClubAlbum` WHERE `ClubAlbum`.`club_id` = '170690532'	28	28	0
44	SELECT `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Vignette`.`id`, `Vignette`.`content_type_id`, `Vignette`.`media_type_id`, `Vignette`.`content_id`, `Vignette`.`local`, `Vignette`.`extention`, `Vignette`.`poids`, `Vignette`.`nom_fichier`, `Vignette`.`nom`, `Vignette`.`dossier`, `Vignette`.`code_embed`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Group`.`id`, `Group`.`parent_id`, `Group`.`name`, `Group`.`created`, `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id`, `MentionsLegale`.`id`, `MentionsLegale`.`content_type_id`, `MentionsLegale`.`content_id`, `MentionsLegale`.`adresse_site_web`, `MentionsLegale`.`raison_sociale`, `MentionsLegale`.`forme_juridique`, `MentionsLegale`.`num_siren`, `MentionsLegale`.`code_naf`, `MentionsLegale`.`adresse_siege`, `MentionsLegale`.`responsable_publication`, `MentionsLegale`.`num_cnil`, `MentionsLegale`.`webmaster`, `MentionsLegale`.`createur`, `MentionsLegale`.`hebergeur`, `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id`, `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id`, `MediaManagerMedia`.`id`, `MediaManagerMedia`.`content_type_id`, `MediaManagerMedia`.`media_type_id`, `MediaManagerMedia`.`content_id`, `MediaManagerMedia`.`local`, `MediaManagerMedia`.`extention`, `MediaManagerMedia`.`poids`, `MediaManagerMedia`.`nom_fichier`, `MediaManagerMedia`.`nom`, `MediaManagerMedia`.`dossier`, `MediaManagerMedia`.`code_embed`, `ClubPage`.`id`, `ClubPage`.`content_id`, `ClubPage`.`content_type_id`, `ClubPage`.`club_id`, `ClubPage`.`module`, `ClubPage`.`menu`, `ClubPage`.`activite_id`, `ClubPage`.`commission_id`, `ClubPage`.`edition_id` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `ClubPage`.`menu` = 'medias' AND `ClubPage`.`club_id` = '170690532' AND `Content`.`content_type_id` = 7 AND `Content`.`etat_id` = '1'	0	0	0
45	SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`id` = '170690532' LIMIT 1	1	1	0
46	SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')	6	6	0
47	SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '170690532' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`)	14	14	0
48	SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`id` = '170690532' LIMIT 1	1	1	0
49	SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')	6	6	0
50	SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '170690532' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`)	14	14	0
51	SELECT `ClubNum`.`id`, `ClubNum`.`club_id_10`, `ClubNum`.`club_id`, `ClubNum`.`name_officiel`, `ClubNum`.`name_usuel`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`club_nums` AS `ClubNum` LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubNum`.`club_id` = `Club`.`id`) WHERE `ClubNum`.`club_id` = '170690532' LIMIT 1	1	1	1
52	SELECT `SiteWeb`.`id`, `SiteWeb`.`club_id`, `SiteWeb`.`statut`, `SiteWeb`.`url_bandeau`, `SiteWeb`.`msg_bandeau`, `SiteWeb`.`saison_id`, `SiteWeb`.`degroupe_menu_activite`, `SiteWeb`.`degroupe_menu_evenements`, `SiteWeb`.`degroupe_menu_commissions`, `SiteWeb`.`actualites`, `SiteWeb`.`cache_auteur_actu`, `SiteWeb`.`cache_pictos_menu`, `SiteWeb`.`cache_accueil`, `SiteWeb`.`cache_email`, `SiteWeb`.`publication`, `SiteWeb`.`cache_email_web`, `SiteWeb`.`nom_medias`, `SiteWeb`.`widget_part`, `SiteWeb`.`widget_part_top_position`, `SiteWeb`.`widget_photos`, `SiteWeb`.`widget_res`, `SiteWeb`.`widget_pages`, `SiteWeb`.`widget_cal`, `SiteWeb`.`widget_act`, `SiteWeb`.`gestion_droits`, `SiteWeb`.`boutique`, `SiteWeb`.`forcer_recevoir_news`, `SiteWeb`.`flickr_user_id`, `SiteWeb`.`template`, `SiteWeb`.`recaptcha`, `SiteWeb`.`meta_description` FROM `abcnatation-fr`.`site_webs` AS `SiteWeb` WHERE `SiteWeb`.`club_id` = '170690532' LIMIT 1	1	1	0
53	SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`id` = '170690532' LIMIT 1	1	1	0
54	SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')	6	6	0
55	SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '170690532' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`)	14	14	0
56	SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`club_inscription_parametres` AS `ClubInscriptionParametre` WHERE `ClubInscriptionParametre`.`club_id` = '170690532' AND `ClubInscriptionParametre`.`activer` = '1'	1	1	0
57	SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`club_inscription_parametres` AS `ClubInscriptionParametre` WHERE `ClubInscriptionParametre`.`club_id` = '170690532' AND `ClubInscriptionParametre`.`activer_reinscriptions` = '1'	1	1	0
58	SELECT `ClubActu`.`id`, `ClubActu`.`club_id`, `ClubActu`.`profil_id`, `ClubActu`.`content_id`, `ClubActu`.`epingler`, `ClubActu`.`cache_accueil`, `ClubActu`.`image`, `ClubActu`.`content_type_id`, `ClubActu`.`clubactivites_club_id`, `ClubActu`.`club_group_id`, `ClubActu`.`clubevenements_club_id`, `ClubActu`.`clubcommissions_club_id`, `ClubActu`.`club_edition_id`, `ClubActu`.`email`, `ClubActu`.`sc_competition_id`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `ClubEdition`.`id`, `ClubEdition`.`nom`, `ClubEdition`.`etat_id`, `ClubEdition`.`saison_id`, `ClubEdition`.`club_id`, `ClubEdition`.`clubevenements_club_id`, `ClubEdition`.`startdate`, `ClubEdition`.`stopdate`, `ClubEdition`.`presentation`, `ClubEdition`.`url_affiche`, `ClubEdition`.`coordonnee_id`, `ClubEdition`.`rght`, `ClubEdition`.`lft`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre`, `ClubGroup`.`id`, `ClubGroup`.`nom`, `ClubGroup`.`ordre`, `ClubGroup`.`saison_id`, `ClubGroup`.`club_id`, `ClubGroup`.`clubactivites_club_id`, `ClubGroup`.`club_niveau_pratique_id`, `ClubGroup`.`inscription_niveau_seance`, `ClubGroup`.`inscription_niveau_lot_seance`, `ClubGroup`.`seances_lots`, `ClubGroup`.`nb_seances_min`, `ClubGroup`.`nb_seances_max`, `ClubGroup`.`type_categorie`, `ClubGroup`.`age_min`, `ClubGroup`.`age_max`, `ClubGroup`.`annee_min`, `ClubGroup`.`annee_max`, `ClubGroup`.`categories`, `ClubGroup`.`nbr_place`, `ClubGroup`.`presentation`, `ClubGroup`.`presentation_courte`, `ClubGroup`.`criteres_acces`, `ClubGroup`.`obj_sportif`, `ClubGroup`.`parent_id`, `ClubGroup`.`rght`, `ClubGroup`.`lft`, `ClubGroup`.`affiche_membres`, `ClubGroup`.`affiche_membres_affectes`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`club_actus` AS `ClubActu` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubActu`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubActu`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` ON (`ClubActu`.`clubevenements_club_id` = `ClubevenementsClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_editions` AS `ClubEdition` ON (`ClubActu`.`club_edition_id` = `ClubEdition`.`id`) LEFT JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubActu`.`clubactivites_club_id` = `ClubactivitesClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_groups` AS `ClubGroup` ON (`ClubActu`.`club_group_id` = `ClubGroup`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubActu`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`ClubActu`.`profil_id` = `Profil`.`id`) WHERE `ClubActu`.`club_id` = '170690532' AND `ClubActu`.`epingler` = 0 AND `Content`.`etat_id` = '1' AND `ClubActu`.`cache_accueil` = '0' ORDER BY `Content`.`created` desc LIMIT 0,6	6	6	3
59	SELECT `ScCompetition`.`id`, `ScCompetition`.`name` FROM `abcnatation-fr`.`sc_competitions` AS `ScCompetition` WHERE `ScCompetition`.`id` IS NULL	0	0	0
60	SELECT `ClubevenementsClub`.`id`, `ClubevenementsClub`.`libelle` FROM `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` WHERE `ClubevenementsClub`.`id` IS NULL	0	0	0
61	SELECT `ClubActu`.`id`, `ClubActu`.`club_id`, `ClubActu`.`profil_id`, `ClubActu`.`content_id`, `ClubActu`.`epingler`, `ClubActu`.`cache_accueil`, `ClubActu`.`image`, `ClubActu`.`content_type_id`, `ClubActu`.`clubactivites_club_id`, `ClubActu`.`club_group_id`, `ClubActu`.`clubevenements_club_id`, `ClubActu`.`clubcommissions_club_id`, `ClubActu`.`club_edition_id`, `ClubActu`.`email`, `ClubActu`.`sc_competition_id`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `ClubEdition`.`id`, `ClubEdition`.`nom`, `ClubEdition`.`etat_id`, `ClubEdition`.`saison_id`, `ClubEdition`.`club_id`, `ClubEdition`.`clubevenements_club_id`, `ClubEdition`.`startdate`, `ClubEdition`.`stopdate`, `ClubEdition`.`presentation`, `ClubEdition`.`url_affiche`, `ClubEdition`.`coordonnee_id`, `ClubEdition`.`rght`, `ClubEdition`.`lft`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre`, `ClubGroup`.`id`, `ClubGroup`.`nom`, `ClubGroup`.`ordre`, `ClubGroup`.`saison_id`, `ClubGroup`.`club_id`, `ClubGroup`.`clubactivites_club_id`, `ClubGroup`.`club_niveau_pratique_id`, `ClubGroup`.`inscription_niveau_seance`, `ClubGroup`.`inscription_niveau_lot_seance`, `ClubGroup`.`seances_lots`, `ClubGroup`.`nb_seances_min`, `ClubGroup`.`nb_seances_max`, `ClubGroup`.`type_categorie`, `ClubGroup`.`age_min`, `ClubGroup`.`age_max`, `ClubGroup`.`annee_min`, `ClubGroup`.`annee_max`, `ClubGroup`.`categories`, `ClubGroup`.`nbr_place`, `ClubGroup`.`presentation`, `ClubGroup`.`presentation_courte`, `ClubGroup`.`criteres_acces`, `ClubGroup`.`obj_sportif`, `ClubGroup`.`parent_id`, `ClubGroup`.`rght`, `ClubGroup`.`lft`, `ClubGroup`.`affiche_membres`, `ClubGroup`.`affiche_membres_affectes`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`club_actus` AS `ClubActu` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubActu`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubActu`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` ON (`ClubActu`.`clubevenements_club_id` = `ClubevenementsClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_editions` AS `ClubEdition` ON (`ClubActu`.`club_edition_id` = `ClubEdition`.`id`) LEFT JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubActu`.`clubactivites_club_id` = `ClubactivitesClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_groups` AS `ClubGroup` ON (`ClubActu`.`club_group_id` = `ClubGroup`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubActu`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`ClubActu`.`profil_id` = `Profil`.`id`) WHERE `ClubActu`.`club_id` = '170690532' AND `ClubActu`.`epingler` = 1 AND `Content`.`etat_id` = '1' LIMIT 1	0	0	1
62	SELECT `ClubActu`.`id`, `ClubActu`.`club_id`, `ClubActu`.`profil_id`, `ClubActu`.`content_id`, `ClubActu`.`epingler`, `ClubActu`.`cache_accueil`, `ClubActu`.`image`, `ClubActu`.`content_type_id`, `ClubActu`.`clubactivites_club_id`, `ClubActu`.`club_group_id`, `ClubActu`.`clubevenements_club_id`, `ClubActu`.`clubcommissions_club_id`, `ClubActu`.`club_edition_id`, `ClubActu`.`email`, `ClubActu`.`sc_competition_id`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `ClubEdition`.`id`, `ClubEdition`.`nom`, `ClubEdition`.`etat_id`, `ClubEdition`.`saison_id`, `ClubEdition`.`club_id`, `ClubEdition`.`clubevenements_club_id`, `ClubEdition`.`startdate`, `ClubEdition`.`stopdate`, `ClubEdition`.`presentation`, `ClubEdition`.`url_affiche`, `ClubEdition`.`coordonnee_id`, `ClubEdition`.`rght`, `ClubEdition`.`lft`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre`, `ClubGroup`.`id`, `ClubGroup`.`nom`, `ClubGroup`.`ordre`, `ClubGroup`.`saison_id`, `ClubGroup`.`club_id`, `ClubGroup`.`clubactivites_club_id`, `ClubGroup`.`club_niveau_pratique_id`, `ClubGroup`.`inscription_niveau_seance`, `ClubGroup`.`inscription_niveau_lot_seance`, `ClubGroup`.`seances_lots`, `ClubGroup`.`nb_seances_min`, `ClubGroup`.`nb_seances_max`, `ClubGroup`.`type_categorie`, `ClubGroup`.`age_min`, `ClubGroup`.`age_max`, `ClubGroup`.`annee_min`, `ClubGroup`.`annee_max`, `ClubGroup`.`categories`, `ClubGroup`.`nbr_place`, `ClubGroup`.`presentation`, `ClubGroup`.`presentation_courte`, `ClubGroup`.`criteres_acces`, `ClubGroup`.`obj_sportif`, `ClubGroup`.`parent_id`, `ClubGroup`.`rght`, `ClubGroup`.`lft`, `ClubGroup`.`affiche_membres`, `ClubGroup`.`affiche_membres_affectes`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`club_actus` AS `ClubActu` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubActu`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubActu`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` ON (`ClubActu`.`clubevenements_club_id` = `ClubevenementsClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_editions` AS `ClubEdition` ON (`ClubActu`.`club_edition_id` = `ClubEdition`.`id`) LEFT JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubActu`.`clubactivites_club_id` = `ClubactivitesClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_groups` AS `ClubGroup` ON (`ClubActu`.`club_group_id` = `ClubGroup`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubActu`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`ClubActu`.`profil_id` = `Profil`.`id`) WHERE `ClubActu`.`club_id` = '170690532' AND `ClubActu`.`epingler` = 2 AND `Content`.`etat_id` = '1' LIMIT 1	0	0	1
63	SELECT `ScCompetitionClub`.`id`, `ScCompetitionClub`.`sc_competition_id`, `ScCompetitionClub`.`club_id`, `ScCompetition`.`id`, `ScCompetition`.`type`, `ScCompetition`.`ffnex_id`, `ScCompetition`.`profil_id`, `ScCompetition`.`origine`, `ScCompetition`.`name`, `ScCompetition`.`city`, `ScCompetition`.`departement_id`, `ScCompetition`.`region_id`, `ScCompetition`.`startdate`, `ScCompetition`.`stopdate`, `ScCompetition`.`date_limit_engagement_debut`, `ScCompetition`.`date_limit_engagement_fin`, `ScCompetition`.`date_pub_start_list`, `ScCompetition`.`saison`, `ScCompetition`.`nation`, `ScCompetition`.`age_min`, `ScCompetition`.`age_max`, `ScCompetition`.`scf_competition_type_id`, `ScCompetition`.`scf_discipline_id`, `ScCompetition`.`scf_competition_label_id`, `ScCompetition`.`scf_chronometrage_type_id`, `ScCompetition`.`scf_competition_niveau_id`, `ScCompetition`.`piscine_id`, `ScCompetition`.`pool_name`, `ScCompetition`.`pool_lane`, `ScCompetition`.`pool_size`, `ScCompetition`.`byteam`, `ScCompetition`.`description`, `ScCompetition`.`lien_unique`, `ScCompetition`.`vide`, `ScCompetition`.`xml_vide`, `ScCompetition`.`xml_resultats_vide`, `ScCompetition`.`xml_faux`, `ScCompetition`.`existe_plus`, `ScCompetition`.`erreur_integration`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`sc_competition_clubs` AS `ScCompetitionClub` LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScCompetitionClub`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScCompetitionClub`.`club_id` = `Club`.`id`) WHERE `ScCompetitionClub`.`club_id` = '170690532' AND `ScCompetition`.`startdate` <= '2019-12-06' AND `ScCompetition`.`id` NOT LIKE '%SC-%' ORDER BY `ScCompetition`.`startdate` DESC LIMIT 0,6	6	6	14
64	SELECT `ScCompetitionClub`.`id`, `ScCompetitionClub`.`sc_competition_id`, `ScCompetitionClub`.`club_id`, `ScCompetition`.`id`, `ScCompetition`.`type`, `ScCompetition`.`ffnex_id`, `ScCompetition`.`profil_id`, `ScCompetition`.`origine`, `ScCompetition`.`name`, `ScCompetition`.`city`, `ScCompetition`.`departement_id`, `ScCompetition`.`region_id`, `ScCompetition`.`startdate`, `ScCompetition`.`stopdate`, `ScCompetition`.`date_limit_engagement_debut`, `ScCompetition`.`date_limit_engagement_fin`, `ScCompetition`.`date_pub_start_list`, `ScCompetition`.`saison`, `ScCompetition`.`nation`, `ScCompetition`.`age_min`, `ScCompetition`.`age_max`, `ScCompetition`.`scf_competition_type_id`, `ScCompetition`.`scf_discipline_id`, `ScCompetition`.`scf_competition_label_id`, `ScCompetition`.`scf_chronometrage_type_id`, `ScCompetition`.`scf_competition_niveau_id`, `ScCompetition`.`piscine_id`, `ScCompetition`.`pool_name`, `ScCompetition`.`pool_lane`, `ScCompetition`.`pool_size`, `ScCompetition`.`byteam`, `ScCompetition`.`description`, `ScCompetition`.`lien_unique`, `ScCompetition`.`vide`, `ScCompetition`.`xml_vide`, `ScCompetition`.`xml_resultats_vide`, `ScCompetition`.`xml_faux`, `ScCompetition`.`existe_plus`, `ScCompetition`.`erreur_integration`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`sc_competition_clubs` AS `ScCompetitionClub` LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScCompetitionClub`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScCompetitionClub`.`club_id` = `Club`.`id`) WHERE `ScCompetitionClub`.`club_id` = '170690532' AND `ScCompetition`.`startdate` > '2019-12-06' ORDER BY `ScCompetition`.`startdate` asc LIMIT 0,6	0	0	6
65	SELECT `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Vignette`.`id`, `Vignette`.`content_type_id`, `Vignette`.`media_type_id`, `Vignette`.`content_id`, `Vignette`.`local`, `Vignette`.`extention`, `Vignette`.`poids`, `Vignette`.`nom_fichier`, `Vignette`.`nom`, `Vignette`.`dossier`, `Vignette`.`code_embed`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Group`.`id`, `Group`.`parent_id`, `Group`.`name`, `Group`.`created`, `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id`, `MentionsLegale`.`id`, `MentionsLegale`.`content_type_id`, `MentionsLegale`.`content_id`, `MentionsLegale`.`adresse_site_web`, `MentionsLegale`.`raison_sociale`, `MentionsLegale`.`forme_juridique`, `MentionsLegale`.`num_siren`, `MentionsLegale`.`code_naf`, `MentionsLegale`.`adresse_siege`, `MentionsLegale`.`responsable_publication`, `MentionsLegale`.`num_cnil`, `MentionsLegale`.`webmaster`, `MentionsLegale`.`createur`, `MentionsLegale`.`hebergeur`, `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id`, `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id`, `MediaManagerMedia`.`id`, `MediaManagerMedia`.`content_type_id`, `MediaManagerMedia`.`media_type_id`, `MediaManagerMedia`.`content_id`, `MediaManagerMedia`.`local`, `MediaManagerMedia`.`extention`, `MediaManagerMedia`.`poids`, `MediaManagerMedia`.`nom_fichier`, `MediaManagerMedia`.`nom`, `MediaManagerMedia`.`dossier`, `MediaManagerMedia`.`code_embed`, `ClubPage`.`id`, `ClubPage`.`content_id`, `ClubPage`.`content_type_id`, `ClubPage`.`club_id`, `ClubPage`.`module`, `ClubPage`.`menu`, `ClubPage`.`activite_id`, `ClubPage`.`commission_id`, `ClubPage`.`edition_id`, `ClubActu`.`id`, `ClubActu`.`club_id`, `ClubActu`.`profil_id`, `ClubActu`.`content_id`, `ClubActu`.`epingler`, `ClubActu`.`cache_accueil`, `ClubActu`.`image`, `ClubActu`.`content_type_id`, `ClubActu`.`clubactivites_club_id`, `ClubActu`.`club_group_id`, `ClubActu`.`clubevenements_club_id`, `ClubActu`.`clubcommissions_club_id`, `ClubActu`.`club_edition_id`, `ClubActu`.`email`, `ClubActu`.`sc_competition_id` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_actus` AS `ClubActu` ON (`ClubActu`.`content_id` = `Content`.`id`) WHERE ((`ClubActu`.`club_id` = '170690532') OR (`ClubPage`.`club_id` = '170690532')) AND `Content`.`etat_id` = '1' AND `Content`.`content_type_id` = 7 ORDER BY `Content`.`created` DESC LIMIT 0,6	6	6	306
66	SELECT `ClubAlbumFile`.`id`, `ClubAlbumFile`.`club_album_id`, `ClubAlbumFile`.`name`, `ClubAlbumFile`.`extention_id`, `ClubAlbumFile`.`type`, `ClubAlbumFile`.`slug`, `ClubAlbumFile`.`nom_fichier`, `ClubAlbumFile`.`poids`, `ClubAlbumFile`.`dossier`, `ClubAlbumFile`.`url`, `ClubAlbumFile`.`created`, `ClubAlbumFile`.`updated`, `ClubAlbum`.`id`, `ClubAlbum`.`name`, `ClubAlbum`.`description`, `ClubAlbum`.`lien_externe`, `ClubAlbum`.`club_id`, `ClubAlbum`.`cache_accueil`, `ClubAlbum`.`profil_id`, `ClubAlbum`.`date`, `ClubAlbum`.`created`, `ClubAlbum`.`updated` FROM `abcnatation-fr`.`club_album_files` AS `ClubAlbumFile` LEFT JOIN `abcnatation-fr`.`club_albums` AS `ClubAlbum` ON (`ClubAlbumFile`.`club_album_id` = `ClubAlbum`.`id`) WHERE `ClubAlbum`.`club_id` = '170690532' AND `ClubAlbum`.`cache_accueil` = '0' ORDER BY rand() ASC LIMIT 10	10	10	305
67	SELECT `ClubPartenaire`.`id`, `ClubPartenaire`.`club_id`, `ClubPartenaire`.`profil_id`, `ClubPartenaire`.`content_id`, `ClubPartenaire`.`content_type_id`, `ClubPartenaire`.`site_web`, `ClubPartenaire`.`logo`, `ClubPartenaire`.`categorie`, `ClubPartenaire`.`ordre`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`club_partenaires` AS `ClubPartenaire` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubPartenaire`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubPartenaire`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubPartenaire`.`content_type_id` = `ContentType`.`id`) WHERE `ClubPartenaire`.`club_id` = '170690532' AND `Content`.`etat_id` = '1' ORDER BY `ClubPartenaire`.`ordre` ASC	11	11	0
68	SELECT `ClubPartenaire`.`id`, `ClubPartenaire`.`club_id`, `ClubPartenaire`.`profil_id`, `ClubPartenaire`.`content_id`, `ClubPartenaire`.`content_type_id`, `ClubPartenaire`.`site_web`, `ClubPartenaire`.`logo`, `ClubPartenaire`.`categorie`, `ClubPartenaire`.`ordre`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`club_partenaires` AS `ClubPartenaire` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubPartenaire`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubPartenaire`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubPartenaire`.`content_type_id` = `ContentType`.`id`) WHERE `ClubPartenaire`.`club_id` = '170690532' AND `Content`.`etat_id` = '1' AND `ClubPartenaire`.`categorie` = 1 ORDER BY `ClubPartenaire`.`ordre` ASC	1	1	1
69	SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`menu_id` = '1' AND `Content`.`etat_id` = '1' AND `Content`.`content_type_id` IN (1, 2, 3, 4) ORDER BY `lft` ASC	368	368	1
70	SELECT `Content`.`lft`, `Content`.`rght` FROM `abcnatation-fr`.`contents` AS `Content` WHERE `Content`.`id` = '' LIMIT 1	0	0	0
71	SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`content_type_id` IN (1, 2, 3, 4) AND `Content`.`menu_id` = '1' AND `Content`.`etat_id` = '1' AND `Content`.`parent_id` IS NULL ORDER BY `Content`.`lft` ASC	350	350	1
72	SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`content_types` AS `ContentType` WHERE 1 = 1	10	10	0
73	SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`sous_domaine` = 'lyonnatationmetropole.com' LIMIT 1	1	1	0
74	SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')	6	6	0
75	SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '170690532' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`)	14	14	0
76	SELECT `Clubs`.`id`, `Clubs`.`statut`, `Clubs`.`abonne_depuis`, `Clubs`.`name`, `Clubs`.`name_officiel`, `Clubs`.`offre_v2`, `Clubs`.`siret`, `Clubs`.`cnil`, `Clubs`.`agrement`, `Clubs`.`code_parrain`, `Clubs`.`nation`, `Clubs`.`correspondant_licencie_id`, `Clubs`.`scf_structure_type_id`, `Clubs`.`scf_structure_statut_id`, `Clubs`.`sport_id`, `Clubs`.`profil_id`, `Clubs`.`coordonnee_id`, `Clubs`.`departement_id`, `Clubs`.`region_id`, `Clubs`.`correspondant`, `Clubs`.`content_id`, `Clubs`.`content_type_id`, `Clubs`.`maj_ffn`, `Clubs`.`maj_csv`, `Clubs`.`logo_upload`, `Clubs`.`signature_upload`, `Clubs`.`site_web`, `Clubs`.`sous_domaine`, `Clubs`.`assurance`, `Clubs`.`label`, `Clubs`.`email`, `Clubs`.`email_webmaster`, `Clubs`.`email_expediteur`, `Clubs`.`option_membre_illimite`, `Clubs`.`option_scoring_pro`, `Clubs`.`option_inscriptions`, `Clubs`.`option_convocations`, `Clubs`.`option_domaine`, `Clubs`.`date_fin_membre_illimite`, `Clubs`.`date_fin_scoring_pro`, `Clubs`.`date_fin_inscriptions`, `Clubs`.`date_fin_convocations`, `Clubs`.`date_fin_option_domaine`, `Clubs`.`date_fin_site_web`, `Clubs`.`forcer_recevoir_news`, `Clubs`.`IdCISS`, `Clubs`.`PassCISS`, `Clubs`.`idWallet`, `Clubs`.`url_swimcommunity`, `Clubs`.`activer_sc`, `Clubs`.`activer_pagesc`, `Clubs`.`txtbtn_swimcommunity`, `Clubs`.`h1_sc`, `Clubs`.`page1_swimcommunity`, `Clubs`.`page2_swimcommunity` FROM `abcnatation-fr`.`clubs` AS `Clubs` WHERE `Clubs`.`id` IS NULL LIMIT 1	0	0	0
77	SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC	9	9	0
78	SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '170690532' AND `Content`.`content_type_id` = 7 ORDER BY `Content`.`position` ASC	6	6	0
79	SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`id` = '170690532' LIMIT 1	1	1	0
80	SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')	6	6	0
81	SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '170690532' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`)	14	14	0
82	SELECT `Droits`.`libelle`, `Droits`.`masque` FROM `abcnatation-fr`.`droits` AS `Droits` WHERE 1 = 1	22	22	0
83	SELECT `ClubPartenaire`.`id`, `ClubPartenaire`.`club_id`, `ClubPartenaire`.`profil_id`, `ClubPartenaire`.`content_id`, `ClubPartenaire`.`content_type_id`, `ClubPartenaire`.`site_web`, `ClubPartenaire`.`logo`, `ClubPartenaire`.`categorie`, `ClubPartenaire`.`ordre`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`club_partenaires` AS `ClubPartenaire` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubPartenaire`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubPartenaire`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubPartenaire`.`content_type_id` = `ContentType`.`id`) WHERE `ClubPartenaire`.`club_id` = '170690532' AND `Content`.`etat_id` = '1' ORDER BY `ClubPartenaire`.`ordre` ASC	11	11	0

(default) 83 queries took 641 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`sous_domaine` = 'lyonnatationmetropole.com' LIMIT 1

SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')

SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '170690532' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`)

SELECT `Clubs`.`id`, `Clubs`.`statut`, `Clubs`.`abonne_depuis`, `Clubs`.`name`, `Clubs`.`name_officiel`, `Clubs`.`offre_v2`, `Clubs`.`siret`, `Clubs`.`cnil`, `Clubs`.`agrement`, `Clubs`.`code_parrain`, `Clubs`.`nation`, `Clubs`.`correspondant_licencie_id`, `Clubs`.`scf_structure_type_id`, `Clubs`.`scf_structure_statut_id`, `Clubs`.`sport_id`, `Clubs`.`profil_id`, `Clubs`.`coordonnee_id`, `Clubs`.`departement_id`, `Clubs`.`region_id`, `Clubs`.`correspondant`, `Clubs`.`content_id`, `Clubs`.`content_type_id`, `Clubs`.`maj_ffn`, `Clubs`.`maj_csv`, `Clubs`.`logo_upload`, `Clubs`.`signature_upload`, `Clubs`.`site_web`, `Clubs`.`sous_domaine`, `Clubs`.`assurance`, `Clubs`.`label`, `Clubs`.`email`, `Clubs`.`email_webmaster`, `Clubs`.`email_expediteur`, `Clubs`.`option_membre_illimite`, `Clubs`.`option_scoring_pro`, `Clubs`.`option_inscriptions`, `Clubs`.`option_convocations`, `Clubs`.`option_domaine`, `Clubs`.`date_fin_membre_illimite`, `Clubs`.`date_fin_scoring_pro`, `Clubs`.`date_fin_inscriptions`, `Clubs`.`date_fin_convocations`, `Clubs`.`date_fin_option_domaine`, `Clubs`.`date_fin_site_web`, `Clubs`.`forcer_recevoir_news`, `Clubs`.`IdCISS`, `Clubs`.`PassCISS`, `Clubs`.`idWallet`, `Clubs`.`url_swimcommunity`, `Clubs`.`activer_sc`, `Clubs`.`activer_pagesc`, `Clubs`.`txtbtn_swimcommunity`, `Clubs`.`h1_sc`, `Clubs`.`page1_swimcommunity`, `Clubs`.`page2_swimcommunity` FROM `abcnatation-fr`.`clubs` AS `Clubs` WHERE `Clubs`.`id` IS NULL LIMIT 1

SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC

SELECT `SiteWeb`.`id`, `SiteWeb`.`club_id`, `SiteWeb`.`statut`, `SiteWeb`.`url_bandeau`, `SiteWeb`.`msg_bandeau`, `SiteWeb`.`saison_id`, `SiteWeb`.`degroupe_menu_activite`, `SiteWeb`.`degroupe_menu_evenements`, `SiteWeb`.`degroupe_menu_commissions`, `SiteWeb`.`actualites`, `SiteWeb`.`cache_auteur_actu`, `SiteWeb`.`cache_pictos_menu`, `SiteWeb`.`cache_accueil`, `SiteWeb`.`cache_email`, `SiteWeb`.`publication`, `SiteWeb`.`cache_email_web`, `SiteWeb`.`nom_medias`, `SiteWeb`.`widget_part`, `SiteWeb`.`widget_part_top_position`, `SiteWeb`.`widget_photos`, `SiteWeb`.`widget_res`, `SiteWeb`.`widget_pages`, `SiteWeb`.`widget_cal`, `SiteWeb`.`widget_act`, `SiteWeb`.`gestion_droits`, `SiteWeb`.`boutique`, `SiteWeb`.`forcer_recevoir_news`, `SiteWeb`.`flickr_user_id`, `SiteWeb`.`template`, `SiteWeb`.`recaptcha`, `SiteWeb`.`meta_description` FROM `abcnatation-fr`.`site_webs` AS `SiteWeb` WHERE `SiteWeb`.`club_id` IS NULL LIMIT 1

SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE `date_debut` <= '2019-12-06' AND `date_fin` > '2019-12-06' LIMIT 1

SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE ((`Club`.`sous_domaine` = '170690532') OR (`Club`.`id` = '170690532')) LIMIT 1

SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')

SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`club_inscription_parametres` AS `ClubInscriptionParametre` WHERE `ClubInscriptionParametre`.`club_id` = '170690532' AND `ClubInscriptionParametre`.`activer` = '1'

SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE `date_debut` <= '2019-12-06' AND `date_fin` > '2019-12-06' LIMIT 1

SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '170690532' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = '' ORDER BY `Content`.`position` ASC

SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '170690532' AND ((`Content`.`content_type_id` = 7) OR (`Content`.`content_type_id` = 10)) AND `ClubPage`.`menu` = 'home' ORDER BY `Content`.`position` ASC

SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 7

SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 39073

SELECT `MentionsLegale`.`id`, `MentionsLegale`.`content_type_id`, `MentionsLegale`.`content_id`, `MentionsLegale`.`adresse_site_web`, `MentionsLegale`.`raison_sociale`, `MentionsLegale`.`forme_juridique`, `MentionsLegale`.`num_siren`, `MentionsLegale`.`code_naf`, `MentionsLegale`.`adresse_siege`, `MentionsLegale`.`responsable_publication`, `MentionsLegale`.`num_cnil`, `MentionsLegale`.`webmaster`, `MentionsLegale`.`createur`, `MentionsLegale`.`hebergeur` FROM `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` WHERE `MentionsLegale`.`content_id` = 39073

SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 39073

SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 39073

SELECT `MediaManagerMedia`.`id`, `MediaManagerMedia`.`content_type_id`, `MediaManagerMedia`.`media_type_id`, `MediaManagerMedia`.`content_id`, `MediaManagerMedia`.`local`, `MediaManagerMedia`.`extention`, `MediaManagerMedia`.`poids`, `MediaManagerMedia`.`nom_fichier`, `MediaManagerMedia`.`nom`, `MediaManagerMedia`.`dossier`, `MediaManagerMedia`.`code_embed` FROM `abcnatation-fr`.`media` AS `MediaManagerMedia` WHERE `MediaManagerMedia`.`content_id` = 39073

SELECT `ClubPage`.`id`, `ClubPage`.`content_id`, `ClubPage`.`content_type_id`, `ClubPage`.`club_id`, `ClubPage`.`module`, `ClubPage`.`menu`, `ClubPage`.`activite_id`, `ClubPage`.`commission_id`, `ClubPage`.`edition_id` FROM `abcnatation-fr`.`club_pages` AS `ClubPage` WHERE `ClubPage`.`content_id` = 39073

SELECT `ClubActu`.`id`, `ClubActu`.`club_id`, `ClubActu`.`profil_id`, `ClubActu`.`content_id`, `ClubActu`.`epingler`, `ClubActu`.`cache_accueil`, `ClubActu`.`image`, `ClubActu`.`content_type_id`, `ClubActu`.`clubactivites_club_id`, `ClubActu`.`club_group_id`, `ClubActu`.`clubevenements_club_id`, `ClubActu`.`clubcommissions_club_id`, `ClubActu`.`club_edition_id`, `ClubActu`.`email`, `ClubActu`.`sc_competition_id`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `ClubEdition`.`id`, `ClubEdition`.`nom`, `ClubEdition`.`etat_id`, `ClubEdition`.`saison_id`, `ClubEdition`.`club_id`, `ClubEdition`.`clubevenements_club_id`, `ClubEdition`.`startdate`, `ClubEdition`.`stopdate`, `ClubEdition`.`presentation`, `ClubEdition`.`url_affiche`, `ClubEdition`.`coordonnee_id`, `ClubEdition`.`rght`, `ClubEdition`.`lft`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre`, `ClubGroup`.`id`, `ClubGroup`.`nom`, `ClubGroup`.`ordre`, `ClubGroup`.`saison_id`, `ClubGroup`.`club_id`, `ClubGroup`.`clubactivites_club_id`, `ClubGroup`.`club_niveau_pratique_id`, `ClubGroup`.`inscription_niveau_seance`, `ClubGroup`.`inscription_niveau_lot_seance`, `ClubGroup`.`seances_lots`, `ClubGroup`.`nb_seances_min`, `ClubGroup`.`nb_seances_max`, `ClubGroup`.`type_categorie`, `ClubGroup`.`age_min`, `ClubGroup`.`age_max`, `ClubGroup`.`annee_min`, `ClubGroup`.`annee_max`, `ClubGroup`.`categories`, `ClubGroup`.`nbr_place`, `ClubGroup`.`presentation`, `ClubGroup`.`presentation_courte`, `ClubGroup`.`criteres_acces`, `ClubGroup`.`obj_sportif`, `ClubGroup`.`parent_id`, `ClubGroup`.`rght`, `ClubGroup`.`lft`, `ClubGroup`.`affiche_membres`, `ClubGroup`.`affiche_membres_affectes`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`club_actus` AS `ClubActu` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubActu`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubActu`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` ON (`ClubActu`.`clubevenements_club_id` = `ClubevenementsClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_editions` AS `ClubEdition` ON (`ClubActu`.`club_edition_id` = `ClubEdition`.`id`) LEFT JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubActu`.`clubactivites_club_id` = `ClubactivitesClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_groups` AS `ClubGroup` ON (`ClubActu`.`club_group_id` = `ClubGroup`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubActu`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`ClubActu`.`profil_id` = `Profil`.`id`) WHERE `ClubActu`.`club_id` = '170690532' AND ((NOT (`Content`.`etat_id` = '0')) OR (`Content`.`etat_id` = '1'))

SELECT `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` WHERE `ClubactivitesClub`.`club_id` = '170690532' AND `ClubactivitesClub`.`saison_id` = '2019-2020' ORDER BY `ClubactivitesClub`.`ordre` ASC

SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE `date_debut` <= '2019-12-06' AND `date_fin` > '2019-12-06' LIMIT 1

SELECT `ClubcommissionsClub`.`id`, `ClubcommissionsClub`.`clubcommission_id`, `ClubcommissionsClub`.`club_id`, `ClubcommissionsClub`.`libelle`, `ClubcommissionsClub`.`saison_id`, `ClubcommissionsClub`.`presentation`, `ClubcommissionsClub`.`ordre`, `Clubcommission`.`id`, `Clubcommission`.`description`, `Clubcommission`.`type`, `Clubcommission`.`activite_id`, `Clubcommission`.`ordre` FROM `abcnatation-fr`.`clubcommissions_clubs` AS `ClubcommissionsClub` LEFT JOIN `abcnatation-fr`.`clubcommissions` AS `Clubcommission` ON (`ClubcommissionsClub`.`clubcommission_id` = `Clubcommission`.`id`) WHERE `ClubcommissionsClub`.`club_id` = '170690532' AND `ClubcommissionsClub`.`saison_id` = '2019-2020' ORDER BY `ClubcommissionsClub`.`ordre` ASC

SELECT `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `Clubevenement`.`id`, `Clubevenement`.`description` FROM `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` LEFT JOIN `abcnatation-fr`.`clubevenements` AS `Clubevenement` ON (`ClubevenementsClub`.`clubevenement_id` = `Clubevenement`.`id`) WHERE `ClubevenementsClub`.`club_id` = '170690532' AND `ClubevenementsClub`.`etat_id` = '1'

SELECT `ClubAlbum`.`id`, `ClubAlbum`.`name`, `ClubAlbum`.`description`, `ClubAlbum`.`lien_externe`, `ClubAlbum`.`club_id`, `ClubAlbum`.`cache_accueil`, `ClubAlbum`.`profil_id`, `ClubAlbum`.`date`, `ClubAlbum`.`created`, `ClubAlbum`.`updated` FROM `abcnatation-fr`.`club_albums` AS `ClubAlbum` WHERE `ClubAlbum`.`club_id` = '170690532'

SELECT `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Vignette`.`id`, `Vignette`.`content_type_id`, `Vignette`.`media_type_id`, `Vignette`.`content_id`, `Vignette`.`local`, `Vignette`.`extention`, `Vignette`.`poids`, `Vignette`.`nom_fichier`, `Vignette`.`nom`, `Vignette`.`dossier`, `Vignette`.`code_embed`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Group`.`id`, `Group`.`parent_id`, `Group`.`name`, `Group`.`created`, `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id`, `MentionsLegale`.`id`, `MentionsLegale`.`content_type_id`, `MentionsLegale`.`content_id`, `MentionsLegale`.`adresse_site_web`, `MentionsLegale`.`raison_sociale`, `MentionsLegale`.`forme_juridique`, `MentionsLegale`.`num_siren`, `MentionsLegale`.`code_naf`, `MentionsLegale`.`adresse_siege`, `MentionsLegale`.`responsable_publication`, `MentionsLegale`.`num_cnil`, `MentionsLegale`.`webmaster`, `MentionsLegale`.`createur`, `MentionsLegale`.`hebergeur`, `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id`, `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id`, `MediaManagerMedia`.`id`, `MediaManagerMedia`.`content_type_id`, `MediaManagerMedia`.`media_type_id`, `MediaManagerMedia`.`content_id`, `MediaManagerMedia`.`local`, `MediaManagerMedia`.`extention`, `MediaManagerMedia`.`poids`, `MediaManagerMedia`.`nom_fichier`, `MediaManagerMedia`.`nom`, `MediaManagerMedia`.`dossier`, `MediaManagerMedia`.`code_embed`, `ClubPage`.`id`, `ClubPage`.`content_id`, `ClubPage`.`content_type_id`, `ClubPage`.`club_id`, `ClubPage`.`module`, `ClubPage`.`menu`, `ClubPage`.`activite_id`, `ClubPage`.`commission_id`, `ClubPage`.`edition_id` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `ClubPage`.`menu` = 'medias' AND `ClubPage`.`club_id` = '170690532' AND `Content`.`content_type_id` = 7 AND `Content`.`etat_id` = '1'

SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')

SELECT `ClubNum`.`id`, `ClubNum`.`club_id_10`, `ClubNum`.`club_id`, `ClubNum`.`name_officiel`, `ClubNum`.`name_usuel`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`club_nums` AS `ClubNum` LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubNum`.`club_id` = `Club`.`id`) WHERE `ClubNum`.`club_id` = '170690532' LIMIT 1

SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')

SELECT `ClubActu`.`id`, `ClubActu`.`club_id`, `ClubActu`.`profil_id`, `ClubActu`.`content_id`, `ClubActu`.`epingler`, `ClubActu`.`cache_accueil`, `ClubActu`.`image`, `ClubActu`.`content_type_id`, `ClubActu`.`clubactivites_club_id`, `ClubActu`.`club_group_id`, `ClubActu`.`clubevenements_club_id`, `ClubActu`.`clubcommissions_club_id`, `ClubActu`.`club_edition_id`, `ClubActu`.`email`, `ClubActu`.`sc_competition_id`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `ClubEdition`.`id`, `ClubEdition`.`nom`, `ClubEdition`.`etat_id`, `ClubEdition`.`saison_id`, `ClubEdition`.`club_id`, `ClubEdition`.`clubevenements_club_id`, `ClubEdition`.`startdate`, `ClubEdition`.`stopdate`, `ClubEdition`.`presentation`, `ClubEdition`.`url_affiche`, `ClubEdition`.`coordonnee_id`, `ClubEdition`.`rght`, `ClubEdition`.`lft`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre`, `ClubGroup`.`id`, `ClubGroup`.`nom`, `ClubGroup`.`ordre`, `ClubGroup`.`saison_id`, `ClubGroup`.`club_id`, `ClubGroup`.`clubactivites_club_id`, `ClubGroup`.`club_niveau_pratique_id`, `ClubGroup`.`inscription_niveau_seance`, `ClubGroup`.`inscription_niveau_lot_seance`, `ClubGroup`.`seances_lots`, `ClubGroup`.`nb_seances_min`, `ClubGroup`.`nb_seances_max`, `ClubGroup`.`type_categorie`, `ClubGroup`.`age_min`, `ClubGroup`.`age_max`, `ClubGroup`.`annee_min`, `ClubGroup`.`annee_max`, `ClubGroup`.`categories`, `ClubGroup`.`nbr_place`, `ClubGroup`.`presentation`, `ClubGroup`.`presentation_courte`, `ClubGroup`.`criteres_acces`, `ClubGroup`.`obj_sportif`, `ClubGroup`.`parent_id`, `ClubGroup`.`rght`, `ClubGroup`.`lft`, `ClubGroup`.`affiche_membres`, `ClubGroup`.`affiche_membres_affectes`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`club_actus` AS `ClubActu` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubActu`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubActu`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` ON (`ClubActu`.`clubevenements_club_id` = `ClubevenementsClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_editions` AS `ClubEdition` ON (`ClubActu`.`club_edition_id` = `ClubEdition`.`id`) LEFT JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubActu`.`clubactivites_club_id` = `ClubactivitesClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_groups` AS `ClubGroup` ON (`ClubActu`.`club_group_id` = `ClubGroup`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubActu`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`ClubActu`.`profil_id` = `Profil`.`id`) WHERE `ClubActu`.`club_id` = '170690532' AND `ClubActu`.`epingler` = 0 AND `Content`.`etat_id` = '1' AND `ClubActu`.`cache_accueil` = '0' ORDER BY `Content`.`created` desc LIMIT 0,6

SELECT `ScCompetition`.`id`, `ScCompetition`.`name` FROM `abcnatation-fr`.`sc_competitions` AS `ScCompetition` WHERE `ScCompetition`.`id` IS NULL

SELECT `ClubevenementsClub`.`id`, `ClubevenementsClub`.`libelle` FROM `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` WHERE `ClubevenementsClub`.`id` IS NULL

SELECT `ClubActu`.`id`, `ClubActu`.`club_id`, `ClubActu`.`profil_id`, `ClubActu`.`content_id`, `ClubActu`.`epingler`, `ClubActu`.`cache_accueil`, `ClubActu`.`image`, `ClubActu`.`content_type_id`, `ClubActu`.`clubactivites_club_id`, `ClubActu`.`club_group_id`, `ClubActu`.`clubevenements_club_id`, `ClubActu`.`clubcommissions_club_id`, `ClubActu`.`club_edition_id`, `ClubActu`.`email`, `ClubActu`.`sc_competition_id`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `ClubEdition`.`id`, `ClubEdition`.`nom`, `ClubEdition`.`etat_id`, `ClubEdition`.`saison_id`, `ClubEdition`.`club_id`, `ClubEdition`.`clubevenements_club_id`, `ClubEdition`.`startdate`, `ClubEdition`.`stopdate`, `ClubEdition`.`presentation`, `ClubEdition`.`url_affiche`, `ClubEdition`.`coordonnee_id`, `ClubEdition`.`rght`, `ClubEdition`.`lft`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre`, `ClubGroup`.`id`, `ClubGroup`.`nom`, `ClubGroup`.`ordre`, `ClubGroup`.`saison_id`, `ClubGroup`.`club_id`, `ClubGroup`.`clubactivites_club_id`, `ClubGroup`.`club_niveau_pratique_id`, `ClubGroup`.`inscription_niveau_seance`, `ClubGroup`.`inscription_niveau_lot_seance`, `ClubGroup`.`seances_lots`, `ClubGroup`.`nb_seances_min`, `ClubGroup`.`nb_seances_max`, `ClubGroup`.`type_categorie`, `ClubGroup`.`age_min`, `ClubGroup`.`age_max`, `ClubGroup`.`annee_min`, `ClubGroup`.`annee_max`, `ClubGroup`.`categories`, `ClubGroup`.`nbr_place`, `ClubGroup`.`presentation`, `ClubGroup`.`presentation_courte`, `ClubGroup`.`criteres_acces`, `ClubGroup`.`obj_sportif`, `ClubGroup`.`parent_id`, `ClubGroup`.`rght`, `ClubGroup`.`lft`, `ClubGroup`.`affiche_membres`, `ClubGroup`.`affiche_membres_affectes`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`club_actus` AS `ClubActu` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubActu`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubActu`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` ON (`ClubActu`.`clubevenements_club_id` = `ClubevenementsClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_editions` AS `ClubEdition` ON (`ClubActu`.`club_edition_id` = `ClubEdition`.`id`) LEFT JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubActu`.`clubactivites_club_id` = `ClubactivitesClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_groups` AS `ClubGroup` ON (`ClubActu`.`club_group_id` = `ClubGroup`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubActu`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`ClubActu`.`profil_id` = `Profil`.`id`) WHERE `ClubActu`.`club_id` = '170690532' AND `ClubActu`.`epingler` = 1 AND `Content`.`etat_id` = '1' LIMIT 1

SELECT `ClubActu`.`id`, `ClubActu`.`club_id`, `ClubActu`.`profil_id`, `ClubActu`.`content_id`, `ClubActu`.`epingler`, `ClubActu`.`cache_accueil`, `ClubActu`.`image`, `ClubActu`.`content_type_id`, `ClubActu`.`clubactivites_club_id`, `ClubActu`.`club_group_id`, `ClubActu`.`clubevenements_club_id`, `ClubActu`.`clubcommissions_club_id`, `ClubActu`.`club_edition_id`, `ClubActu`.`email`, `ClubActu`.`sc_competition_id`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `ClubEdition`.`id`, `ClubEdition`.`nom`, `ClubEdition`.`etat_id`, `ClubEdition`.`saison_id`, `ClubEdition`.`club_id`, `ClubEdition`.`clubevenements_club_id`, `ClubEdition`.`startdate`, `ClubEdition`.`stopdate`, `ClubEdition`.`presentation`, `ClubEdition`.`url_affiche`, `ClubEdition`.`coordonnee_id`, `ClubEdition`.`rght`, `ClubEdition`.`lft`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre`, `ClubGroup`.`id`, `ClubGroup`.`nom`, `ClubGroup`.`ordre`, `ClubGroup`.`saison_id`, `ClubGroup`.`club_id`, `ClubGroup`.`clubactivites_club_id`, `ClubGroup`.`club_niveau_pratique_id`, `ClubGroup`.`inscription_niveau_seance`, `ClubGroup`.`inscription_niveau_lot_seance`, `ClubGroup`.`seances_lots`, `ClubGroup`.`nb_seances_min`, `ClubGroup`.`nb_seances_max`, `ClubGroup`.`type_categorie`, `ClubGroup`.`age_min`, `ClubGroup`.`age_max`, `ClubGroup`.`annee_min`, `ClubGroup`.`annee_max`, `ClubGroup`.`categories`, `ClubGroup`.`nbr_place`, `ClubGroup`.`presentation`, `ClubGroup`.`presentation_courte`, `ClubGroup`.`criteres_acces`, `ClubGroup`.`obj_sportif`, `ClubGroup`.`parent_id`, `ClubGroup`.`rght`, `ClubGroup`.`lft`, `ClubGroup`.`affiche_membres`, `ClubGroup`.`affiche_membres_affectes`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`club_actus` AS `ClubActu` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubActu`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubActu`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` ON (`ClubActu`.`clubevenements_club_id` = `ClubevenementsClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_editions` AS `ClubEdition` ON (`ClubActu`.`club_edition_id` = `ClubEdition`.`id`) LEFT JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubActu`.`clubactivites_club_id` = `ClubactivitesClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_groups` AS `ClubGroup` ON (`ClubActu`.`club_group_id` = `ClubGroup`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubActu`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`ClubActu`.`profil_id` = `Profil`.`id`) WHERE `ClubActu`.`club_id` = '170690532' AND `ClubActu`.`epingler` = 2 AND `Content`.`etat_id` = '1' LIMIT 1

SELECT `ScCompetitionClub`.`id`, `ScCompetitionClub`.`sc_competition_id`, `ScCompetitionClub`.`club_id`, `ScCompetition`.`id`, `ScCompetition`.`type`, `ScCompetition`.`ffnex_id`, `ScCompetition`.`profil_id`, `ScCompetition`.`origine`, `ScCompetition`.`name`, `ScCompetition`.`city`, `ScCompetition`.`departement_id`, `ScCompetition`.`region_id`, `ScCompetition`.`startdate`, `ScCompetition`.`stopdate`, `ScCompetition`.`date_limit_engagement_debut`, `ScCompetition`.`date_limit_engagement_fin`, `ScCompetition`.`date_pub_start_list`, `ScCompetition`.`saison`, `ScCompetition`.`nation`, `ScCompetition`.`age_min`, `ScCompetition`.`age_max`, `ScCompetition`.`scf_competition_type_id`, `ScCompetition`.`scf_discipline_id`, `ScCompetition`.`scf_competition_label_id`, `ScCompetition`.`scf_chronometrage_type_id`, `ScCompetition`.`scf_competition_niveau_id`, `ScCompetition`.`piscine_id`, `ScCompetition`.`pool_name`, `ScCompetition`.`pool_lane`, `ScCompetition`.`pool_size`, `ScCompetition`.`byteam`, `ScCompetition`.`description`, `ScCompetition`.`lien_unique`, `ScCompetition`.`vide`, `ScCompetition`.`xml_vide`, `ScCompetition`.`xml_resultats_vide`, `ScCompetition`.`xml_faux`, `ScCompetition`.`existe_plus`, `ScCompetition`.`erreur_integration`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`sc_competition_clubs` AS `ScCompetitionClub` LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScCompetitionClub`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScCompetitionClub`.`club_id` = `Club`.`id`) WHERE `ScCompetitionClub`.`club_id` = '170690532' AND `ScCompetition`.`startdate` <= '2019-12-06' AND `ScCompetition`.`id` NOT LIKE '%SC-%' ORDER BY `ScCompetition`.`startdate` DESC LIMIT 0,6

SELECT `ScCompetitionClub`.`id`, `ScCompetitionClub`.`sc_competition_id`, `ScCompetitionClub`.`club_id`, `ScCompetition`.`id`, `ScCompetition`.`type`, `ScCompetition`.`ffnex_id`, `ScCompetition`.`profil_id`, `ScCompetition`.`origine`, `ScCompetition`.`name`, `ScCompetition`.`city`, `ScCompetition`.`departement_id`, `ScCompetition`.`region_id`, `ScCompetition`.`startdate`, `ScCompetition`.`stopdate`, `ScCompetition`.`date_limit_engagement_debut`, `ScCompetition`.`date_limit_engagement_fin`, `ScCompetition`.`date_pub_start_list`, `ScCompetition`.`saison`, `ScCompetition`.`nation`, `ScCompetition`.`age_min`, `ScCompetition`.`age_max`, `ScCompetition`.`scf_competition_type_id`, `ScCompetition`.`scf_discipline_id`, `ScCompetition`.`scf_competition_label_id`, `ScCompetition`.`scf_chronometrage_type_id`, `ScCompetition`.`scf_competition_niveau_id`, `ScCompetition`.`piscine_id`, `ScCompetition`.`pool_name`, `ScCompetition`.`pool_lane`, `ScCompetition`.`pool_size`, `ScCompetition`.`byteam`, `ScCompetition`.`description`, `ScCompetition`.`lien_unique`, `ScCompetition`.`vide`, `ScCompetition`.`xml_vide`, `ScCompetition`.`xml_resultats_vide`, `ScCompetition`.`xml_faux`, `ScCompetition`.`existe_plus`, `ScCompetition`.`erreur_integration`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`sc_competition_clubs` AS `ScCompetitionClub` LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScCompetitionClub`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScCompetitionClub`.`club_id` = `Club`.`id`) WHERE `ScCompetitionClub`.`club_id` = '170690532' AND `ScCompetition`.`startdate` > '2019-12-06' ORDER BY `ScCompetition`.`startdate` asc LIMIT 0,6

SELECT `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Vignette`.`id`, `Vignette`.`content_type_id`, `Vignette`.`media_type_id`, `Vignette`.`content_id`, `Vignette`.`local`, `Vignette`.`extention`, `Vignette`.`poids`, `Vignette`.`nom_fichier`, `Vignette`.`nom`, `Vignette`.`dossier`, `Vignette`.`code_embed`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Group`.`id`, `Group`.`parent_id`, `Group`.`name`, `Group`.`created`, `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id`, `MentionsLegale`.`id`, `MentionsLegale`.`content_type_id`, `MentionsLegale`.`content_id`, `MentionsLegale`.`adresse_site_web`, `MentionsLegale`.`raison_sociale`, `MentionsLegale`.`forme_juridique`, `MentionsLegale`.`num_siren`, `MentionsLegale`.`code_naf`, `MentionsLegale`.`adresse_siege`, `MentionsLegale`.`responsable_publication`, `MentionsLegale`.`num_cnil`, `MentionsLegale`.`webmaster`, `MentionsLegale`.`createur`, `MentionsLegale`.`hebergeur`, `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id`, `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id`, `MediaManagerMedia`.`id`, `MediaManagerMedia`.`content_type_id`, `MediaManagerMedia`.`media_type_id`, `MediaManagerMedia`.`content_id`, `MediaManagerMedia`.`local`, `MediaManagerMedia`.`extention`, `MediaManagerMedia`.`poids`, `MediaManagerMedia`.`nom_fichier`, `MediaManagerMedia`.`nom`, `MediaManagerMedia`.`dossier`, `MediaManagerMedia`.`code_embed`, `ClubPage`.`id`, `ClubPage`.`content_id`, `ClubPage`.`content_type_id`, `ClubPage`.`club_id`, `ClubPage`.`module`, `ClubPage`.`menu`, `ClubPage`.`activite_id`, `ClubPage`.`commission_id`, `ClubPage`.`edition_id`, `ClubActu`.`id`, `ClubActu`.`club_id`, `ClubActu`.`profil_id`, `ClubActu`.`content_id`, `ClubActu`.`epingler`, `ClubActu`.`cache_accueil`, `ClubActu`.`image`, `ClubActu`.`content_type_id`, `ClubActu`.`clubactivites_club_id`, `ClubActu`.`club_group_id`, `ClubActu`.`clubevenements_club_id`, `ClubActu`.`clubcommissions_club_id`, `ClubActu`.`club_edition_id`, `ClubActu`.`email`, `ClubActu`.`sc_competition_id` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_actus` AS `ClubActu` ON (`ClubActu`.`content_id` = `Content`.`id`) WHERE ((`ClubActu`.`club_id` = '170690532') OR (`ClubPage`.`club_id` = '170690532')) AND `Content`.`etat_id` = '1' AND `Content`.`content_type_id` = 7 ORDER BY `Content`.`created` DESC LIMIT 0,6

306

SELECT `ClubAlbumFile`.`id`, `ClubAlbumFile`.`club_album_id`, `ClubAlbumFile`.`name`, `ClubAlbumFile`.`extention_id`, `ClubAlbumFile`.`type`, `ClubAlbumFile`.`slug`, `ClubAlbumFile`.`nom_fichier`, `ClubAlbumFile`.`poids`, `ClubAlbumFile`.`dossier`, `ClubAlbumFile`.`url`, `ClubAlbumFile`.`created`, `ClubAlbumFile`.`updated`, `ClubAlbum`.`id`, `ClubAlbum`.`name`, `ClubAlbum`.`description`, `ClubAlbum`.`lien_externe`, `ClubAlbum`.`club_id`, `ClubAlbum`.`cache_accueil`, `ClubAlbum`.`profil_id`, `ClubAlbum`.`date`, `ClubAlbum`.`created`, `ClubAlbum`.`updated` FROM `abcnatation-fr`.`club_album_files` AS `ClubAlbumFile` LEFT JOIN `abcnatation-fr`.`club_albums` AS `ClubAlbum` ON (`ClubAlbumFile`.`club_album_id` = `ClubAlbum`.`id`) WHERE `ClubAlbum`.`club_id` = '170690532' AND `ClubAlbum`.`cache_accueil` = '0' ORDER BY rand() ASC LIMIT 10

305

SELECT `ClubPartenaire`.`id`, `ClubPartenaire`.`club_id`, `ClubPartenaire`.`profil_id`, `ClubPartenaire`.`content_id`, `ClubPartenaire`.`content_type_id`, `ClubPartenaire`.`site_web`, `ClubPartenaire`.`logo`, `ClubPartenaire`.`categorie`, `ClubPartenaire`.`ordre`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`club_partenaires` AS `ClubPartenaire` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubPartenaire`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubPartenaire`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubPartenaire`.`content_type_id` = `ContentType`.`id`) WHERE `ClubPartenaire`.`club_id` = '170690532' AND `Content`.`etat_id` = '1' ORDER BY `ClubPartenaire`.`ordre` ASC

SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`menu_id` = '1' AND `Content`.`etat_id` = '1' AND `Content`.`content_type_id` IN (1, 2, 3, 4) ORDER BY `lft` ASC

368

SELECT `Content`.`lft`, `Content`.`rght` FROM `abcnatation-fr`.`contents` AS `Content` WHERE `Content`.`id` = '' LIMIT 1

SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`content_type_id` IN (1, 2, 3, 4) AND `Content`.`menu_id` = '1' AND `Content`.`etat_id` = '1' AND `Content`.`parent_id` IS NULL ORDER BY `Content`.`lft` ASC

350

SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')

SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC

SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '170690532' AND `Content`.`content_type_id` = 7 ORDER BY `Content`.`position` ASC

SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('170690532')

SELECT `Droits`.`libelle`, `Droits`.`masque` FROM `abcnatation-fr`.`droits` AS `Droits` WHERE 1 = 1