Interrégionale
NANCY
Du Samedi 12 Mai 2007 au Dimanche 13 Mai 2007
Bassin de 50m
Nom | Année | Club | Pays | Temps | Points | Niv. | |
---|---|---|---|---|---|---|---|
1 | SCHMITT Elodie | 1992 | CN SARREGUEMINES | FRA | 1:00:92 | 1155 | National |
2 | DUCHATEAU Cécile | 1985 | ALLIANCE DIJON NATATION | FRA | 1:01:07 | 1150 | Interregional |
3 | DEMALDENT Agnès | 1981 | SN VERSAILLES | FRA | 1:01:29 | 1143 | Interregional |
4 | CAPMAN Julie | 1986 | VIERZON NATATION | FRA | 1:01:86 | 1126 | Interregional |
5 | ENFISSI Emilie | 1983 | CN LE PLESSIS-ROBINSON | FRA | 1:02:44 | 1108 | Interregional |
6 | ROCHA Anaïs | 1992 | CN CHALON-SUR-SAONE | FRA | 1:02:54 | 1104 | National |
7 | DOCQUIN Alice | 1990 | CHARLEVILLE-MÉZIÈRES NATATION | FRA | 1:02:55 | 1104 | National |
8 | ESCOUTE Camille | 1991 | AS HERBLAY NATATION | FRA | 1:02:81 | 1096 | National |
9 | NONIN Laura | 1993 | CN CHALON-SUR-SAONE | FRA | 1:02:83 | 1095 | National |
10 | LEBON Laura | 1992 | AS EMERAINVILLE | FRA | 1:03:08 | 1088 | National |
11 | MENENDEZ Pauline | 1992 | CN CHALON-SUR-SAONE | FRA | 1:03:10 | 1087 | National |
12 | MALARME Delphine | 1992 | DAUPHINS OBERNAI | FRA | 1:03:54 | 1074 | National |
13 | DEPAIX Juliette | 1992 | NAUTIQUE ENTENTE CHÂLONS | FRA | 1:03:65 | 1070 | National |
14 | DIDIER Elodie | 1991 | LYON NATATION | FRA | 1:03:66 | 1070 | Interregional |
15 | LAGENETTE Audrey | 1991 | SB BORDEAUX BASTIDE | FRA | 1:03:68 | 1069 | Interregional |
16 | LIZON AU CIRE Daphné | 1990 | ALLIANCE DIJON NATATION | FRA | 1:04:00 | 1060 | Interregional |
17 | VOILLY Alice | 1991 | AUXERRE AQUATIC CLUB | FRA | 1:04:22 | 1053 | Interregional |
18 | NAIT BOUDA Sophia | 1991 | ES NANTERRE | FRA | 1:04:30 | 1051 | Interregional |
19 | BROCHARD Sarah | 1991 | CLUB AQUATIQUE CHOLETAIS | FRA | 1:04:41 | 1047 | Interregional |
20 | ADAM BRUCKER Charlène | 1992 | VAGUE BETSCHDORF-DRACHENBRONN | FRA | 1:04:44 | 1046 | Interregional |
21 | HOULGARD Anne | 1988 | AS AVRILLÉ NATATION | FRA | 1:04:47 | 1046 | Interregional |
22 | DOURNEL Charlotte | 1991 | REIMS NATATION 89 | FRA | 1:04:49 | 1045 | Interregional |
23 | ORIGAS Anaïs | 1988 | AQUAVALLÉES NATATION CLUB | FRA | 1:04:59 | 1042 | Interregional |
24 | BABOIN Lucille | 1993 | AQUATIC CLUB BOURGES | FRA | 1:04:59 | 1042 | National |
25 | GANA Aurore | 1991 | CS CLICHY 92 | FRA | 1:04:69 | 1039 | Interregional |
26 | DOUET Aurélie | 1989 | EN TOURS | FRA | 1:04:84 | 1034 | Interregional |
27 | WEBER Fanny | 1992 | ERSTEIN AQUATIC CLUB | FRA | 1:04:91 | 1032 | Interregional |
28 | BAOUDOUR Estelle | 1986 | MONTCHANIN NATATION | FRA | 1:04:92 | 1032 | Regional |
29 | MOUSSERON Sophie | 1989 | ALLIANCE DIJON NATATION | FRA | 1:04:96 | 1031 | Interregional |
30 | ERBS Manon | 1991 | NATATION HOCHFELDEN | FRA | 1:04:98 | 1030 | Interregional |
31 | BAUDOIN Mégane | 1990 | USM SARAN | FRA | 1:05:12 | 1026 | Interregional |
32 | BARTHEL Mélanie | 1993 | CN VAL DE FENSCH SERÉMANGE | FRA | 1:05:15 | 1025 | National |
33 | JATTEAU Pauline | 1993 | SENS NATATION | FRA | 1:05:15 | 1025 | National |
34 | DOMBRECHT Chloé | 1989 | SENS NATATION | FRA | 1:05:15 | 1025 | Interregional |
35 | MONNET Patricia | 1992 | CA ORSAY | FRA | 1:05:20 | 1024 | Interregional |
36 | HOTTE Perrine | 1991 | CHARLEVILLE-MÉZIÈRES NATATION | FRA | 1:05:30 | 1021 | Interregional |
37 | PAILLOT Cyrielle | 1992 | VILLERUPT NATATION | FRA | 1:05:35 | 1019 | Interregional |
38 | MONTEIL Margaux | 1989 | CN CHALON-SUR-SAONE | FRA | 1:05:36 | 1019 | Regional |
39 | TEBBAL Amel | 1993 | ES VITRY | FRA | 1:05:48 | 1015 | National |
40 | BROGGIO Claire | 1991 | CN VAL DE FENSCH SERÉMANGE | FRA | 1:05:49 | 1015 | Interregional |
41 | PATRIE Nolwenn | 1993 | SO ROSNY | FRA | 1:05:52 | 1014 | National |
42 | TIERI Seymour | 1991 | CA PIERRELATTE ASCEAC | FRA | 1:05:56 | 1013 | Interregional |
43 | BOUCHARDY Julia | 1993 | CN BOURG-EN-BRESSE | FRA | 1:05:59 | 1012 | National |
44 | LU Claire-Charlotte | 1992 | CS CLICHY 92 | FRA | 1:05:60 | 1012 | Interregional |
45 | BERTET Cécile | 1988 | CN ORLÉANS-LA-SOURCE | FRA | 1:05:63 | 1011 | Regional |
46 | LIM Karine | 1989 | ES VITRY | FRA | 1:05:71 | 1009 | Regional |
47 | FERRAND Céline | 1988 | CN MAISONS-ALFORT | FRA | 1:05:78 | 1007 | Regional |
48 | MINET Ségolène | 1990 | SR COLMAR | FRA | 1:05:88 | 1004 | Regional |
49 | BIEJ Charlotte | 1992 | CN VAL DE FENSCH SERÉMANGE | FRA | 1:05:95 | 1002 | Interregional |
50 | ROCHETTE Cécile | 1986 | CN BOURG-EN-BRESSE | FRA | 1:05:97 | 1001 | Regional |
51 | HANDTSCHOEWERCKER Anaïs | 1993 | CA PIERRELATTE ASCEAC | FRA | 1:06:08 | 998 | Interregional |
52 | DORE Justine | 1991 | AAJB ENTENTE BLOIS | FRA | 1:06:14 | 996 | Regional |
53 | DESPREZ Cassandra | 1992 | CN VAL MAUBUEE | FRA | 1:06:20 | 994 | Interregional |
54 | DAVIN Morgane | 1989 | VIERZON NATATION | FRA | 1:06:25 | 993 | Regional |
55 | ROBINOT Ludivine | 1989 | ES THAON | FRA | 1:06:31 | 991 | Regional |
56 | BAOUDOUR Gaëlle | 1990 | MONTCHANIN NATATION | FRA | 1:06:32 | 991 | Regional |
57 | COURIVAUD Stéphanie | 1989 | DAUPHINS AIXE-SUR-VIENNE | FRA | 1:06:33 | 990 | Regional |
58 | DEBAYLE Catherine | 1992 | PAYS DE GEX NATATION | FRA | 1:06:34 | 990 | Interregional |
59 | FLATOT Charley | 1992 | TRITON CLUB BELLEVILLE | FRA | 1:06:39 | 989 | Interregional |
60 | KLINGUER Pauline | 1990 | AUN NORD FRANCHE-COMTÉ | FRA | 1:06:48 | 986 | Regional |
61 | CAILLAUD Julie | 1992 | CLUB NAUTIQUE DE L'ARPAJONNAIS | FRA | 1:06:51 | 985 | Interregional |
62 | NOEL Célie | 1990 | ALLIANCE DIJON NATATION | FRA | 1:06:63 | 982 | Regional |
63 | BIAGIONI Alysson | 1990 | DAUPHINS LES PENNES-MIRABEAU | FRA | 1:06:80 | 977 | Regional |
64 | RAMCOURT Aude | 1993 | CS CLICHY 92 | FRA | 1:06:81 | 976 | Interregional |
65 | VAILLANT CURIEL Julie | 1990 | CA ST-LAURENT-NOUAN | FRA | 1:06:85 | 975 | Regional |
66 | QUENTIN Jeanne | 1992 | SCUF PARIS | FRA | 1:07:07 | 969 | Regional |
67 | DUFAU Clara | 1993 | CANARDS LA ROCHELLE | FRA | 1:07:22 | 965 | Interregional |
68 | WOLOZAN Léa | 1990 | AS FONTAINE NATATION | FRA | 1:07:32 | 962 | Regional |
69 | VAULT Carole | 1990 | AQUATIC CLUB BOURGES | FRA | 1:07:34 | 961 | Regional |
70 | EUGENE Charlotte | 1989 | AS EMERAINVILLE | FRA | 1:07:55 | 955 | Regional |
71 | BERISTAIN Juliette | 1993 | SCUF PARIS | FRA | 1:07:63 | 953 | Interregional |
72 | FIEU Jessica | 1989 | CN BELLEGARDE | FRA | 1:07:69 | 951 | Regional |
73 | LEGRAND Pauline | 1989 | CA ST-LAURENT-NOUAN | FRA | 1:07:71 | 950 | Regional |
74 | TEXIER Marine | 1990 | USM SARAN | FRA | 1:07:72 | 950 | Regional |
75 | MARESCHI Caroline | 1989 | CA ORSAY | FRA | 1:07:72 | 950 | Regional |
76 | JULIEN Mallorie | 1988 | US IVRY-SUR-SEINE | FRA | 1:07:77 | 949 | Regional |
77 | PATTE Noémie | 1991 | AAJB ENTENTE BLOIS | FRA | 1:07:88 | 946 | Regional |
78 | SANTA COMBA Laurie | 1987 | TROYES CHAPELLE NATATION | FRA | 1:07:88 | 946 | Regional |
79 | GRISARD Anaïg | 1987 | AUXERRE AQUATIC CLUB | FRA | 1:07:91 | 945 | Regional |
80 | MATHI Clémence | 1991 | CN SARREGUEMINES | FRA | 1:07:96 | 943 | Regional |
81 | WOIRHAYE Cécile | 1992 | CN SARREGUEMINES | FRA | 1:07:98 | 943 | Regional |
82 | SABATTE Laure | 1989 | AS AVRILLÉ NATATION | FRA | 1:08:23 | 936 | Departemental 50 |
83 | LEFRICHE Faustine | 1992 | CLUB AQUATIQUE CHOLETAIS | FRA | 1:08:40 | 931 | Regional |
84 | BUCCI Emilie | 1990 | AS FONTAINE NATATION | FRA | 1:08:61 | 925 | Regional |
85 | CASANO Marion | 1993 | CO SAINT-DIZIER NATATION | FRA | 1:08:62 | 925 | Regional |
86 | LAILLER Sarah | 1987 | CLUB AQUATIQUE CHOLETAIS | FRA | 1:08:62 | 925 | Departemental 50 |
87 | GIULIANA Charlotte | 1992 | CN SARREGUEMINES | FRA | 1:08:63 | 924 | Regional |
88 | VERDIER Delphine | 1991 | YERRES NATATION | FRA | 1:08:67 | 923 | Regional |
89 | EMONARD Margot | 1993 | RILLIEUX NATATION | FRA | 1:08:69 | 923 | Regional |
90 | JOLY Morgane | 1991 | CN CHALON-SUR-SAONE | FRA | 1:08:82 | 919 | Regional |
91 | DEL NIDO Clara | 1992 | ENTENTE 95 SANNOIS-MONTIGNY | FRA | 1:09:13 | 910 | Regional |
92 | GAIDDON Léonore | 1990 | PAYS DE GEX NATATION | FRA | 1:09:31 | 905 | Departemental 50 |
93 | LARROCHE Emilie | 1991 | DAUPHINS LES PENNES-MIRABEAU | FRA | 1:09:79 | 892 | Departemental 50 |
94 | MEMMOU Anaïs | 1991 | VIERZON NATATION | FRA | 1:09:81 | 891 | Departemental 50 |
95 | GALLEGO Maëva | 1991 | LYON NATATION | FRA | 1:10:14 | 882 | Departemental 50 |
96 | HERR Morgane | 1992 | SR COLMAR | FRA | 1:10:18 | 881 | Departemental 50 |
97 | TERVER Lucie | 1993 | CN VAL DE FENSCH SERÉMANGE | FRA | 1:10:25 | 879 | Regional |
98 | WEHRLEN Chloé | 1991 | SR COLMAR | FRA | 1:11:05 | 857 | Departemental 50 |
99 | BOUZON Johanna | 1992 | AS FONTAINE NATATION | FRA | 1:11:84 | 836 | Departemental 50 |
100 | ROCHETTE Lucie | 1992 | RILLIEUX NATATION | FRA | 1:12:47 | 819 | Departemental 50 |
101 | KAIL Morgane | 1992 | DAUPHINS LES PENNES-MIRABEAU | FRA | - | Disq. |
Nom | Année | Club | Pays | Temps | Points | Niv. | |
---|---|---|---|---|---|---|---|
1 | SCHMITT Elodie | 1992 | CN SARREGUEMINES | FRA | 1:00:32 | 1174 | National |
2 | DUCHATEAU Cécile | 1985 | ALLIANCE DIJON NATATION | FRA | 1:00:51 | 1168 | Interregional |
3 | DEMALDENT Agnès | 1981 | SN VERSAILLES | FRA | 1:01:32 | 1142 | Interregional |
4 | ENFISSI Emilie | 1983 | CN LE PLESSIS-ROBINSON | FRA | 1:01:67 | 1131 | Interregional |
5 | ROCHA Anaïs | 1992 | CN CHALON-SUR-SAONE | FRA | 1:01:88 | 1125 | National |
6 | CAPMAN Julie | 1986 | VIERZON NATATION | FRA | 1:01:99 | 1122 | Interregional |
7 | NONIN Laura | 1993 | CN CHALON-SUR-SAONE | FRA | 1:02:60 | 1103 | National |
8 | DEPAIX Juliette | 1992 | NAUTIQUE ENTENTE CHÂLONS | FRA | 1:02:74 | 1098 | National |
9 | ESCOUTE Camille | 1991 | AS HERBLAY NATATION | FRA | 1:02:96 | 1091 | National |
10 | DOCQUIN Alice | 1990 | CHARLEVILLE-MÉZIÈRES NATATION | FRA | 1:03:11 | 1087 | Interregional |
11 | BROCHARD Sarah | 1991 | CLUB AQUATIQUE CHOLETAIS | FRA | 1:03:32 | 1080 | Interregional |
12 | LEBON Laura | 1992 | AS EMERAINVILLE | FRA | 1:03:33 | 1080 | National |
13 | MALARME Delphine | 1992 | DAUPHINS OBERNAI | FRA | 1:03:51 | 1075 | National |
14 | LAGENETTE Audrey | 1991 | SB BORDEAUX BASTIDE | FRA | 1:03:55 | 1073 | Interregional |
15 | NAIT BOUDA Sophia | 1991 | ES NANTERRE | FRA | 1:03:61 | 1072 | Interregional |
16 | LIZON AU CIRE Daphné | 1990 | ALLIANCE DIJON NATATION | FRA | 1:03:64 | 1071 | Interregional |
17 | MENENDEZ Pauline | 1992 | CN CHALON-SUR-SAONE | FRA | 1:03:84 | 1065 | National |
18 | DIDIER Elodie | 1991 | LYON NATATION | FRA | 1:04:01 | 1059 | Interregional |
19 | VOILLY Alice | 1991 | AUXERRE AQUATIC CLUB | FRA | 1:04:04 | 1059 | Interregional |
20 | ADAM BRUCKER Charlène | 1992 | VAGUE BETSCHDORF-DRACHENBRONN | FRA | 1:04:21 | 1053 | Interregional |
21 | BAOUDOUR Estelle | 1986 | MONTCHANIN NATATION | FRA | 1:04:30 | 1051 | Regional |
22 | ORIGAS Anaïs | 1988 | AQUAVALLÉES NATATION CLUB | FRA | 1:04:38 | 1048 | Interregional |
23 | DOUET Aurélie | 1989 | EN TOURS | FRA | 1:04:79 | 1036 | Interregional |
24 | HOULGARD Anne | 1988 | AS AVRILLÉ NATATION | FRA | 1:05:11 | 1026 | Interregional |
Nom | Année | Club | Pays | Temps | Points | Niv. | |
---|---|---|---|---|---|---|---|
1 | PATRIE Nolwenn | 1993 | SO ROSNY | FRA | 1:04:16 | 1055 | National |
2 | BABOIN Lucille | 1993 | AQUATIC CLUB BOURGES | FRA | 1:04:77 | 1037 | National |
3 | WEBER Fanny | 1992 | ERSTEIN AQUATIC CLUB | FRA | 1:05:13 | 1026 | Interregional |
4 | JATTEAU Pauline | 1993 | SENS NATATION | FRA | 1:05:18 | 1024 | National |
5 | BARTHEL Mélanie | 1993 | CN VAL DE FENSCH SERÉMANGE | FRA | 1:05:49 | 1015 | National |
6 | MONNET Patricia | 1992 | CA ORSAY | FRA | 1:05:63 | 1011 | Interregional |
7 | PAILLOT Cyrielle | 1992 | VILLERUPT NATATION | FRA | 1:05:84 | 1005 | Interregional |
8 | BOUCHARDY Julia | 1993 | CN BOURG-EN-BRESSE | FRA | 1:06:24 | 993 | Interregional |
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`sous_domaine` = 'abcnatation.fr' LIMIT 1 | 0 | 0 | 0 | |
2 | SELECT `Clubs`.`id`, `Clubs`.`statut`, `Clubs`.`abonne_depuis`, `Clubs`.`name`, `Clubs`.`name_officiel`, `Clubs`.`offre_v2`, `Clubs`.`siret`, `Clubs`.`cnil`, `Clubs`.`agrement`, `Clubs`.`code_parrain`, `Clubs`.`nation`, `Clubs`.`correspondant_licencie_id`, `Clubs`.`scf_structure_type_id`, `Clubs`.`scf_structure_statut_id`, `Clubs`.`sport_id`, `Clubs`.`profil_id`, `Clubs`.`coordonnee_id`, `Clubs`.`departement_id`, `Clubs`.`region_id`, `Clubs`.`correspondant`, `Clubs`.`content_id`, `Clubs`.`content_type_id`, `Clubs`.`maj_ffn`, `Clubs`.`maj_csv`, `Clubs`.`logo_upload`, `Clubs`.`signature_upload`, `Clubs`.`site_web`, `Clubs`.`sous_domaine`, `Clubs`.`assurance`, `Clubs`.`label`, `Clubs`.`email`, `Clubs`.`email_webmaster`, `Clubs`.`email_expediteur`, `Clubs`.`option_membre_illimite`, `Clubs`.`option_scoring_pro`, `Clubs`.`option_inscriptions`, `Clubs`.`option_convocations`, `Clubs`.`option_domaine`, `Clubs`.`date_fin_membre_illimite`, `Clubs`.`date_fin_scoring_pro`, `Clubs`.`date_fin_inscriptions`, `Clubs`.`date_fin_convocations`, `Clubs`.`date_fin_option_domaine`, `Clubs`.`date_fin_site_web`, `Clubs`.`forcer_recevoir_news`, `Clubs`.`IdCISS`, `Clubs`.`PassCISS`, `Clubs`.`idWallet`, `Clubs`.`url_swimcommunity`, `Clubs`.`activer_sc`, `Clubs`.`activer_pagesc`, `Clubs`.`txtbtn_swimcommunity`, `Clubs`.`h1_sc`, `Clubs`.`page1_swimcommunity`, `Clubs`.`page2_swimcommunity` FROM `abcnatation-fr`.`clubs` AS `Clubs` WHERE `Clubs`.`id` IS NULL LIMIT 1 | 0 | 0 | 5 | |
3 | SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC | 9 | 9 | 0 | |
4 | SELECT `SiteWeb`.`id`, `SiteWeb`.`club_id`, `SiteWeb`.`statut`, `SiteWeb`.`url_bandeau`, `SiteWeb`.`msg_bandeau`, `SiteWeb`.`saison_id`, `SiteWeb`.`degroupe_menu_activite`, `SiteWeb`.`degroupe_menu_evenements`, `SiteWeb`.`degroupe_menu_commissions`, `SiteWeb`.`actualites`, `SiteWeb`.`cache_auteur_actu`, `SiteWeb`.`cache_pictos_menu`, `SiteWeb`.`cache_accueil`, `SiteWeb`.`cache_email`, `SiteWeb`.`publication`, `SiteWeb`.`cache_email_web`, `SiteWeb`.`nom_medias`, `SiteWeb`.`widget_part`, `SiteWeb`.`widget_part_top_position`, `SiteWeb`.`widget_photos`, `SiteWeb`.`widget_res`, `SiteWeb`.`widget_pages`, `SiteWeb`.`widget_cal`, `SiteWeb`.`widget_act`, `SiteWeb`.`gestion_droits`, `SiteWeb`.`boutique`, `SiteWeb`.`forcer_recevoir_news`, `SiteWeb`.`flickr_user_id`, `SiteWeb`.`template`, `SiteWeb`.`recaptcha`, `SiteWeb`.`meta_description` FROM `abcnatation-fr`.`site_webs` AS `SiteWeb` WHERE `SiteWeb`.`club_id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
5 | SELECT `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 1 | 1 | 1 | 0 | |
6 | SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '160571523' AND `Content`.`content_type_id` = 7 ORDER BY `Content`.`position` ASC | 0 | 0 | 0 | |
7 | SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`id` = '160571523' LIMIT 1 | 1 | 1 | 0 | |
8 | SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('160571523') | 0 | 0 | 0 | |
9 | SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '160571523' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) | 0 | 0 | 0 | |
10 | SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`id` = '160571523' LIMIT 1 | 1 | 1 | 0 | |
11 | SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('160571523') | 0 | 0 | 0 | |
12 | SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '160571523' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) | 0 | 0 | 0 | |
13 | SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`id` = '160571523' LIMIT 1 | 1 | 1 | 0 | |
14 | SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('160571523') | 0 | 0 | 0 | |
15 | SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '160571523' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) | 0 | 0 | 0 | |
16 | SELECT `SiteWeb`.`id`, `SiteWeb`.`club_id`, `SiteWeb`.`statut`, `SiteWeb`.`url_bandeau`, `SiteWeb`.`msg_bandeau`, `SiteWeb`.`saison_id`, `SiteWeb`.`degroupe_menu_activite`, `SiteWeb`.`degroupe_menu_evenements`, `SiteWeb`.`degroupe_menu_commissions`, `SiteWeb`.`actualites`, `SiteWeb`.`cache_auteur_actu`, `SiteWeb`.`cache_pictos_menu`, `SiteWeb`.`cache_accueil`, `SiteWeb`.`cache_email`, `SiteWeb`.`publication`, `SiteWeb`.`cache_email_web`, `SiteWeb`.`nom_medias`, `SiteWeb`.`widget_part`, `SiteWeb`.`widget_part_top_position`, `SiteWeb`.`widget_photos`, `SiteWeb`.`widget_res`, `SiteWeb`.`widget_pages`, `SiteWeb`.`widget_cal`, `SiteWeb`.`widget_act`, `SiteWeb`.`gestion_droits`, `SiteWeb`.`boutique`, `SiteWeb`.`forcer_recevoir_news`, `SiteWeb`.`flickr_user_id`, `SiteWeb`.`template`, `SiteWeb`.`recaptcha`, `SiteWeb`.`meta_description` FROM `abcnatation-fr`.`site_webs` AS `SiteWeb` WHERE `SiteWeb`.`club_id` = '160571523' LIMIT 1 | 0 | 0 | 0 | |
17 | SELECT `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` = '2826' LIMIT 1 | 1 | 1 | 1 | |
18 | SELECT `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` = ('2826') | 0 | 0 | 3 | |
19 | SELECT `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` = 2 LIMIT 1 | 1 | 1 | 0 | |
20 | SELECT `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` = '2826' AND `ScfEpreuveType`.`id` = 2 ORDER BY `ScfEpreuveFormat`.`position` ASC, `ScResultat`.`points` DESC, `ScResultat`.`swimtime` ASC | 133 | 133 | 14 | |
21 | SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`menu_id` = '1' AND `Content`.`etat_id` = '1' AND `Content`.`content_type_id` IN (1, 2, 3, 4) ORDER BY `lft` ASC | 368 | 368 | 1 | |
22 | SELECT `Content`.`lft`, `Content`.`rght` FROM `abcnatation-fr`.`contents` AS `Content` WHERE `Content`.`id` = '' LIMIT 1 | 0 | 0 | 7 | |
23 | SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`content_type_id` IN (1, 2, 3, 4) AND `Content`.`menu_id` = '1' AND `Content`.`etat_id` = '1' AND `Content`.`parent_id` IS NULL ORDER BY `Content`.`lft` ASC | 350 | 350 | 1 | |
24 | SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`content_types` AS `ContentType` WHERE 1 = 1 | 10 | 10 | 0 |