Championnats de France d'hiver des Maîtres (25m)

Nationale

PARIS

Du Jeudi 27 Mars 2014 au Dimanche 30 Mars 2014

Bassin de 25m

200 4 Nages Messieurs

Séries

Nom Année Club Pays Temps Points Niv.
1 VETTER Pierre 1987 GIRONDINS BORDEAUX FRA 2:04:57 1291
2 CADIAT Jean Marie 1953 BELGIQUE BEL 2:35:52 1240
3 CHALENDAR Lionel 1967 ES NANTERRE FRA 2:17:57 1222
4 DE BATTISTI Stéphane 1978 LYON NATATION FRA 2:12:85 1201
5 LAFFICHE Gilles 1959 ES NANTERRE FRA 2:30:43 1198
6 PAILLIEZ Lionel 1957 ES NANTERRE FRA 2:31:59 1182
7 BURGHGRAEVE Yannick 1974 CN MARSEILLE FRA 2:17:12 1174
8 VANACKER Alain 1952 USM MALAKOFF FRA 2:40:63 1174
9 LEGRUX Alain 1948 PAULIGNAN MINERVOIS NATATION FRA 2:52:24 1166
10 LANGOT Jérémy 1985 CN CACHAN FRA 2:13:32 1151
11 FERANDO Julien 1971 CN MARSEILLE FRA 2:18:82 1149
12 FERRY Benoît 1982 REIMS AVENIR NATATION FRA 2:14:70 1146
13 LEONARDI Damien 1974 ES NANTERRE FRA 2:19:55 1138
14 VOEGTLIN Wilfried 1983 GIRONDINS BORDEAUX FRA 2:15:59 1133
15 LE BRAS Julien 1983 CERCLE DES NAGEURS DE TALENCE FRA 2:15:77 1130
16 BOIRON BOIREL Fabien 1984 EMS BRON FRA 2:15:93 1128
17 LECORNU Eric 1962 NC BRIANÇON FRA 2:29:37 1123
18 ESTIVAL Antoine 1985 SB BORDEAUX BASTIDE FRA 2:15:43 1119
19 MEHR Jean-Nicolas 1986 NEPTUNE CLUB DE FRANCE FRA 2:15:63 1116
20 NIVELET Arnaud 1973 NEPTUNE CLUB DE FRANCE FRA 2:21:11 1115
21 THIBAUD Benoit 1980 EN CAEN FRA 2:17:58 1103
22 SIBIRIL Laurent 1976 STADE FRANÇAIS O COURBEVOIE FRA 2:19:82 1096
23 DUDOUET Franck 1978 CLUB DES NAGEURS DE PARIS FRA 2:19:97 1094
24 GOLL Alain 1971 MARCQ NATATION FRA 2:22:90 1089
25 ROMERA Frederic 1976 EMS BRON FRA 2:20:46 1086
26 CALARNOU Christophe 1988 DOUARNENEZ NATATION FRA 2:17:99 1080
27 DROGUET Martial 1967 A. NAUTIQUE PAYS DE MONCONTOUR FRA 2:27:52 1078
28 GRABSKI Gilles 1977 CA PIERRELATTE ASCEAC FRA 2:21:09 1077
29 MANAI Waël 1982 USM MALAKOFF FRA 2:19:44 1075
30 HERVIO Cédric 1982 NANTES NATATION FRA 2:19:65 1072
31 MARTY Romain 1974 CLUB AQUATIQUE CHOLETAIS FRA 2:24:07 1072
32 STARZEC Bruno 1981 ASPTT GRAND TOULOUSE FRA 2:20:23 1063
33 RAYNIERE Thierry 1961 LAVAL AQUATIQUE CLUB FRA 2:33:90 1061
34 ZAWISKA Nicolas 1988 CN COURRIÈRES FRA 2:19:40 1059
35 DEWILDE Stéphane 1973 CN COURRIÈRES FRA 2:25:78 1048
36 LEBLOND Vincent 1986 STADE OLYMPIQUE CHAMBÉRY FRA 2:20:30 1046
37 EBY Olivier 1974 DAUPHINS DE ST-LOUIS FRA 2:25:86 1046
38 POTHIER Erwan 1973 MARTIGUES NATATION FRA 2:26:28 1040
39 HERVE Patrick 1949 SN FRANCONVILLE FRA 3:03:76 1032
40 MICHEL Georges 1949 MONTPELLIER ANUC FRA 3:04:43 1024
41 DESANA Javier 1972 PAYS DE GEX NATATION FRA 2:27:67 1021
42 RECOULES Christophe 1963 AAS SARCELLES NATATION 95 FRA 2:37:06 1019
43 BONIN Yann-Eric 1975 MARTIGUES NATATION FRA 2:25:27 1017
44 AZOUAGH Sid-Ali 1977 AUXERRE AQUATIC CLUB FRA 2:25:29 1016
45 GROHEUX David 1983 SCUF PARIS FRA 2:23:60 1014
46 ALECHINSKY Marc 1989 USM MALAKOFF FRA 2:23:03 1006
47 NODENSCHNEIDER Erwin 1936 CN BERGERAC FRA 3:41:21 1006
48 CADILHON Baptiste 1981 AS LA TESTE FRA 2:24:37 1003
49 BAGUET Sébastien 1977 EMS BRON FRA 2:26:26 1003
50 LORA RUNCO Marc 1963 SEYNOD NATATION FRA 2:38:28 1003
51 POPOT Xavier 1968 NAUTIC CLUB VOVES FRA 2:33:33 998
52 COCHENNEC Morgan 1979 CN CACHAN FRA 2:26:90 994
53 HOLDERBACH Olivier 1982 SN VERSAILLES FRA 2:25:77 983
54 SHIMANOVSKIY Sergey 1954 RUSSIE RUS 2:56:29 981
55 RENAUDIE François 1952 BORDEAUX ÉTUDIANTS CLUB FRA 2:56:38 980
56 LENCHITSKIY Vladimir 1962 RUSSIE RUS 2:40:48 974
57 DEVOS Nicolas 1984 LAVAUR NATATION 81 FRA 2:26:49 973
58 DUCHER Lionel 1978 CLUB DES NAGEURS DE BRIVE FRA 2:28:48 971
59 AESCHLIMANN Pierre 1988 CN VIRY-CHÂTILLON FRA 2:25:54 970
60 ALLERY Jean-Pascal 1965 ASPTT POITIERS FRA 2:35:42 970
61 HENCK Laurent 1982 DAUPHINS DE ST-LOUIS FRA 2:26:84 968
62 VIDIL Henri 1941 CN MARSEILLE FRA 3:25:07 968
63 BROCHEN Yann 1981 GIRONDINS BORDEAUX FRA 2:26:98 966
64 LEMAIRE Olivier 1959 LAVAL AQUATIQUE CLUB FRA 2:48:54 963
65 DE BAZELAIRE Patrick 1946 LÉO-L. SCHILTIGHEIM-BISCHHEIM FRA 3:10:13 961
66 BOURGEOIS Stéphane 1979 CN DOLE & REG FRA 2:29:93 951
67 LECACHEUX Bruno 1970 AS CHERBOURG NATATION FRA 2:32:75 951
68 JUGUET Nicolas 1981 TOULOUSE OLYMPIQUE AÉRO FRA 2:28:25 948
69 DANDINE François 1986 ALLIANCE DIJON NATATION FRA 2:27:29 945
70 COTINEAU David 1974 A.S GOURNAISIENNE FRA 2:33:28 944
71 PRETE Stéphane 1969 JEANNE D'ARC DRANCY FRA 2:37:63 941
72 GUILLARD Alexis 1988 USM VIROFLAY FRA 2:27:74 939
73 FAUCHARD Frédéric 1967 AS CHERBOURG NATATION FRA 2:37:81 938
74 LAMBERT Jérémy 1983 RHODIA CLUB NATATION FRA 2:29:30 934
75 ARLON Jean-Christophe 1973 CNS VALLAURIS FRA 2:34:00 934
76 BUHOT Sylvain 1980 REIMS CHAMPAGNE NATATION FRA 2:29:33 933
77 MIRONNET Gaetan 1976 A. NAUTIQUE PAYS DE MONCONTOUR FRA 2:32:02 923
78 LALANNE Laurent 1973 CN CAMBRAI FRA 2:34:84 923
79 QUERIN Guillaume 1981 TOULOUSE OLYMPIQUE AÉRO FRA 2:30:96 911
80 NICOLAS Vincent 1970 AS LA TESTE FRA 2:36:19 905
81 BRAHIM Lionel 1971 CN VIRY-CHÂTILLON FRA 2:36:77 897
82 MORVAN Hélouri 1984 ALLIANCE ORLEANS NATATION FRA 2:32:20 894
83 DROUILLET Laurent 1966 AMICALE CREIL NATATION FRA 2:41:45 891
84 DEISS Roland 1981 RED STAR CLUB CHAMPIGNY FRA 2:32:51 890
85 PELET Eric 1953 SC THIONVILLE FRA 3:04:34 889
86 MARON Bruno 1979 VILLEURBANNE NATATION FRA 2:35:17 880
87 PENET Benoît 1983 DAUPHINS ROMANS PÉAGOIS FRA 2:33:29 879
88 BLANC Patrick 1960 CA L'HAY-LES-ROSES FRA 2:48:17 878
89 VENDAS Laurent 1973 AS CALUIRE FRA 2:38:64 873
90 DUBUISSON Frédéric 1976 RED STAR CLUB CHAMPIGNY FRA 2:36:92 857
91 TUTIN Michael 1984 CS LES LILAS NATATION FRA 2:35:00 856
92 LAMMENS Laurent 1965 JEANNE D'ARC EAUBONNE FRA 2:44:66 851
93 PERROT Jean-Michel 1945 NAUTIC CLUB NÎMES FRA 3:20:86 848
94 JOURDE Raphael 1971 CN DOULLENS FRA 2:40:69 847
95 FANTHOMME Eric 1959 CS LES LILAS NATATION FRA 2:58:45 845
96 SEVILLANO Bruno 1968 CN PACY ET ENVIRONS FRA 2:45:19 844
97 CHEVALLIER Philippe 1964 USC CONFLANS-STE-HONORINE FRA 2:51:35 839
98 GALEA Xavier 1971 BEAUVAISIS AQUATIC CLUB FRA 2:41:62 835
99 SCHWING Patrick 1958 CN VIRY-CHÂTILLON FRA 2:59:55 832
100 MARTY Joël 1944 CLUB AQUATIQUE CHOLETAIS FRA 3:39:20 831
101 LEDIEU Xavier 1981 CLUB DES NAGEURS DE PARIS FRA 2:37:09 829
102 MACOCCO Patrick 1978 CS LES LILAS NATATION FRA 2:39:10 829
103 GAGNAIRE Thierry 1965 SN VERSAILLES FRA 2:46:55 828
104 HAMARD Thierry 1971 MARSOUINS HÉROUVILLE FRA 2:42:38 825
105 NAHON Bruno 1970 BELGIQUE BEL 2:42:77 820
106 DELAVEAU Marc 1968 ST-NAZAIRE ATLANTIQUE NATATION FRA 2:47:84 812
107 PERNET Fabrice 1974 CN BREST FRA 2:43:53 811
108 BOUDET Nicolas 1984 TOULOUSE OLYMPIQUE AÉRO FRA 2:38:97 805
109 FOURNIER Richard 1966 ASPTT GRAND TOULOUSE FRA 2:48:55 803
110 RONGIERAS Xavier 1979 VILLEURBANNE NATATION FRA 2:41:41 800
111 KOITKA Thierry 1973 CN COURRIÈRES FRA 2:44:65 797
112 SCHWEITZER Laurent 1971 ESPADON BRÉTIGNY-SUR-ORGE FRA 2:45:07 791
113 LONNE Jean 1942 BORDEAUX ÉTUDIANTS CLUB FRA 3:44:59 781
114 SELWIET Bernard 1969 CN COUTANCES FRA 2:50:84 776
115 HERENT Jean-Marc 1960 SN MONTGERON FRA 2:56:93 774
116 CRISPIN Eric 1957 CN LE MANS FRA 3:05:05 771
117 CIMA Roland 1949 SAINT-RAPHAEL NATATION FRA 3:28:63 771
118 PEREIRA Ricardo 1975 CLUB DES NAGEURS DE PARIS FRA 2:44:03 767
119 ROUILLERE Mickaël 1974 CLUB AQUATIQUE CHOLETAIS FRA 2:47:16 766
120 BEAUDET Michel 1963 DAUPHINS ST-OMER FRA 2:57:60 766
121 BOREL Jérôme 1973 AN ROMORANTIN FRA 2:47:39 763
122 BELLOEIL Marc 1966 NEPTUNE CLUB DE FRANCE FRA 2:55:43 722
123 BALLEREAU Philippe 1960 CLUB DES NAGEURS DE PARIS FRA 3:01:58 721
124 CAULET Philippe 1966 SN VERSAILLES FRA 2:56:48 710
125 MASSON Raphael 1969 NANTES NATATION FRA 2:57:19 702
126 MARCHAND Olivier 1964 DAUPHINS ROMANS PÉAGOIS FRA 3:04:65 688
127 MATHIEU Philippe 1964 AVAN VILLENEUVE-D'ASCQ FRA 3:05:97 673
128 ROCHET Pascal 1960 ST-ETIENNE NATATION FRA 3:06:99 662
129 ANDRIEU Yves 1932 AQUATIC CLUB BOURGES FRA 4:54:46 650
130 LALOT Eric 1960 ASPTT ORLÉANS FRA 3:08:63 645
131 QUIRIN Patrick 1955 AMICALE CREIL NATATION FRA 3:18:88 626
132 RICORDEAU Luc 1941 SC ORVAULT FRA 4:10:28 566
133 PUICHAFRAY Jean-Marie 1943 EN STE-GENEVIÈVE-DES-BOIS FRA 4:29:56 427
134 CORNET Cyril 1983 STADE FRANÇAIS O COURBEVOIE FRA - Disq.
135 GRUAT Gilles 1976 AS LA TESTE FRA - Disq.
136 TURAN Eric 1954 NANTES NATATION FRA - Disq.
137 PIMOT Christopher 1982 STADE FRANÇAIS O COURBEVOIE FRA - Disq.
138 HASSON Jascha 1971 NOGENT NATATION 94 FRA - Disq.
139 COLLIGNON Hervé 1966 CHAMALIERES-MONTFERRAND N FRA - Disq.
140 AUGE Jérôme 1967 EMS BRON FRA - Disq.
141 ANSART Frédéric 1978 MARCQ NATATION FRA - Disq.
142 VARGA Louis 1965 AC MOLSHEIM MUTZIG FRA - Disq.
143 ROBLIN François 1956 CHARTRES METROPOLE NAT FRA - Disq.
144 BERSENEV Eduard 1956 RUSSIE RUS - Disq.
145 TROYAS Michel 1978 STADE FRANÇAIS O COURBEVOIE FRA - Disq.
(default) 24 queries took 19 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 1000
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 1000
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` ASC000
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 1110
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 1110
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` = '20450' LIMIT 1110
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` = ('20450') 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` = 91 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` = '20450' AND `ScfEpreuveType`.`id` = 91 ORDER BY `ScfEpreuveFormat`.`position` ASC, `ScResultat`.`points` DESC, `ScResultat`.`swimtime` ASC14514517
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