Notice (8): Undefined index: FormTableau [APP/Plugin/SiteClub/Controller/ScActivitesController.php, line 2474]
Notice (8): Undefined variable: trace [APP/Plugin/SiteClub/Controller/ScActivitesController.php, line 2624]
RACING CLUB ARRAS - Records GROUPE COMPETITION // Propulsé par Abcnatation

Records du club

Tableau Messieurs Bassin de 25

Bassin
Genre
Catégorie
8 ans9 ans10 ans11 ans12 ans13 ans14 ans15 ans16 ans17 ansToutes Cat.
50 Nage Libre Messieurs

histo.
FLAMENT Samuel
13/12/2015
0:53:26
BARATTE Thomas
17/11/2013
0:38:85
FIEF Tristan
28/12/2011
0:35:17
MRUGALSKI Sidney
02/12/2007
0:33:06
MRUGALSKI Sidney
28/12/2008
0:29:59
MRUGALSKI Sidney
28/12/2009
0:27:00
MARCELIN Louis
28/12/2010
0:25:53
MARCELIN Louis
28/12/2011
0:25:08
MARCELIN Louis
15/11/2012
0:23:69
MARCELIN Louis
05/12/2013
0:23:48
MARCELIN Louis
05/12/2013
0:23:48
100 Nage Libre Messieurs

histo.
DEGRAEVE Nicolas
12/12/2010
1:52:31
CALAIS Marius
06/11/2011
1:26:50
VANBELLE Marceau
19/11/2017
1:25:29
BONHOMME Célien
16/06/2013
1:13:75
HORNEZ Lenaik
28/12/2015
1:05:77
HORNEZ Lenaik
30/12/2016
0:59:49
MRUGALSKI Sidney
29/12/2010
0:56:25
MARCELIN Louis
18/12/2011
0:54:44
MARCELIN Louis
29/12/2012
0:51:69
MARCELIN Louis
06/12/2013
0:50:75
MARCELIN Louis
06/12/2013
0:50:75
200 Nage Libre Messieurs

histo.
BARATTE Thomas
18/03/2012
4:09:84
DELPLANQUE David
06/12/2009
3:15:92
BONHOMME Célien
28/12/2012
2:53:35
PETITFRÈRE Théo
09/11/2019
2:35:45 *
MRUGALSKI Sidney
28/12/2008
2:24:98
HORNEZ Lenaik
29/12/2016
2:10:30
MRUGALSKI Sidney
28/12/2010
2:04:32
DELMOTTE Luc
08/12/2007
1:58:22
DELMOTTE Luc
21/12/2008
1:53:70
MARCELIN Louis
08/12/2013
1:51:68
CABO-HURLE Kevin
10/12/2011
1:51:44
400 Nage Libre Messieurs

histo.

A établir
BRUNET Raphael
20/12/2008
6:17:38
HENOCQ Flavien
18/05/2014
6:14:38
CABO Antoine
22/12/2007
5:17:22
MRUGALSKI Sidney
28/12/2008
5:07:05
JOSSIEN Julien
28/12/2004
4:42:43
MRUGALSKI Sidney
27/12/2010
4:29:53
DELMOTTE Luc
09/12/2007
4:10:28
CABO-HURLE Kevin
12/12/2009
4:02:79
DELMOTTE Luc
09/05/2009
3:59:95
CABO-HURLE Kevin
04/06/2011
3:59:62
800 Nage Libre Messieurs

histo.

A établir

A établir

A établir
PINSON Kevin
12/12/2004
13:12:38
DELMOTTE Luc
12/12/2004
10:37:98
MRUGALSKI Sidney
01/03/2009
10:08:20
MRUGALSKI Sidney
01/03/2009
10:08:20
MRUGALSKI Sidney
01/03/2009
10:08:20
VERDEZ Theo
22/12/2012
8:57:64
VERDEZ Theo
22/12/2012
8:57:64
VERDEZ Theo
22/12/2012
8:57:64
1500 Nage Libre Messieurs

histo.

A établir

A établir

A établir

