Championnats de France en petit bassin

Nationale

ANGERS

Du Jeudi 17 Novembre 2016 au Dimanche 20 Novembre 2016

Bassin de 25m

50 Dos Dames

Nom Année Club Pays Temps Points Niv.
1 HENIQUE Mélanie 1992 CN MARSEILLE FRA 0:27:03 0
2 TOUILI Lila 2000 CANET 66 NATATION FRA 0:27:99 0
3 HERTHE Alexe 2000 CN CHALON-SUR-SAONE FRA 0:28:92 0
4 CASTAING Anais 1999 DAUPHINS TOULOUSE OEC FRA 0:28:94 0
5 MELIH Amel 1993 LYON NATATION FRA 0:28:99 0
6 BOURSE Claire 1998 CN BREST FRA 0:29:19 0
7 SCRIVIN Julia 1992 ASPTT GRAND TOULOUSE FRA 0:29:25 0
8 PODEVIN Anaïs 1997 DAUPHINS TOULOUSE OEC FRA 0:29:44 0
9 POU Lisa 1999 AS MONACO NATATION FRA 0:30:22 0
10 LAGANIER Amandine 1999 ASPTT MONTPELLIER FRA 0:30:57 0
11 LUCAS Mila 2002 ANGERS NATATION FRA 0:30:73 0
12 CORMIER Alexane 1999 AQUATIC CLUB BOURGES FRA 0:31:05 0
13 VILLETTE Margot 1999 OCTEVILLE NATATION FRA 0:31:06 0
14 BAQUET Rosanna 1999 U.S CRETEIL NATATION FRA 0:31:15 0
15 DELAUNAY Mai 2001 CLUB AQUATIQUE CHOLETAIS FRA 0:31:17 0
16 BATOT Manon 2000 CNO ST-GERMAIN-EN-LAYE FRA 0:31:36 0

Séries

Nom Année Club Pays Temps Points Niv.
1 HENIQUE Mélanie 1992 CN MARSEILLE FRA 0:27:37 1341
2 CINI Mathilde 1994 VALENCE TRIATHLON FRA 0:27:39 1340
3 MAHIEU Pauline 1999 US ST-ANDRÉ FRA 0:28:00 1303
4 EGOROVA Valériya 2001 MONTPELLIER ANUC FRA 0:28:08 1298
5 TOUILI Lila 2000 CANET 66 NATATION FRA 0:28:40 1280
6 BOUTIN Julie 1998 EN TOURS FRA 0:28:53 1272
7 BELKACEMI Leslie 1998 ST-AMAND NAT PORTE DU HAINAUT FRA 0:28:67 1264
8 DEL'HOMME Laurine 1997 CNO ST-GERMAIN-EN-LAYE FRA 0:28:71 1261
9 POULET Laure 1992 EMS BRON FRA 0:28:87 1252
10 REMBERT Eléonore 2001 MONTPELLIER ANUC FRA 0:28:94 1248
11 LECANU Maëlle 1999 STADE FRANÇAIS O COURBEVOIE FRA 0:28:95 1248
12 LEFEBVRE Louise 2003 MULHOUSE ON FRA 0:29:14 1237
13 JEAN Mathilde 2000 AMIENS METROPOLE NAT. FRA 0:29:17 1235
14 GOURAUD Agathe 2001 NANTES NATATION FRA 0:29:26 1230
15 PODEVIN Anaïs 1997 DAUPHINS TOULOUSE OEC FRA 0:29:26 1230
16 PROUFF Faustine 1988 MOUETTES DE PARIS FRA 0:29:35 1224
17 HERTHE Alexe 2000 CN CHALON-SUR-SAONE FRA 0:29:37 1223
18 SCRIVIN Julia 1992 ASPTT GRAND TOULOUSE FRA 0:29:40 1222
19 CARA Axelle 1997 CN ANTIBES FRA 0:29:45 1219
20 CARO Emma 2000 CANET 66 NATATION FRA 0:29:63 1208
21 ROYER VIEL Léa 2001 MONTPELLIER PAILLADE NATATION FRA 0:29:65 1207
22 COUSSON Clothilde 1998 STADE FRANÇAIS O COURBEVOIE FRA 0:29:66 1207
23 DEACAL Mallaury 2001 CN VAL DE FENSCH SERÉMANGE FRA 0:29:74 1202
24 TRUJILLO Anne-Sophie 1996 OLYMPIC NICE NATATION FRA 0:29:89 1194
25 BOURSE Claire 1998 CN BREST FRA 0:29:92 1192
26 BERSOT Lucie 1999 C REDON NATATION FRA 0:29:96 1190
27 COUSSON Bertille 2002 THOUROTTE NATATION FRA 0:30:01 1187
28 MILLE Marine 1999 AS FONTAINE NATATION FRA 0:30:06 1184
29 LUCAS Mila 2002 ANGERS NATATION FRA 0:30:13 1180
30 ROUAULT Perrine 1998 STADE FRANÇAIS O COURBEVOIE FRA 0:30:27 1172
31 BROSSIER Alizée 2000 TOULON VAR NATATION FRA 0:30:59 1154
32 PLATON Lea 1998 SA MÉRIGNAC FRA 0:30:62 1153
33 ALMEIDA Julia 1998 CERCLE DES NAGEURS DE TALENCE FRA 0:30:96 1134
34 DA CONCEICAO Emma 2000 DAUPHINS D'ANNECY FRA 0:31:22 1119
35 BATOT Manon 2000 CNO ST-GERMAIN-EN-LAYE FRA 0:31:40 1110