A établir
HART Matthias
27/05/2018
21:33:11
DELMOTTE Luc
11/11/2005
18:32:86
DELMOTTE Luc
17/12/2006
17:03:99
DELMOTTE Luc
22/12/2007
16:40:67
CABO-HURLE Kevin
11/12/2009
16:15:03
CABO-HURLE Kevin
11/12/2009
16:15:03
CABO-HURLE Kevin
11/12/2009
16:15:03
8 ans9 ans10 ans11 ans12 ans13 ans14 ans15 ans16 ans17 ansToutes Cat.
50 Dos Messieurs

histo.
DEGRAEVE Nicolas
12/12/2010
0:51:22
DEGRAEVE Nicolas
11/12/2011
0:43:94
DEGRAEVE-LECERF Nicolas
02/12/2012
0:40:30
FIEF Tristan
29/12/2012
0:39:36
DELPLANQUE David
04/11/2012
0:34:71
DELPLANQUE David
28/12/2013
0:29:89
DELPLANQUE David
27/12/2014
0:28:57
DELPLANQUE David
20/12/2015
0:28:53
MOREL Florent
03/12/2006
0:28:34
MARCELIN Louis
28/12/2013
0:27:51
MOREL Florent
11/05/2008
0:27:47
100 Dos Messieurs

histo.

A établir
DELPLANQUE David
15/11/2009
1:47:06 *
DEGRAEVE Nicolas
17/06/2012
1:30:88
FIEF Tristan
28/12/2012
1:21:81
HORNEZ Lenaik
28/12/2015
1:12:61
DELPLANQUE David
30/12/2013
1:04:86
DELPLANQUE David
29/12/2014
1:01:99
MOREL Florent
03/12/2005
1:00:40
MOREL Florent
17/12/2006
0:59:43 *
MOREL Florent
23/12/2007
0:58:06 *
MOREL Florent
23/12/2007
0:58:06 *
200 Dos Messieurs

histo.

A établir
HOUX Hugo
20/12/2008
4:20:90
DELPLANQUE David
14/11/2010
3:20:54
VERDEZ Theo
22/12/2007
2:55:99
HORNEZ Lenaik
07/11/2015
2:38:28
DELPLANQUE David
20/12/2013
2:20:38
DELPLANQUE David
07/12/2014
2:14:71
MOREL Florent
04/12/2005
2:09:01
MOREL Florent
17/12/2006
2:05:75
MOREL Florent
23/12/2007
2:03:54
MOREL Florent
23/12/2007
2:03:54
50 Brasse Messieurs

histo.
HENOCQ Flavien
17/06/2012
1:06:01
ROCHE-MATHON Timothee
29/12/2012
0:51:87
SAULAY Hippolyte
29/12/2010
0:50:45
MRUGALSKI Sidney
02/12/2007
0:45:23
RUDENT Victor
07/10/2018
0:40:36
JOSSIEN Julien
19/12/2004
0:34:44
LEMOINE Gauthier
29/12/2004
0:32:73
KLEIN Anthony
19/11/2011
0:31:78
LEMOINE Aurélien
29/12/2004
0:29:37
LEMOINE Aurélien
12/11/2005
0:29:35
DENIS Romain
04/01/2018
0:28:61
100 Brasse Messieurs

histo.

A établir
VERMEIL Nathan
05/11/2016
1:56:05
BONHOMME Célien
28/12/2012
1:43:90
RUDENT Victor
11/11/2017
1:33:11
RUDENT Victor
29/12/2018
1:27:92
JOSSIEN Julien
28/12/2004
1:17:28
LEMOINE Gauthier
28/12/2004
1:09:59
KLEIN Anthony
11/12/2011
1:09:12
LEMOINE Aurélien
28/12/2004
1:06:12
DENIS Romain
17/12/2010
1:04:77
DENIS Romain
26/11/2016
1:02:57
200 Brasse Messieurs

histo.
DELPLANQUE David
20/12/2008
4:39:15
SAULAY Hippolyte
15/11/2009
4:15:13
BONHOMME Célien
27/12/2012
3:34:27
BONHOMME Célien
27/12/2012
3:34:27
LAURENT Anatole
30/12/2018
3:07:49
JOSSIEN Julien
19/12/2004
2:44:91
LEMOINE Gauthier
29/12/2004
2:30:28
KLEIN Anthony
10/12/2011
2:28:51
LEMOINE Gauthier
02/12/2006
2:26:47
DENIS Romain
28/12/2010
2:22:07
DENIS Romain
19/12/2015
2:19:76
50 Papillon Messieurs

histo.
BARATTE Thomas
18/03/2012
1:04:04
BARATTE Thomas
28/12/2013
0:45:17
BARATTE Thomas
02/11/2014
0:41:84
SIEDLECKI Martin
28/12/2016
0:40:47
HORNEZ Lenaik
26/12/2015
0:32:53
HORNEZ Lenaik
28/12/2016
0:28:65
HORNEZ Lenaik
25/11/2017
0:27:91
MRUGALSKI Sidney
28/12/2011
0:27:02
MARCELIN Louis
28/12/2012
0:25:36
MARCELIN Louis
08/12/2013
0:24:91
MARCELIN Louis
08/12/2013
0:24:91
8 ans9 ans10 ans11 ans12 ans13 ans14 ans15 ans16 ans17 ansToutes Cat.
100 Papillon Messieurs

histo.

A établir
BARATTE Thomas
10/11/2013
1:54:98
DEGRAEVE-LECERF Nicolas
11/11/2012
1:36:30
HART Matthias
10/12/2017
1:29:23
HORNEZ Lenaik
27/12/2015
1:13:80
DELPLANQUE David
20/12/2013
1:07:43
MRUGALSKI Sidney
29/12/2010
1:01:91
MRUGALSKI Sidney
29/12/2011
0:59:78
MARCELIN Louis
29/12/2012
0:55:64
MARCELIN Louis
05/12/2013
0:55:46
MARCELIN Louis
05/12/2013
0:55:46
200 Papillon Messieurs

histo.

A établir

A établir

A établir
HART Matthias
11/11/2017
3:22:16
MRUGALSKI Sidney
20/12/2008
3:04:25
HORNEZ Lenaik
30/12/2016
2:46:87
DELPLANQUE David
09/11/2014
2:24:67
MARCELIN Louis
29/12/2011
2:15:80
MARCELIN Louis
09/12/2012
2:07:95
MARCELIN Louis
09/12/2012
2:07:95
MARCELIN Louis
09/12/2012
2:07:95
100 4 Nages Messieurs

histo.
HENOCQ Flavien
02/12/2012
2:01:17
MASSON Arsène
03/12/2017
1:50:75
BARATTE Thomas
16/11/2014
1:32:08
SIEDLECKI Martin
27/11/2016
1:23:87
HORNEZ Lenaik
13/12/2015
1:14:87
DELPLANQUE David
29/12/2013
1:08:95
MARCELIN Louis
28/12/2010
1:04:57
MRUGALSKI Sidney
28/12/2011
1:01:18
MARCELIN Louis
28/12/2012
0:58:15
MARCELIN Louis
07/12/2013
0:56:83
MARCELIN Louis
07/12/2013
0:56:83
200 4 Nages Messieurs

histo.

A établir
FLAMENT Samuel
05/11/2016
4:02:61
BONHOMME Célien
11/11/2012
3:13:49
PETITFRÈRE Théo
06/10/2019
3:05:29
DELPLANQUE David
27/12/2012
2:48:39
JOSSIEN Julien
19/12/2004
2:26:67
MRUGALSKI Sidney
05/12/2010
2:21:71
MRUGALSKI Sidney
27/12/2011
2:14:77
MRUGALSKI Sidney
23/12/2012
2:08:16
MRUGALSKI Sidney
23/12/2012
2:08:16
MRUGALSKI Sidney
23/12/2012
2:08:16
400 4 Nages Messieurs

histo.

A établir

A établir