Finale A

Nom Année Club Pays Temps Points Niv.
1 HENIQUE Mélanie 1992 CN MARSEILLE FRA 0:26:58 1389
2 CINI Mathilde 1994 VALENCE TRIATHLON FRA 0:27:05 1360
3 EGOROVA Valériya 2001 MONTPELLIER ANUC FRA 0:27:90 1309
4 MAHIEU Pauline 1999 US ST-ANDRÉ FRA 0:28:05 1300
5 DEL'HOMME Laurine 1997 CNO ST-GERMAIN-EN-LAYE FRA 0:28:15 1294
6 TOUILI Lila 2000 CANET 66 NATATION FRA 0:28:35 1283
7 BOUTIN Julie 1998 EN TOURS FRA 0:28:62 1267
8 BELKACEMI Leslie 1998 ST-AMAND NAT PORTE DU HAINAUT FRA 0:28:73 1260

Finale B

Nom Année Club Pays Temps Points Niv.
1 LEFEBVRE Louise 2003 MULHOUSE ON FRA 0:28:92 1249
2 JEAN Mathilde 2000 AMIENS METROPOLE NAT. FRA 0:28:95 1248
3 GOURAUD Agathe 2001 NANTES NATATION FRA 0:28:99 1245
4 LECANU Maëlle 1999 STADE FRANÇAIS O COURBEVOIE FRA 0:29:03 1243
5 REMBERT Eléonore 2001 MONTPELLIER ANUC FRA 0:29:06 1241
6 POULET Laure 1992 EMS BRON FRA 0:29:15 1236
7 PODEVIN Anaïs 1997 DAUPHINS TOULOUSE OEC FRA 0:29:25 1230
8 PROUFF Faustine 1988 MOUETTES DE PARIS FRA 0:29:55 1213

Finale C