A établir
CABO Antoine
22/12/2007
6:29:73
DELMOTTE Luc
14/11/2004
6:04:41
DELMOTTE Luc
18/12/2005
5:29:00
LEMOINE Gauthier
05/12/2004
4:58:22
LEMOINE Gauthier
12/06/2005
4:55:54
VERDEZ Theo
22/12/2012
4:43:24
LEMOINE Gauthier
23/12/2007
4:38:19
LEMOINE Gauthier
23/12/2007
4:38:19
8 ans9 ans10 ans11 ans12 ans13 ans14 ans15 ans16 ans17 ansToutes Cat.
Notice (8): Undefined index: SiteWeb [APP/Plugin/SiteClub/View/Layouts/default.ctp, line 340]
RACING CLUB ARRAS
(default) 91 queries took 2047 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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` = '180620312' LIMIT 1113
2SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('180620312') 220
3SELECT `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` = '180620312' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 30301
4SELECT `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 1000
5SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC990
6SELECT `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 10012
7SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE `date_debut` <= '2019-12-07' AND `date_fin` > '2019-12-07' LIMIT 1110
8SELECT `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` = '180620312') OR (`Club`.`id` = '180620312')) LIMIT 1113
9SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('180620312') 220
10SELECT `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` = '180620312' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 30300
11SELECT `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 1000
12SELECT `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` = '180620312' LIMIT 1111
13SELECT `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` = '180620312' LIMIT 1110
14SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('180620312') 220
15SELECT `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` = '180620312' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 30300
16SELECT `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` = '180620312' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = '' ORDER BY `Content`.`position` ASC994
17SELECT `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` = '180620312' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'boutique' ORDER BY `Content`.`position` ASC224
18SELECT `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` = '180620312' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'partenaire' ORDER BY `Content`.`position` ASC003
19SELECT `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` = '180620312' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'footer' ORDER BY `Content`.`position` ASC003
20SELECT `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` = '180620312' AND ((`Content`.`content_type_id` = 7) OR (`Content`.`content_type_id` = 10)) AND `ClubPage`.`menu` = 'home' ORDER BY `Content`.`position` ASC334
21SELECT `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` = '180620312' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'activite' ORDER BY `Content`.`position` ASC113
22SELECT `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 110
23SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 42152 000
24SELECT `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` = 42152 000
25SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 42152 000
26SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 42152 000
27SELECT `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` = 42152 000
28SELECT `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` = 42152 110
29SELECT `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` = 42152 1116
30SELECT `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` = '180620312' 111
31SELECT `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 110
32SELECT `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` = '180620312' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'commission' ORDER BY `Content`.`position` ASC003
33SELECT `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` = '180620312' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'edition' ORDER BY `Content`.`position` ASC003
34SELECT `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` = '180620312' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'medias' ORDER BY `Content`.`position` ASC003
35SELECT `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` = '180620312' AND ((NOT (`Content`.`etat_id` = '0')) OR (`Content`.`etat_id` = '1'))23523519
36SELECT `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` = '180620312' AND `ClubactivitesClub`.`saison_id` = '2019-2020' ORDER BY `ClubactivitesClub`.`ordre` ASC661
37SELECT `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` = '180620312' AND `ClubcommissionsClub`.`saison_id` = '2019-2020' ORDER BY `ClubcommissionsClub`.`ordre` ASC000
38SELECT `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` = '180620312' AND `ClubevenementsClub`.`etat_id` = '1'113
39SELECT `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` FROM `abcnatation-fr`.`club_editions` AS `ClubEdition` WHERE `ClubEdition`.`clubevenements_club_id` = (301) 222
40SELECT `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` = '180620312'48484
41SELECT `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` = '180620312' AND `Content`.`content_type_id` = 7 AND `Content`.`etat_id` = '1'003
42SELECT `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`.`id` = 9911 LIMIT 1110
43SELECT `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`.`id` = 9911 LIMIT 1110
44SELECT `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` = '180620312' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'activite' AND `ClubPage`.`activite_id` = 1 ORDER BY `Content`.`position` ASC003
45SELECT `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` = '180620312' AND `ScCompetition`.`startdate` > '2019-12-07' ORDER BY `ScCompetition`.`startdate` asc33339
46SELECT `Clubcommission`.`id`, `Clubcommission`.`description`, `Clubcommission`.`type`, `Clubcommission`.`activite_id`, `Clubcommission`.`ordre` FROM `abcnatation-fr`.`clubcommissions` AS `Clubcommission` WHERE `Clubcommission`.`activite_id` = 1 LIMIT 1110
47SELECT `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`.`clubcommission_id` = 0 AND `ClubcommissionsClub`.`club_id` = '180620312' LIMIT 1000
48SELECT `ClubactivitesClub`.`id` FROM `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` WHERE `ClubactivitesClub`.`clubactivite_id` = 1 AND `ClubactivitesClub`.`club_id` = '180620312'550
49SELECT `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` = '180620312' AND ((NOT (`Content`.`etat_id` = '0')) OR (`Content`.`etat_id` = '1')) AND `ClubActu`.`clubactivites_club_id` IN (9911, 7243, 7603, 8661, 10538)223
50SELECT `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`, `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`, `ClubNiveauPratique`.`id`, `ClubNiveauPratique`.`name`, `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_groups` AS `ClubGroup` LEFT JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubGroup`.`clubactivites_club_id` = `ClubactivitesClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_niveau_pratiques` AS `ClubNiveauPratique` ON (`ClubGroup`.`club_niveau_pratique_id` = `ClubNiveauPratique`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubGroup`.`club_id` = `Club`.`id`) WHERE `ClubGroup`.`clubactivites_club_id` = 99117747
51SELECT `ClubOrganigramme`.`id`, `ClubOrganigramme`.`club_id`, `ClubOrganigramme`.`saison_id`, `ClubOrganigramme`.`licencie_id`, `ClubOrganigramme`.`club_membre_id`, `ClubOrganigramme`.`club_role_id`, `ClubOrganigramme`.`clubactivites_club_id`, `ClubOrganigramme`.`clubcommissions_club_id`, `ClubOrganigramme`.`club_group_id`, `ClubOrganigramme`.`club_seance_id`, `ClubOrganigramme`.`seance_lot_id`, `ClubOrganigramme`.`profil_id`, `ClubOrganigramme`.`created` FROM `abcnatation-fr`.`club_organigrammes` AS `ClubOrganigramme` WHERE `ClubOrganigramme`.`club_group_id` IN (15686, 15685, 15684, 15681, 15682, 15683, 15680) 9999481
52SELECT `ClubSeance`.`id`, `ClubSeance`.`club_group_id`, `ClubSeance`.`saison_id`, `ClubSeance`.`jour`, `ClubSeance`.`heure_debut`, `ClubSeance`.`heure_fin`, `ClubSeance`.`nbr_place`, `ClubSeance`.`piscine_id`, `ClubSeance`.`club_membre_id` FROM `abcnatation-fr`.`club_seances` AS `ClubSeance` WHERE `ClubSeance`.`club_group_id` IN (15686, 15685, 15684, 15681, 15682, 15683, 15680) 151515
53SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1111
54SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1110
55SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1110
56SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1110
57SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1110
58SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1110
59SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1110
60SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1110
61SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1110
62SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1110
63SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 461 LIMIT 1111
64SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1110
65SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1110
66SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1110
67SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `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`, `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`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 460 LIMIT 1110
68SELECT `SeanceLot`.`id`, `SeanceLot`.`club_group_id`, `SeanceLot`.`lot`, `SeanceLot`.`nbr_place` FROM `abcnatation-fr`.`seance_lots` AS `SeanceLot` WHERE `SeanceLot`.`club_group_id` IN (15686, 15685, 15684, 15681, 15682, 15683, 15680) 001
69SELECT `ClubOrganigramme`.`id`, `ClubOrganigramme`.`club_id`, `ClubOrganigramme`.`saison_id`, `ClubOrganigramme`.`licencie_id`, `ClubOrganigramme`.`club_membre_id`, `ClubOrganigramme`.`club_role_id`, `ClubOrganigramme`.`clubactivites_club_id`, `ClubOrganigramme`.`clubcommissions_club_id`, `ClubOrganigramme`.`club_group_id`, `ClubOrganigramme`.`club_seance_id`, `ClubOrganigramme`.`seance_lot_id`, `ClubOrganigramme`.`profil_id`, `ClubOrganigramme`.`created`, `ClubRole`.`id`, `ClubRole`.`name`, `ClubRole`.`lft`, `ClubRole`.`rght`, `ClubRole`.`parent_id`, `ClubRole`.`ordre`, `ClubRole`.`clubactivite_id`, `ClubRole`.`clubcommission_id`, `ClubRole`.`group`, `ClubRole`.`unique`, `ClubRole`.`niveau_creneau`, `ClubRole`.`type`, `ClubRole`.`organigramme`, `ClubRole`.`droits`, `ClubMembre`.`id`, `ClubMembre`.`club_id`, `ClubMembre`.`saison_id`, `ClubMembre`.`futur`, `ClubMembre`.`nom`, `ClubMembre`.`prenom`, `ClubMembre`.`gender`, `ClubMembre`.`date_naissance`, `ClubMembre`.`image`, `ClubMembre`.`club_inscription_id`, `ClubMembre`.`profil_id`, `ClubMembre`.`coordonnee_id`, `ClubMembre`.`resp1_genre`, `ClubMembre`.`resp1_relation`, `ClubMembre`.`resp1_nom`, `ClubMembre`.`resp1_prenom`, `ClubMembre`.`resp1_naissance`, `ClubMembre`.`resp1_nationnalite_id`, `ClubMembre`.`resp1_coordonnee_id`, `ClubMembre`.`resp2_genre`, `ClubMembre`.`resp2_relation`, `ClubMembre`.`resp2_nom`, `ClubMembre`.`resp2_prenom`, `ClubMembre`.`resp2_naissance`, `ClubMembre`.`resp2_nationnalite_id`, `ClubMembre`.`resp2_coordonnee_id`, `ClubMembre`.`licencie_id`, `ClubMembre`.`licencie`, `ClubMembre`.`membre_nationnalite_id`, `ClubMembre`.`membre_profession`, `ClubMembre`.`membre_taille`, `ClubMembre`.`membre_pointure`, `ClubMembre`.`majeur_film`, `ClubMembre`.`handicap`, `ClubMembre`.`recevoir_news`, `ClubMembre`.`membre_metier_id`, `ClubMembre`.`carte`, `ClubMembre`.`cache`, `ClubMembre`.`type_licence`, `ClubMembre`.`activite_ffn`, `ClubMembre`.`created`, `ClubMembre`.`updated`, `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`, `ClubcommissionsClub`.`id`, `ClubcommissionsClub`.`clubcommission_id`, `ClubcommissionsClub`.`club_id`, `ClubcommissionsClub`.`libelle`, `ClubcommissionsClub`.`saison_id`, `ClubcommissionsClub`.`presentation`, `ClubcommissionsClub`.`ordre`, `ClubSeance`.`id`, `ClubSeance`.`club_group_id`, `ClubSeance`.`saison_id`, `ClubSeance`.`jour`, `ClubSeance`.`heure_debut`, `ClubSeance`.`heure_fin`, `ClubSeance`.`nbr_place`, `ClubSeance`.`piscine_id`, `ClubSeance`.`club_membre_id`, `SeanceLot`.`id`, `SeanceLot`.`club_group_id`, `SeanceLot`.`lot`, `SeanceLot`.`nbr_place` FROM `abcnatation-fr`.`club_organigrammes` AS `ClubOrganigramme` LEFT JOIN `abcnatation-fr`.`club_roles` AS `ClubRole` ON (`ClubOrganigramme`.`club_role_id` = `ClubRole`.`id`) LEFT JOIN `abcnatation-fr`.`club_membres` AS `ClubMembre` ON (`ClubOrganigramme`.`club_membre_id` = `ClubMembre`.`id`) LEFT JOIN `abcnatation-fr`.`club_groups` AS `ClubGroup` ON (`ClubOrganigramme`.`club_group_id` = `ClubGroup`.`id`) LEFT JOIN `abcnatation-fr`.`clubcommissions_clubs` AS `ClubcommissionsClub` ON (`ClubOrganigramme`.`clubcommissions_club_id` = `ClubcommissionsClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_seances` AS `ClubSeance` ON (`ClubOrganigramme`.`club_seance_id` = `ClubSeance`.`id`) LEFT JOIN `abcnatation-fr`.`seance_lots` AS `SeanceLot` ON (`ClubOrganigramme`.`seance_lot_id` = `SeanceLot`.`id`) WHERE `ClubOrganigramme`.`clubactivites_club_id` = 9911 AND `ClubOrganigramme`.`club_id` = '180620312' AND ((NOT (`ClubRole`.`type` = 'pratiquant')) AND (NOT (`ClubRole`.`type` = 'autre'))) ORDER BY `ClubRole`.`id` ASC00453
70SELECT `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` = '180620312' AND `ScCompetition`.`origine` NOT LIKE 'abc' ORDER BY `ScCompetition`.`saison` DESC LIMIT 11115
71SELECT `ScfEpreuveType`.`id`, `ScfEpreuveType`.`description` FROM `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` WHERE `ScfEpreuveType`.`genre` = 'F'46460
72SELECT `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`.`id` = 9911 LIMIT 1110
73SELECT `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` = '180620312' LIMIT 1110
74SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('180620312') 220
75SELECT `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` = '180620312' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 30300
76SELECT `ScfEpreuveType`.`id`, `ScfEpreuveType`.`description` FROM `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` WHERE `ScfEpreuveType`.`genre` = 'H' AND `ScfEpreuveType`.`olympique` = '1' ORDER BY `ScfEpreuveType`.`id` ASC21210
77SELECT `ScfEpreuveType`.`id`, `ScfEpreuveType`.`description`, `ScResultat`.`swimdate`, `Licencie`.`firstname`, `Licencie`.`lastname`, `Licencie`.`id`, `ScResultat`.`id`, `ScResultat`.`licencie_age`, `ScResultat`.`temps`, `ScResultat`.`swimtime`, `ScResultat`.`points`, `ScResultat`.`scf_epreuve_type_id`, `ScCompetition`.`pool_size`, `ScCompetition`.`id`, `ScCompetition`.`saison` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`swimtime` > 0.001 AND `ScfEpreuveType`.`olympique` = '1' AND `Licencie`.`gender` = 'H' AND `ScResultat`.`swimtime` < 90 AND `ScResultat`.`licencie_age` > 7 AND `ScResultat`.`club_id` = '180620312' AND `ScCompetition`.`pool_size` = 25 ORDER BY `ScfEpreuveType`.`id` ASC, `ScResultat`.`licencie_age` ASC, `ScResultat`.`swimtime` ASC1043010430894
78SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE `date_debut` <= '2019-12-07' AND `date_fin` > '2019-12-07' LIMIT 1110
79SELECT `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` ASC3683689
80SELECT `Content`.`lft`, `Content`.`rght` FROM `abcnatation-fr`.`contents` AS `Content` WHERE `Content`.`id` = '' LIMIT 1000
81SELECT `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` ASC3503501
82SELECT `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 = 110100
83SELECT `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` = 'abcnatation.fr' LIMIT 1000
84SELECT `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 1000
85SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC990
86SELECT `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` = '180620312' AND `Content`.`content_type_id` = 7 ORDER BY `Content`.`position` ASC15154
87SELECT `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` = '180620312' LIMIT 1110
88SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('180620312') 220
89SELECT `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` = '180620312' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 30309
90SELECT `Droits`.`libelle`, `Droits`.`masque` FROM `abcnatation-fr`.`droits` AS `Droits` WHERE 1 = 122220
91SELECT `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` = '180620312' AND `Content`.`etat_id` = '1' ORDER BY `ClubPartenaire`.`ordre` ASC18182