Nom Année Club Pays Temps Points Niv.
1 HERTHE Alexe 2000 CN CHALON-SUR-SAONE FRA 0:29:31 1227
2 CARO Emma 2000 CANET 66 NATATION FRA 0:29:49 1216
3 ROYER VIEL Léa 2001 MONTPELLIER PAILLADE NATATION FRA 0:29:55 1213
4 DEACAL Mallaury 2001 CN VAL DE FENSCH SERÉMANGE FRA 0:29:91 1193
5 COUSSON Bertille 2002 THOUROTTE NATATION FRA 0:30:14 1180
6 BROSSIER Alizée 2000 TOULON VAR NATATION FRA 0:30:40 1165
7 LUCAS Mila 2002 ANGERS NATATION FRA 0:30:53 1158
8 DA CONCEICAO Emma 2000 DAUPHINS D'ANNECY FRA 0:31:10 1126
(default) 24 queries took 96 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`.`sous_domaine` = 'abcnatation.fr' LIMIT 10012
2SELECT `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 10010
3SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC990
4SELECT `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 1000
5SELECT `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
6SELECT `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` = '160571523' AND `Content`.`content_type_id` = 7 ORDER BY `Content`.`position` ASC0021
7SELECT `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` = '160571523' LIMIT 1110
8SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('160571523') 000
9SELECT `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` = '160571523' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 000
10SELECT `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` = '160571523' LIMIT 1113
11SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('160571523') 000
12SELECT `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` = '160571523' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 000
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` = '160571523' LIMIT 11121
14SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('160571523') 000
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` = '160571523' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 000
16SELECT `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` = '160571523' LIMIT 1000
17SELECT `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`, `ScfDiscipline`.`id`, `ScfDiscipline`.`clubactivite_id`, `ScfDiscipline`.`description`, `ScfCompetitionType`.`id`, `ScfCompetitionType`.`description`, `ScfCompetitionNiveau`.`id`, `ScfCompetitionNiveau`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `ScfChronometrageType`.`id`, `ScfChronometrageType`.`description`, `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `ScfCompetitionLabel`.`id`, `ScfCompetitionLabel`.`description` FROM `abcnatation-fr`.`sc_competitions` AS `ScCompetition` LEFT JOIN `abcnatation-fr`.`scf_disciplines` AS `ScfDiscipline` ON (`ScCompetition`.`scf_discipline_id` = `ScfDiscipline`.`id`) LEFT JOIN `abcnatation-fr`.`scf_competition_types` AS `ScfCompetitionType` ON (`ScCompetition`.`scf_competition_type_id` = `ScfCompetitionType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_competition_niveaux` AS `ScfCompetitionNiveau` ON (`ScCompetition`.`scf_competition_niveau_id` = `ScfCompetitionNiveau`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`ScCompetition`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`ScCompetition`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`scf_chronometrage_types` AS `ScfChronometrageType` ON (`ScCompetition`.`scf_chronometrage_type_id` = `ScfChronometrageType`.`id`) LEFT JOIN `abcnatation-fr`.`piscines` AS `Piscine` ON (`ScCompetition`.`piscine_id` = `Piscine`.`id`) LEFT JOIN `abcnatation-fr`.`scf_competition_labels` AS `ScfCompetitionLabel` ON (`ScCompetition`.`scf_competition_label_id` = `ScfCompetitionLabel`.`id`) WHERE `ScCompetition`.`id` = '41163' LIMIT 1111
18SELECT `ScEvent`.`id`, `ScEvent`.`sc_competition_id`, `ScEvent`.`sc_event_type_id`, `ScEvent`.`scf_epreuve_type_id`, `ScEvent`.`scf_epreuve_format_id`, `ScEvent`.`scf_groupe_age_id`, `ScEvent`.`date`, `ScEvent`.`periode`, `ScEvent`.`heure`, `ScEvent`.`description`, `ScEvent`.`position`, `ScEvent`.`nom`, `ScEvent`.`age_min`, `ScEvent`.`age_max` FROM `abcnatation-fr`.`sc_events` AS `ScEvent` WHERE `ScEvent`.`sc_competition_id` = ('41163') 000
19SELECT `ScfEpreuveType`.`id`, `ScfEpreuveType`.`description`, `ScfEpreuveType`.`description_short`, `ScfEpreuveType`.`description_middle`, `ScfEpreuveType`.`scf_epreuve_qualif_id`, `ScfEpreuveType`.`genre`, `ScfEpreuveType`.`olympique`, `ScfEpreuveType`.`relais` FROM `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` WHERE `ScfEpreuveType`.`id` = 11 LIMIT 1110
20SELECT `Licencie`.`cache`, `Licencie`.`firstname`, `Licencie`.`lastname`, `Licencie`.`birthdate`, `ScResultat`.`scf_epreuve_format_id`, `ScResultat`.`scf_disqualification_code_id`, `ScResultat`.`temps`, `ScResultat`.`points`, `ScResultat`.`niveau_serie`, `ScfEpreuveFormat`.`description`, `Club`.`name_officiel`, `Club`.`id`, `Club`.`nation`, `ScResultat`.`club_id` 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 `ScCompetition`.`id` = '41163' AND `ScfEpreuveType`.`id` = 11 ORDER BY `ScfEpreuveFormat`.`position` ASC, `ScResultat`.`points` DESC, `ScResultat`.`swimtime` ASC757526
21SELECT `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` ASC3683681
22SELECT `Content`.`lft`, `Content`.`rght` FROM `abcnatation-fr`.`contents` AS `Content` WHERE `Content`.`id` = '' LIMIT 1000
23SELECT `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
24SELECT `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