9e Meeting National de Chartres Métropole Natation

Compétition Nationale en bassin de 50m

Du Vendredi 08 Fevrier 2019 au Dimanche 10 Fevrier 2019 à CHARTRES

Meilleurs performers du club

  Nom Points Epreuve Temps
1 Tiphaine LEBLOND 1145 pts 100 Brasse Dames 1:14:49
2 Charlotte PACOURET 1122 pts 100 Nage Libre Dames 0:59:64
3 Salomé BOTAS 1085 pts 100 Dos Dames 1:07:79
4 Margaux HOCQUARD 1002 pts 100 Dos Dames 1:11:00

Podiums du club

1 médailles d’or
2 médailles argent
1 médailles de bronze

Nageurs du club par catégorie

1 Cadets 25%
1 Juniors 25%
2 Seniors 50%

Chiffres clés

4 Nombre de nageurs représentant le club (sur 551)
3 Nombre d'épreuves comprenant des nageurs du club (sur 34)
15 Nombre de performances réalisées par des nageurs du club (sur 3089)
Notice (8): Undefined index: SiteWeb [APP/Plugin/SiteClub/View/Layouts/default.ctp, line 340]
RED STAR CLUB CHAMPIGNY
(default) 260 queries took 1483 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`id` = '130943032' LIMIT 1111
2SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('130943032') 330
3SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '130943032' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 45451
4SELECT `Clubs`.`id`, `Clubs`.`statut`, `Clubs`.`abonne_depuis`, `Clubs`.`name`, `Clubs`.`name_officiel`, `Clubs`.`offre_v2`, `Clubs`.`siret`, `Clubs`.`cnil`, `Clubs`.`agrement`, `Clubs`.`code_parrain`, `Clubs`.`nation`, `Clubs`.`correspondant_licencie_id`, `Clubs`.`scf_structure_type_id`, `Clubs`.`scf_structure_statut_id`, `Clubs`.`sport_id`, `Clubs`.`profil_id`, `Clubs`.`coordonnee_id`, `Clubs`.`departement_id`, `Clubs`.`region_id`, `Clubs`.`correspondant`, `Clubs`.`content_id`, `Clubs`.`content_type_id`, `Clubs`.`maj_ffn`, `Clubs`.`maj_csv`, `Clubs`.`logo_upload`, `Clubs`.`signature_upload`, `Clubs`.`site_web`, `Clubs`.`sous_domaine`, `Clubs`.`assurance`, `Clubs`.`label`, `Clubs`.`email`, `Clubs`.`email_webmaster`, `Clubs`.`email_expediteur`, `Clubs`.`option_membre_illimite`, `Clubs`.`option_scoring_pro`, `Clubs`.`option_inscriptions`, `Clubs`.`option_convocations`, `Clubs`.`option_domaine`, `Clubs`.`date_fin_membre_illimite`, `Clubs`.`date_fin_scoring_pro`, `Clubs`.`date_fin_inscriptions`, `Clubs`.`date_fin_convocations`, `Clubs`.`date_fin_option_domaine`, `Clubs`.`date_fin_site_web`, `Clubs`.`forcer_recevoir_news`, `Clubs`.`IdCISS`, `Clubs`.`PassCISS`, `Clubs`.`idWallet`, `Clubs`.`url_swimcommunity`, `Clubs`.`activer_sc`, `Clubs`.`activer_pagesc`, `Clubs`.`txtbtn_swimcommunity`, `Clubs`.`h1_sc`, `Clubs`.`page1_swimcommunity`, `Clubs`.`page2_swimcommunity` FROM `abcnatation-fr`.`clubs` AS `Clubs` WHERE `Clubs`.`id` IS NULL LIMIT 1000
5SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC990
6SELECT `SiteWeb`.`id`, `SiteWeb`.`club_id`, `SiteWeb`.`statut`, `SiteWeb`.`url_bandeau`, `SiteWeb`.`msg_bandeau`, `SiteWeb`.`saison_id`, `SiteWeb`.`degroupe_menu_activite`, `SiteWeb`.`degroupe_menu_evenements`, `SiteWeb`.`degroupe_menu_commissions`, `SiteWeb`.`actualites`, `SiteWeb`.`cache_auteur_actu`, `SiteWeb`.`cache_pictos_menu`, `SiteWeb`.`cache_accueil`, `SiteWeb`.`cache_email`, `SiteWeb`.`publication`, `SiteWeb`.`cache_email_web`, `SiteWeb`.`nom_medias`, `SiteWeb`.`widget_part`, `SiteWeb`.`widget_part_top_position`, `SiteWeb`.`widget_photos`, `SiteWeb`.`widget_res`, `SiteWeb`.`widget_pages`, `SiteWeb`.`widget_cal`, `SiteWeb`.`widget_act`, `SiteWeb`.`gestion_droits`, `SiteWeb`.`boutique`, `SiteWeb`.`forcer_recevoir_news`, `SiteWeb`.`flickr_user_id`, `SiteWeb`.`template`, `SiteWeb`.`recaptcha`, `SiteWeb`.`meta_description` FROM `abcnatation-fr`.`site_webs` AS `SiteWeb` WHERE `SiteWeb`.`club_id` IS NULL LIMIT 1000
7SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE `date_debut` <= '2019-12-07' AND `date_fin` > '2019-12-07' LIMIT 1110
8SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE ((`Club`.`sous_domaine` = '130943032') OR (`Club`.`id` = '130943032')) LIMIT 1111
9SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('130943032') 330
10SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '130943032' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 45450
11SELECT `Clubs`.`id`, `Clubs`.`statut`, `Clubs`.`abonne_depuis`, `Clubs`.`name`, `Clubs`.`name_officiel`, `Clubs`.`offre_v2`, `Clubs`.`siret`, `Clubs`.`cnil`, `Clubs`.`agrement`, `Clubs`.`code_parrain`, `Clubs`.`nation`, `Clubs`.`correspondant_licencie_id`, `Clubs`.`scf_structure_type_id`, `Clubs`.`scf_structure_statut_id`, `Clubs`.`sport_id`, `Clubs`.`profil_id`, `Clubs`.`coordonnee_id`, `Clubs`.`departement_id`, `Clubs`.`region_id`, `Clubs`.`correspondant`, `Clubs`.`content_id`, `Clubs`.`content_type_id`, `Clubs`.`maj_ffn`, `Clubs`.`maj_csv`, `Clubs`.`logo_upload`, `Clubs`.`signature_upload`, `Clubs`.`site_web`, `Clubs`.`sous_domaine`, `Clubs`.`assurance`, `Clubs`.`label`, `Clubs`.`email`, `Clubs`.`email_webmaster`, `Clubs`.`email_expediteur`, `Clubs`.`option_membre_illimite`, `Clubs`.`option_scoring_pro`, `Clubs`.`option_inscriptions`, `Clubs`.`option_convocations`, `Clubs`.`option_domaine`, `Clubs`.`date_fin_membre_illimite`, `Clubs`.`date_fin_scoring_pro`, `Clubs`.`date_fin_inscriptions`, `Clubs`.`date_fin_convocations`, `Clubs`.`date_fin_option_domaine`, `Clubs`.`date_fin_site_web`, `Clubs`.`forcer_recevoir_news`, `Clubs`.`IdCISS`, `Clubs`.`PassCISS`, `Clubs`.`idWallet`, `Clubs`.`url_swimcommunity`, `Clubs`.`activer_sc`, `Clubs`.`activer_pagesc`, `Clubs`.`txtbtn_swimcommunity`, `Clubs`.`h1_sc`, `Clubs`.`page1_swimcommunity`, `Clubs`.`page2_swimcommunity` FROM `abcnatation-fr`.`clubs` AS `Clubs` WHERE `Clubs`.`id` IS NULL LIMIT 1000
12SELECT `SiteWeb`.`id`, `SiteWeb`.`club_id`, `SiteWeb`.`statut`, `SiteWeb`.`url_bandeau`, `SiteWeb`.`msg_bandeau`, `SiteWeb`.`saison_id`, `SiteWeb`.`degroupe_menu_activite`, `SiteWeb`.`degroupe_menu_evenements`, `SiteWeb`.`degroupe_menu_commissions`, `SiteWeb`.`actualites`, `SiteWeb`.`cache_auteur_actu`, `SiteWeb`.`cache_pictos_menu`, `SiteWeb`.`cache_accueil`, `SiteWeb`.`cache_email`, `SiteWeb`.`publication`, `SiteWeb`.`cache_email_web`, `SiteWeb`.`nom_medias`, `SiteWeb`.`widget_part`, `SiteWeb`.`widget_part_top_position`, `SiteWeb`.`widget_photos`, `SiteWeb`.`widget_res`, `SiteWeb`.`widget_pages`, `SiteWeb`.`widget_cal`, `SiteWeb`.`widget_act`, `SiteWeb`.`gestion_droits`, `SiteWeb`.`boutique`, `SiteWeb`.`forcer_recevoir_news`, `SiteWeb`.`flickr_user_id`, `SiteWeb`.`template`, `SiteWeb`.`recaptcha`, `SiteWeb`.`meta_description` FROM `abcnatation-fr`.`site_webs` AS `SiteWeb` WHERE `SiteWeb`.`club_id` = '130943032' LIMIT 1110
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` = '130943032' LIMIT 1110
14SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('130943032') 330
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` = '130943032' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 45450
16SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`club_inscription_parametres` AS `ClubInscriptionParametre` WHERE `ClubInscriptionParametre`.`club_id` = '130943032' AND `ClubInscriptionParametre`.`activer` = '1'111
17SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`club_inscription_parametres` AS `ClubInscriptionParametre` WHERE `ClubInscriptionParametre`.`club_id` = '130943032' AND `ClubInscriptionParametre`.`activer_reinscriptions` = '1'111
18SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '130943032' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = '' ORDER BY `Content`.`position` ASC771
19SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '130943032' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'boutique' ORDER BY `Content`.`position` ASC001
20SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '130943032' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'partenaire' ORDER BY `Content`.`position` ASC001
21SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '130943032' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'footer' ORDER BY `Content`.`position` ASC001
22SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '130943032' AND ((`Content`.`content_type_id` = 7) OR (`Content`.`content_type_id` = 10)) AND `ClubPage`.`menu` = 'home' ORDER BY `Content`.`position` ASC15151
23SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '130943032' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'activite' ORDER BY `Content`.`position` ASC331
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 `ContentType`.`id` = 7 110
25SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 7 110
26SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 7 110
27SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 3414 000
28SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 43740 000
29SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 3425 000
30SELECT `MentionsLegale`.`id`, `MentionsLegale`.`content_type_id`, `MentionsLegale`.`content_id`, `MentionsLegale`.`adresse_site_web`, `MentionsLegale`.`raison_sociale`, `MentionsLegale`.`forme_juridique`, `MentionsLegale`.`num_siren`, `MentionsLegale`.`code_naf`, `MentionsLegale`.`adresse_siege`, `MentionsLegale`.`responsable_publication`, `MentionsLegale`.`num_cnil`, `MentionsLegale`.`webmaster`, `MentionsLegale`.`createur`, `MentionsLegale`.`hebergeur` FROM `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` WHERE `MentionsLegale`.`content_id` = 3414 000
31SELECT `MentionsLegale`.`id`, `MentionsLegale`.`content_type_id`, `MentionsLegale`.`content_id`, `MentionsLegale`.`adresse_site_web`, `MentionsLegale`.`raison_sociale`, `MentionsLegale`.`forme_juridique`, `MentionsLegale`.`num_siren`, `MentionsLegale`.`code_naf`, `MentionsLegale`.`adresse_siege`, `MentionsLegale`.`responsable_publication`, `MentionsLegale`.`num_cnil`, `MentionsLegale`.`webmaster`, `MentionsLegale`.`createur`, `MentionsLegale`.`hebergeur` FROM `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` WHERE `MentionsLegale`.`content_id` = 43740 000
32SELECT `MentionsLegale`.`id`, `MentionsLegale`.`content_type_id`, `MentionsLegale`.`content_id`, `MentionsLegale`.`adresse_site_web`, `MentionsLegale`.`raison_sociale`, `MentionsLegale`.`forme_juridique`, `MentionsLegale`.`num_siren`, `MentionsLegale`.`code_naf`, `MentionsLegale`.`adresse_siege`, `MentionsLegale`.`responsable_publication`, `MentionsLegale`.`num_cnil`, `MentionsLegale`.`webmaster`, `MentionsLegale`.`createur`, `MentionsLegale`.`hebergeur` FROM `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` WHERE `MentionsLegale`.`content_id` = 3425 000
33SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 3414 000
34SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 43740 000
35SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 3425 000
36SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 3414 000
37SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 43740 000
38SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 3425 000
39SELECT `MediaManagerMedia`.`id`, `MediaManagerMedia`.`content_type_id`, `MediaManagerMedia`.`media_type_id`, `MediaManagerMedia`.`content_id`, `MediaManagerMedia`.`local`, `MediaManagerMedia`.`extention`, `MediaManagerMedia`.`poids`, `MediaManagerMedia`.`nom_fichier`, `MediaManagerMedia`.`nom`, `MediaManagerMedia`.`dossier`, `MediaManagerMedia`.`code_embed` FROM `abcnatation-fr`.`media` AS `MediaManagerMedia` WHERE `MediaManagerMedia`.`content_id` = 3414 000
40SELECT `MediaManagerMedia`.`id`, `MediaManagerMedia`.`content_type_id`, `MediaManagerMedia`.`media_type_id`, `MediaManagerMedia`.`content_id`, `MediaManagerMedia`.`local`, `MediaManagerMedia`.`extention`, `MediaManagerMedia`.`poids`, `MediaManagerMedia`.`nom_fichier`, `MediaManagerMedia`.`nom`, `MediaManagerMedia`.`dossier`, `MediaManagerMedia`.`code_embed` FROM `abcnatation-fr`.`media` AS `MediaManagerMedia` WHERE `MediaManagerMedia`.`content_id` = 43740 000
41SELECT `MediaManagerMedia`.`id`, `MediaManagerMedia`.`content_type_id`, `MediaManagerMedia`.`media_type_id`, `MediaManagerMedia`.`content_id`, `MediaManagerMedia`.`local`, `MediaManagerMedia`.`extention`, `MediaManagerMedia`.`poids`, `MediaManagerMedia`.`nom_fichier`, `MediaManagerMedia`.`nom`, `MediaManagerMedia`.`dossier`, `MediaManagerMedia`.`code_embed` FROM `abcnatation-fr`.`media` AS `MediaManagerMedia` WHERE `MediaManagerMedia`.`content_id` = 3425 000
42SELECT `ClubPage`.`id`, `ClubPage`.`content_id`, `ClubPage`.`content_type_id`, `ClubPage`.`club_id`, `ClubPage`.`module`, `ClubPage`.`menu`, `ClubPage`.`activite_id`, `ClubPage`.`commission_id`, `ClubPage`.`edition_id` FROM `abcnatation-fr`.`club_pages` AS `ClubPage` WHERE `ClubPage`.`content_id` = 3414 110
43SELECT `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` WHERE `Content`.`id` = 3414 110
44SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`clubs` AS `Club` WHERE `Club`.`id` = '130943032' 110
45SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 7 110
46SELECT `ClubPage`.`id`, `ClubPage`.`content_id`, `ClubPage`.`content_type_id`, `ClubPage`.`club_id`, `ClubPage`.`module`, `ClubPage`.`menu`, `ClubPage`.`activite_id`, `ClubPage`.`commission_id`, `ClubPage`.`edition_id` FROM `abcnatation-fr`.`club_pages` AS `ClubPage` WHERE `ClubPage`.`content_id` = 43740 110
47SELECT `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` WHERE `Content`.`id` = 43740 110
48SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`clubs` AS `Club` WHERE `Club`.`id` = '130943032' 110
49SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 7 110
50SELECT `ClubPage`.`id`, `ClubPage`.`content_id`, `ClubPage`.`content_type_id`, `ClubPage`.`club_id`, `ClubPage`.`module`, `ClubPage`.`menu`, `ClubPage`.`activite_id`, `ClubPage`.`commission_id`, `ClubPage`.`edition_id` FROM `abcnatation-fr`.`club_pages` AS `ClubPage` WHERE `ClubPage`.`content_id` = 3425 110
51SELECT `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` WHERE `Content`.`id` = 3425 110
52SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`clubs` AS `Club` WHERE `Club`.`id` = '130943032' 110
53SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 7 110
54SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '130943032' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'commission' ORDER BY `Content`.`position` ASC001
55SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '130943032' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'edition' ORDER BY `Content`.`position` ASC001
56SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '130943032' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'medias' ORDER BY `Content`.`position` ASC001
57SELECT `ClubActu`.`id`, `ClubActu`.`club_id`, `ClubActu`.`profil_id`, `ClubActu`.`content_id`, `ClubActu`.`epingler`, `ClubActu`.`cache_accueil`, `ClubActu`.`image`, `ClubActu`.`content_type_id`, `ClubActu`.`clubactivites_club_id`, `ClubActu`.`club_group_id`, `ClubActu`.`clubevenements_club_id`, `ClubActu`.`clubcommissions_club_id`, `ClubActu`.`club_edition_id`, `ClubActu`.`email`, `ClubActu`.`sc_competition_id`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `ClubEdition`.`id`, `ClubEdition`.`nom`, `ClubEdition`.`etat_id`, `ClubEdition`.`saison_id`, `ClubEdition`.`club_id`, `ClubEdition`.`clubevenements_club_id`, `ClubEdition`.`startdate`, `ClubEdition`.`stopdate`, `ClubEdition`.`presentation`, `ClubEdition`.`url_affiche`, `ClubEdition`.`coordonnee_id`, `ClubEdition`.`rght`, `ClubEdition`.`lft`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre`, `ClubGroup`.`id`, `ClubGroup`.`nom`, `ClubGroup`.`ordre`, `ClubGroup`.`saison_id`, `ClubGroup`.`club_id`, `ClubGroup`.`clubactivites_club_id`, `ClubGroup`.`club_niveau_pratique_id`, `ClubGroup`.`inscription_niveau_seance`, `ClubGroup`.`inscription_niveau_lot_seance`, `ClubGroup`.`seances_lots`, `ClubGroup`.`nb_seances_min`, `ClubGroup`.`nb_seances_max`, `ClubGroup`.`type_categorie`, `ClubGroup`.`age_min`, `ClubGroup`.`age_max`, `ClubGroup`.`annee_min`, `ClubGroup`.`annee_max`, `ClubGroup`.`categories`, `ClubGroup`.`nbr_place`, `ClubGroup`.`presentation`, `ClubGroup`.`presentation_courte`, `ClubGroup`.`criteres_acces`, `ClubGroup`.`obj_sportif`, `ClubGroup`.`parent_id`, `ClubGroup`.`rght`, `ClubGroup`.`lft`, `ClubGroup`.`affiche_membres`, `ClubGroup`.`affiche_membres_affectes`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`club_actus` AS `ClubActu` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubActu`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubActu`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` ON (`ClubActu`.`clubevenements_club_id` = `ClubevenementsClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_editions` AS `ClubEdition` ON (`ClubActu`.`club_edition_id` = `ClubEdition`.`id`) LEFT JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubActu`.`clubactivites_club_id` = `ClubactivitesClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_groups` AS `ClubGroup` ON (`ClubActu`.`club_group_id` = `ClubGroup`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubActu`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`ClubActu`.`profil_id` = `Profil`.`id`) WHERE `ClubActu`.`club_id` = '130943032' AND ((NOT (`Content`.`etat_id` = '0')) OR (`Content`.`etat_id` = '1'))26926910
58SELECT `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` WHERE `ClubactivitesClub`.`club_id` = '130943032' AND `ClubactivitesClub`.`saison_id` = '2019-2020' ORDER BY `ClubactivitesClub`.`ordre` ASC771
59SELECT `ClubcommissionsClub`.`id`, `ClubcommissionsClub`.`clubcommission_id`, `ClubcommissionsClub`.`club_id`, `ClubcommissionsClub`.`libelle`, `ClubcommissionsClub`.`saison_id`, `ClubcommissionsClub`.`presentation`, `ClubcommissionsClub`.`ordre`, `Clubcommission`.`id`, `Clubcommission`.`description`, `Clubcommission`.`type`, `Clubcommission`.`activite_id`, `Clubcommission`.`ordre` FROM `abcnatation-fr`.`clubcommissions_clubs` AS `ClubcommissionsClub` LEFT JOIN `abcnatation-fr`.`clubcommissions` AS `Clubcommission` ON (`ClubcommissionsClub`.`clubcommission_id` = `Clubcommission`.`id`) WHERE `ClubcommissionsClub`.`club_id` = '130943032' AND `ClubcommissionsClub`.`saison_id` = '2019-2020' ORDER BY `ClubcommissionsClub`.`ordre` ASC000
60SELECT `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `Clubevenement`.`id`, `Clubevenement`.`description` FROM `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` LEFT JOIN `abcnatation-fr`.`clubevenements` AS `Clubevenement` ON (`ClubevenementsClub`.`clubevenement_id` = `Clubevenement`.`id`) WHERE `ClubevenementsClub`.`club_id` = '130943032' AND `ClubevenementsClub`.`etat_id` = '1'001
61SELECT `ClubAlbum`.`id`, `ClubAlbum`.`name`, `ClubAlbum`.`description`, `ClubAlbum`.`lien_externe`, `ClubAlbum`.`club_id`, `ClubAlbum`.`cache_accueil`, `ClubAlbum`.`profil_id`, `ClubAlbum`.`date`, `ClubAlbum`.`created`, `ClubAlbum`.`updated` FROM `abcnatation-fr`.`club_albums` AS `ClubAlbum` WHERE `ClubAlbum`.`club_id` = '130943032'991
62SELECT `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Vignette`.`id`, `Vignette`.`content_type_id`, `Vignette`.`media_type_id`, `Vignette`.`content_id`, `Vignette`.`local`, `Vignette`.`extention`, `Vignette`.`poids`, `Vignette`.`nom_fichier`, `Vignette`.`nom`, `Vignette`.`dossier`, `Vignette`.`code_embed`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Group`.`id`, `Group`.`parent_id`, `Group`.`name`, `Group`.`created`, `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id`, `MentionsLegale`.`id`, `MentionsLegale`.`content_type_id`, `MentionsLegale`.`content_id`, `MentionsLegale`.`adresse_site_web`, `MentionsLegale`.`raison_sociale`, `MentionsLegale`.`forme_juridique`, `MentionsLegale`.`num_siren`, `MentionsLegale`.`code_naf`, `MentionsLegale`.`adresse_siege`, `MentionsLegale`.`responsable_publication`, `MentionsLegale`.`num_cnil`, `MentionsLegale`.`webmaster`, `MentionsLegale`.`createur`, `MentionsLegale`.`hebergeur`, `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id`, `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id`, `MediaManagerMedia`.`id`, `MediaManagerMedia`.`content_type_id`, `MediaManagerMedia`.`media_type_id`, `MediaManagerMedia`.`content_id`, `MediaManagerMedia`.`local`, `MediaManagerMedia`.`extention`, `MediaManagerMedia`.`poids`, `MediaManagerMedia`.`nom_fichier`, `MediaManagerMedia`.`nom`, `MediaManagerMedia`.`dossier`, `MediaManagerMedia`.`code_embed`, `ClubPage`.`id`, `ClubPage`.`content_id`, `ClubPage`.`content_type_id`, `ClubPage`.`club_id`, `ClubPage`.`module`, `ClubPage`.`menu`, `ClubPage`.`activite_id`, `ClubPage`.`commission_id`, `ClubPage`.`edition_id` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `ClubPage`.`menu` = 'medias' AND `ClubPage`.`club_id` = '130943032' AND `Content`.`content_type_id` = 7 AND `Content`.`etat_id` = '1'001
63SELECT `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` WHERE `ClubactivitesClub`.`id` = 9955 LIMIT 1110
64SELECT `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` WHERE `ClubactivitesClub`.`id` = 9955 LIMIT 1110
65SELECT `Content`.`id`, `Content`.`non_cliquable`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '130943032' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'activite' AND `ClubPage`.`activite_id` = 1 ORDER BY `Content`.`position` ASC111
66SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 7 110
67SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 43740 000
68SELECT `MentionsLegale`.`id`, `MentionsLegale`.`content_type_id`, `MentionsLegale`.`content_id`, `MentionsLegale`.`adresse_site_web`, `MentionsLegale`.`raison_sociale`, `MentionsLegale`.`forme_juridique`, `MentionsLegale`.`num_siren`, `MentionsLegale`.`code_naf`, `MentionsLegale`.`adresse_siege`, `MentionsLegale`.`responsable_publication`, `MentionsLegale`.`num_cnil`, `MentionsLegale`.`webmaster`, `MentionsLegale`.`createur`, `MentionsLegale`.`hebergeur` FROM `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` WHERE `MentionsLegale`.`content_id` = 43740 000
69SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 43740 000
70SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 43740 000
71SELECT `MediaManagerMedia`.`id`, `MediaManagerMedia`.`content_type_id`, `MediaManagerMedia`.`media_type_id`, `MediaManagerMedia`.`content_id`, `MediaManagerMedia`.`local`, `MediaManagerMedia`.`extention`, `MediaManagerMedia`.`poids`, `MediaManagerMedia`.`nom_fichier`, `MediaManagerMedia`.`nom`, `MediaManagerMedia`.`dossier`, `MediaManagerMedia`.`code_embed` FROM `abcnatation-fr`.`media` AS `MediaManagerMedia` WHERE `MediaManagerMedia`.`content_id` = 43740 000
72SELECT `ClubPage`.`id`, `ClubPage`.`content_id`, `ClubPage`.`content_type_id`, `ClubPage`.`club_id`, `ClubPage`.`module`, `ClubPage`.`menu`, `ClubPage`.`activite_id`, `ClubPage`.`commission_id`, `ClubPage`.`edition_id` FROM `abcnatation-fr`.`club_pages` AS `ClubPage` WHERE `ClubPage`.`content_id` = 43740 110
73SELECT `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` WHERE `Content`.`id` = 43740 110
74SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`clubs` AS `Club` WHERE `Club`.`id` = '130943032' 110
75SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 7 110
76SELECT `ScCompetitionClub`.`id`, `ScCompetitionClub`.`sc_competition_id`, `ScCompetitionClub`.`club_id`, `ScCompetition`.`id`, `ScCompetition`.`type`, `ScCompetition`.`ffnex_id`, `ScCompetition`.`profil_id`, `ScCompetition`.`origine`, `ScCompetition`.`name`, `ScCompetition`.`city`, `ScCompetition`.`departement_id`, `ScCompetition`.`region_id`, `ScCompetition`.`startdate`, `ScCompetition`.`stopdate`, `ScCompetition`.`date_limit_engagement_debut`, `ScCompetition`.`date_limit_engagement_fin`, `ScCompetition`.`date_pub_start_list`, `ScCompetition`.`saison`, `ScCompetition`.`nation`, `ScCompetition`.`age_min`, `ScCompetition`.`age_max`, `ScCompetition`.`scf_competition_type_id`, `ScCompetition`.`scf_discipline_id`, `ScCompetition`.`scf_competition_label_id`, `ScCompetition`.`scf_chronometrage_type_id`, `ScCompetition`.`scf_competition_niveau_id`, `ScCompetition`.`piscine_id`, `ScCompetition`.`pool_name`, `ScCompetition`.`pool_lane`, `ScCompetition`.`pool_size`, `ScCompetition`.`byteam`, `ScCompetition`.`description`, `ScCompetition`.`lien_unique`, `ScCompetition`.`vide`, `ScCompetition`.`xml_vide`, `ScCompetition`.`xml_resultats_vide`, `ScCompetition`.`xml_faux`, `ScCompetition`.`existe_plus`, `ScCompetition`.`erreur_integration`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`sc_competition_clubs` AS `ScCompetitionClub` LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScCompetitionClub`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScCompetitionClub`.`club_id` = `Club`.`id`) WHERE `ScCompetitionClub`.`club_id` = '130943032' AND `ScCompetition`.`startdate` > '2019-12-07' ORDER BY `ScCompetition`.`startdate` asc003
77SELECT `Clubcommission`.`id`, `Clubcommission`.`description`, `Clubcommission`.`type`, `Clubcommission`.`activite_id`, `Clubcommission`.`ordre` FROM `abcnatation-fr`.`clubcommissions` AS `Clubcommission` WHERE `Clubcommission`.`activite_id` = 1 LIMIT 1110
78SELECT `ClubcommissionsClub`.`id`, `ClubcommissionsClub`.`clubcommission_id`, `ClubcommissionsClub`.`club_id`, `ClubcommissionsClub`.`libelle`, `ClubcommissionsClub`.`saison_id`, `ClubcommissionsClub`.`presentation`, `ClubcommissionsClub`.`ordre`, `Clubcommission`.`id`, `Clubcommission`.`description`, `Clubcommission`.`type`, `Clubcommission`.`activite_id`, `Clubcommission`.`ordre` FROM `abcnatation-fr`.`clubcommissions_clubs` AS `ClubcommissionsClub` LEFT JOIN `abcnatation-fr`.`clubcommissions` AS `Clubcommission` ON (`ClubcommissionsClub`.`clubcommission_id` = `Clubcommission`.`id`) WHERE `ClubcommissionsClub`.`clubcommission_id` = 0 AND `ClubcommissionsClub`.`club_id` = '130943032' LIMIT 1000
79SELECT `ClubactivitesClub`.`id` FROM `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` WHERE `ClubactivitesClub`.`clubactivite_id` = 1 AND `ClubactivitesClub`.`club_id` = '130943032'770
80SELECT `ClubActu`.`id`, `ClubActu`.`club_id`, `ClubActu`.`profil_id`, `ClubActu`.`content_id`, `ClubActu`.`epingler`, `ClubActu`.`cache_accueil`, `ClubActu`.`image`, `ClubActu`.`content_type_id`, `ClubActu`.`clubactivites_club_id`, `ClubActu`.`club_group_id`, `ClubActu`.`clubevenements_club_id`, `ClubActu`.`clubcommissions_club_id`, `ClubActu`.`club_edition_id`, `ClubActu`.`email`, `ClubActu`.`sc_competition_id`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `ClubEdition`.`id`, `ClubEdition`.`nom`, `ClubEdition`.`etat_id`, `ClubEdition`.`saison_id`, `ClubEdition`.`club_id`, `ClubEdition`.`clubevenements_club_id`, `ClubEdition`.`startdate`, `ClubEdition`.`stopdate`, `ClubEdition`.`presentation`, `ClubEdition`.`url_affiche`, `ClubEdition`.`coordonnee_id`, `ClubEdition`.`rght`, `ClubEdition`.`lft`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre`, `ClubGroup`.`id`, `ClubGroup`.`nom`, `ClubGroup`.`ordre`, `ClubGroup`.`saison_id`, `ClubGroup`.`club_id`, `ClubGroup`.`clubactivites_club_id`, `ClubGroup`.`club_niveau_pratique_id`, `ClubGroup`.`inscription_niveau_seance`, `ClubGroup`.`inscription_niveau_lot_seance`, `ClubGroup`.`seances_lots`, `ClubGroup`.`nb_seances_min`, `ClubGroup`.`nb_seances_max`, `ClubGroup`.`type_categorie`, `ClubGroup`.`age_min`, `ClubGroup`.`age_max`, `ClubGroup`.`annee_min`, `ClubGroup`.`annee_max`, `ClubGroup`.`categories`, `ClubGroup`.`nbr_place`, `ClubGroup`.`presentation`, `ClubGroup`.`presentation_courte`, `ClubGroup`.`criteres_acces`, `ClubGroup`.`obj_sportif`, `ClubGroup`.`parent_id`, `ClubGroup`.`rght`, `ClubGroup`.`lft`, `ClubGroup`.`affiche_membres`, `ClubGroup`.`affiche_membres_affectes`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`club_actus` AS `ClubActu` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubActu`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubActu`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` ON (`ClubActu`.`clubevenements_club_id` = `ClubevenementsClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_editions` AS `ClubEdition` ON (`ClubActu`.`club_edition_id` = `ClubEdition`.`id`) LEFT JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubActu`.`clubactivites_club_id` = `ClubactivitesClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_groups` AS `ClubGroup` ON (`ClubActu`.`club_group_id` = `ClubGroup`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubActu`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`ClubActu`.`profil_id` = `Profil`.`id`) WHERE `ClubActu`.`club_id` = '130943032' AND ((NOT (`Content`.`etat_id` = '0')) OR (`Content`.`etat_id` = '1')) AND `ClubActu`.`clubactivites_club_id` IN (149, 5076, 9955, 7173, 7746, 8376, 10730)19192
81SELECT `ClubGroup`.`id`, `ClubGroup`.`nom`, `ClubGroup`.`ordre`, `ClubGroup`.`saison_id`, `ClubGroup`.`club_id`, `ClubGroup`.`clubactivites_club_id`, `ClubGroup`.`club_niveau_pratique_id`, `ClubGroup`.`inscription_niveau_seance`, `ClubGroup`.`inscription_niveau_lot_seance`, `ClubGroup`.`seances_lots`, `ClubGroup`.`nb_seances_min`, `ClubGroup`.`nb_seances_max`, `ClubGroup`.`type_categorie`, `ClubGroup`.`age_min`, `ClubGroup`.`age_max`, `ClubGroup`.`annee_min`, `ClubGroup`.`annee_max`, `ClubGroup`.`categories`, `ClubGroup`.`nbr_place`, `ClubGroup`.`presentation`, `ClubGroup`.`presentation_courte`, `ClubGroup`.`criteres_acces`, `ClubGroup`.`obj_sportif`, `ClubGroup`.`parent_id`, `ClubGroup`.`rght`, `ClubGroup`.`lft`, `ClubGroup`.`affiche_membres`, `ClubGroup`.`affiche_membres_affectes`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre`, `ClubNiveauPratique`.`id`, `ClubNiveauPratique`.`name`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`club_groups` AS `ClubGroup` LEFT JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubGroup`.`clubactivites_club_id` = `ClubactivitesClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_niveau_pratiques` AS `ClubNiveauPratique` ON (`ClubGroup`.`club_niveau_pratique_id` = `ClubNiveauPratique`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubGroup`.`club_id` = `Club`.`id`) WHERE `ClubGroup`.`clubactivites_club_id` = 99552224
82SELECT `ClubOrganigramme`.`id`, `ClubOrganigramme`.`club_id`, `ClubOrganigramme`.`saison_id`, `ClubOrganigramme`.`licencie_id`, `ClubOrganigramme`.`club_membre_id`, `ClubOrganigramme`.`club_role_id`, `ClubOrganigramme`.`clubactivites_club_id`, `ClubOrganigramme`.`clubcommissions_club_id`, `ClubOrganigramme`.`club_group_id`, `ClubOrganigramme`.`club_seance_id`, `ClubOrganigramme`.`seance_lot_id`, `ClubOrganigramme`.`profil_id`, `ClubOrganigramme`.`created` FROM `abcnatation-fr`.`club_organigrammes` AS `ClubOrganigramme` WHERE `ClubOrganigramme`.`club_group_id` IN (15821, 15822) 00203
83SELECT `ClubSeance`.`id`, `ClubSeance`.`club_group_id`, `ClubSeance`.`saison_id`, `ClubSeance`.`jour`, `ClubSeance`.`heure_debut`, `ClubSeance`.`heure_fin`, `ClubSeance`.`nbr_place`, `ClubSeance`.`piscine_id`, `ClubSeance`.`club_membre_id` FROM `abcnatation-fr`.`club_seances` AS `ClubSeance` WHERE `ClubSeance`.`club_group_id` IN (15821, 15822) 556
84SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 612 LIMIT 1110
85SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 27 LIMIT 1110
86SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 27 LIMIT 1110
87SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 612 LIMIT 1110
88SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`piscines` AS `Piscine` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Piscine`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`Piscine`.`club_id` = `Club`.`id`) WHERE `Piscine`.`id` = 27 LIMIT 1110
89SELECT `SeanceLot`.`id`, `SeanceLot`.`club_group_id`, `SeanceLot`.`lot`, `SeanceLot`.`nbr_place` FROM `abcnatation-fr`.`seance_lots` AS `SeanceLot` WHERE `SeanceLot`.`club_group_id` IN (15821, 15822) 000
90SELECT `ClubOrganigramme`.`id`, `ClubOrganigramme`.`club_id`, `ClubOrganigramme`.`saison_id`, `ClubOrganigramme`.`licencie_id`, `ClubOrganigramme`.`club_membre_id`, `ClubOrganigramme`.`club_role_id`, `ClubOrganigramme`.`clubactivites_club_id`, `ClubOrganigramme`.`clubcommissions_club_id`, `ClubOrganigramme`.`club_group_id`, `ClubOrganigramme`.`club_seance_id`, `ClubOrganigramme`.`seance_lot_id`, `ClubOrganigramme`.`profil_id`, `ClubOrganigramme`.`created`, `ClubRole`.`id`, `ClubRole`.`name`, `ClubRole`.`lft`, `ClubRole`.`rght`, `ClubRole`.`parent_id`, `ClubRole`.`ordre`, `ClubRole`.`clubactivite_id`, `ClubRole`.`clubcommission_id`, `ClubRole`.`group`, `ClubRole`.`unique`, `ClubRole`.`niveau_creneau`, `ClubRole`.`type`, `ClubRole`.`organigramme`, `ClubRole`.`droits`, `ClubMembre`.`id`, `ClubMembre`.`club_id`, `ClubMembre`.`saison_id`, `ClubMembre`.`futur`, `ClubMembre`.`nom`, `ClubMembre`.`prenom`, `ClubMembre`.`gender`, `ClubMembre`.`date_naissance`, `ClubMembre`.`image`, `ClubMembre`.`club_inscription_id`, `ClubMembre`.`profil_id`, `ClubMembre`.`coordonnee_id`, `ClubMembre`.`resp1_genre`, `ClubMembre`.`resp1_relation`, `ClubMembre`.`resp1_nom`, `ClubMembre`.`resp1_prenom`, `ClubMembre`.`resp1_naissance`, `ClubMembre`.`resp1_nationnalite_id`, `ClubMembre`.`resp1_coordonnee_id`, `ClubMembre`.`resp2_genre`, `ClubMembre`.`resp2_relation`, `ClubMembre`.`resp2_nom`, `ClubMembre`.`resp2_prenom`, `ClubMembre`.`resp2_naissance`, `ClubMembre`.`resp2_nationnalite_id`, `ClubMembre`.`resp2_coordonnee_id`, `ClubMembre`.`licencie_id`, `ClubMembre`.`licencie`, `ClubMembre`.`membre_nationnalite_id`, `ClubMembre`.`membre_profession`, `ClubMembre`.`membre_taille`, `ClubMembre`.`membre_pointure`, `ClubMembre`.`majeur_film`, `ClubMembre`.`handicap`, `ClubMembre`.`recevoir_news`, `ClubMembre`.`membre_metier_id`, `ClubMembre`.`carte`, `ClubMembre`.`cache`, `ClubMembre`.`type_licence`, `ClubMembre`.`activite_ffn`, `ClubMembre`.`created`, `ClubMembre`.`updated`, `ClubGroup`.`id`, `ClubGroup`.`nom`, `ClubGroup`.`ordre`, `ClubGroup`.`saison_id`, `ClubGroup`.`club_id`, `ClubGroup`.`clubactivites_club_id`, `ClubGroup`.`club_niveau_pratique_id`, `ClubGroup`.`inscription_niveau_seance`, `ClubGroup`.`inscription_niveau_lot_seance`, `ClubGroup`.`seances_lots`, `ClubGroup`.`nb_seances_min`, `ClubGroup`.`nb_seances_max`, `ClubGroup`.`type_categorie`, `ClubGroup`.`age_min`, `ClubGroup`.`age_max`, `ClubGroup`.`annee_min`, `ClubGroup`.`annee_max`, `ClubGroup`.`categories`, `ClubGroup`.`nbr_place`, `ClubGroup`.`presentation`, `ClubGroup`.`presentation_courte`, `ClubGroup`.`criteres_acces`, `ClubGroup`.`obj_sportif`, `ClubGroup`.`parent_id`, `ClubGroup`.`rght`, `ClubGroup`.`lft`, `ClubGroup`.`affiche_membres`, `ClubGroup`.`affiche_membres_affectes`, `ClubcommissionsClub`.`id`, `ClubcommissionsClub`.`clubcommission_id`, `ClubcommissionsClub`.`club_id`, `ClubcommissionsClub`.`libelle`, `ClubcommissionsClub`.`saison_id`, `ClubcommissionsClub`.`presentation`, `ClubcommissionsClub`.`ordre`, `ClubSeance`.`id`, `ClubSeance`.`club_group_id`, `ClubSeance`.`saison_id`, `ClubSeance`.`jour`, `ClubSeance`.`heure_debut`, `ClubSeance`.`heure_fin`, `ClubSeance`.`nbr_place`, `ClubSeance`.`piscine_id`, `ClubSeance`.`club_membre_id`, `SeanceLot`.`id`, `SeanceLot`.`club_group_id`, `SeanceLot`.`lot`, `SeanceLot`.`nbr_place` FROM `abcnatation-fr`.`club_organigrammes` AS `ClubOrganigramme` LEFT JOIN `abcnatation-fr`.`club_roles` AS `ClubRole` ON (`ClubOrganigramme`.`club_role_id` = `ClubRole`.`id`) LEFT JOIN `abcnatation-fr`.`club_membres` AS `ClubMembre` ON (`ClubOrganigramme`.`club_membre_id` = `ClubMembre`.`id`) LEFT JOIN `abcnatation-fr`.`club_groups` AS `ClubGroup` ON (`ClubOrganigramme`.`club_group_id` = `ClubGroup`.`id`) LEFT JOIN `abcnatation-fr`.`clubcommissions_clubs` AS `ClubcommissionsClub` ON (`ClubOrganigramme`.`clubcommissions_club_id` = `ClubcommissionsClub`.`id`) LEFT JOIN `abcnatation-fr`.`club_seances` AS `ClubSeance` ON (`ClubOrganigramme`.`club_seance_id` = `ClubSeance`.`id`) LEFT JOIN `abcnatation-fr`.`seance_lots` AS `SeanceLot` ON (`ClubOrganigramme`.`seance_lot_id` = `SeanceLot`.`id`) WHERE `ClubOrganigramme`.`clubactivites_club_id` = 9955 AND `ClubOrganigramme`.`club_id` = '130943032' AND ((NOT (`ClubRole`.`type` = 'pratiquant')) AND (NOT (`ClubRole`.`type` = 'autre'))) ORDER BY `ClubRole`.`id` ASC00205
91SELECT `ScCompetitionClub`.`id`, `ScCompetitionClub`.`sc_competition_id`, `ScCompetitionClub`.`club_id`, `ScCompetition`.`id`, `ScCompetition`.`type`, `ScCompetition`.`ffnex_id`, `ScCompetition`.`profil_id`, `ScCompetition`.`origine`, `ScCompetition`.`name`, `ScCompetition`.`city`, `ScCompetition`.`departement_id`, `ScCompetition`.`region_id`, `ScCompetition`.`startdate`, `ScCompetition`.`stopdate`, `ScCompetition`.`date_limit_engagement_debut`, `ScCompetition`.`date_limit_engagement_fin`, `ScCompetition`.`date_pub_start_list`, `ScCompetition`.`saison`, `ScCompetition`.`nation`, `ScCompetition`.`age_min`, `ScCompetition`.`age_max`, `ScCompetition`.`scf_competition_type_id`, `ScCompetition`.`scf_discipline_id`, `ScCompetition`.`scf_competition_label_id`, `ScCompetition`.`scf_chronometrage_type_id`, `ScCompetition`.`scf_competition_niveau_id`, `ScCompetition`.`piscine_id`, `ScCompetition`.`pool_name`, `ScCompetition`.`pool_lane`, `ScCompetition`.`pool_size`, `ScCompetition`.`byteam`, `ScCompetition`.`description`, `ScCompetition`.`lien_unique`, `ScCompetition`.`vide`, `ScCompetition`.`xml_vide`, `ScCompetition`.`xml_resultats_vide`, `ScCompetition`.`xml_faux`, `ScCompetition`.`existe_plus`, `ScCompetition`.`erreur_integration`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity` FROM `abcnatation-fr`.`sc_competition_clubs` AS `ScCompetitionClub` LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScCompetitionClub`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScCompetitionClub`.`club_id` = `Club`.`id`) WHERE `ScCompetitionClub`.`club_id` = '130943032' AND `ScCompetition`.`origine` NOT LIKE 'abc' ORDER BY `ScCompetition`.`saison` DESC LIMIT 1116
92SELECT `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` = '130943032' LIMIT 1110
93SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('130943032') 330
94SELECT `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` = '130943032' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 45450
95SELECT `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` = '57767' LIMIT 1110
96SELECT `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` = ('57767') 000
97SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`id` NOT LIKE '%R%' GROUP BY `ScfEpreuveType`.`id`343442
98SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`id` NOT LIKE '%R%' AND `ScResultat`.`club_id` = '130943032' GROUP BY `ScfEpreuveType`.`id`335
99SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' GROUP BY `ScResultat`.`licencie_id`445
100SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' GROUP BY `ScResultat`.`licencie_id`55155142
101SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`swimtime` != 0 AND `ScResultat`.`scf_disqualification_code_id` = 0115
102SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`swimtime` != 0 AND `ScResultat`.`scf_disqualification_code_id` = 01137
103SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `Licencie`.`gender` = 'H' GROUP BY `ScResultat`.`licencie_id`30130144
104SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `Licencie`.`gender` = 'F' GROUP BY `ScResultat`.`licencie_id`25025043
105SELECT `ScResultat`.`id`, `ScResultat`.`idffnex`, `ScResultat`.`sc_competition_id`, `ScResultat`.`heat`, `ScResultat`.`lane`, `ScResultat`.`side`, `ScResultat`.`individuel`, `ScResultat`.`relay`, `ScResultat`.`equipe`, `ScResultat`.`licencie_id`, `ScResultat`.`licencie_age`, `ScResultat`.`scf_epreuve_type_id`, `ScResultat`.`scf_epreuve_format_id`, `ScResultat`.`scf_group_age_id`, `ScResultat`.`qualifyingplace`, `ScResultat`.`qualifyingdate`, `ScResultat`.`qualifyingtime`, `ScResultat`.`niveau_qualif`, `ScResultat`.`niveau_serie`, `ScResultat`.`swimdate`, `ScResultat`.`swimtime`, `ScResultat`.`temps`, `ScResultat`.`reactiontime`, `ScResultat`.`scf_disqualification_code_id`, `ScResultat`.`swimoff`, `ScResultat`.`place`, `ScResultat`.`points`, `ScResultat`.`comment`, `ScResultat`.`club_id`, `ScResultat`.`banniere_id`, `ScResultat`.`team`, `ScResultat`.`scf_epreuve_format_next_id`, `ScResultat`.`cap`, `ScResultat`.`cree`, `ScResultat`.`maj_age`, `ScResultat`.`scf_epreuve_type_mixte_id`, `Licencie`.`id`, `Licencie`.`firstname`, `Licencie`.`lastname`, `Licencie`.`gender`, `Licencie`.`birthdate`, `Licencie`.`nation`, `Licencie`.`club_id`, `Licencie`.`verified`, `Licencie`.`cache`, `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`, `ScfEpreuveType`.`id`, `ScfEpreuveType`.`description`, `ScfEpreuveType`.`description_short`, `ScfEpreuveType`.`description_middle`, `ScfEpreuveType`.`scf_epreuve_qualif_id`, `ScfEpreuveType`.`genre`, `ScfEpreuveType`.`olympique`, `ScfEpreuveType`.`relais`, `ScfEpreuveTypeMixte`.`id`, `ScfEpreuveTypeMixte`.`description`, `ScfEpreuveTypeMixte`.`description_short`, `ScfEpreuveTypeMixte`.`description_middle`, `ScfEpreuveTypeMixte`.`scf_epreuve_qualif_id`, `ScfEpreuveTypeMixte`.`genre`, `ScfEpreuveTypeMixte`.`olympique`, `ScfEpreuveTypeMixte`.`relais`, `ScfEpreuveFormat`.`id`, `ScfEpreuveFormat`.`description`, `ScfEpreuveFormat`.`position`, `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`, `ScfDisqualificationCode`.`id`, `ScfDisqualificationCode`.`description`, `ScfDisqualificationCode`.`short_description` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `Licencie`.`cache` = 0 ORDER BY `ScResultat`.`points` DESC, `ScResultat`.`licencie_id` ASC LIMIT 2015156
106SELECT `ScResultat`.`id`, `ScResultat`.`idffnex`, `ScResultat`.`sc_competition_id`, `ScResultat`.`heat`, `ScResultat`.`lane`, `ScResultat`.`side`, `ScResultat`.`individuel`, `ScResultat`.`relay`, `ScResultat`.`equipe`, `ScResultat`.`licencie_id`, `ScResultat`.`licencie_age`, `ScResultat`.`scf_epreuve_type_id`, `ScResultat`.`scf_epreuve_format_id`, `ScResultat`.`scf_group_age_id`, `ScResultat`.`qualifyingplace`, `ScResultat`.`qualifyingdate`, `ScResultat`.`qualifyingtime`, `ScResultat`.`niveau_qualif`, `ScResultat`.`niveau_serie`, `ScResultat`.`swimdate`, `ScResultat`.`swimtime`, `ScResultat`.`temps`, `ScResultat`.`reactiontime`, `ScResultat`.`scf_disqualification_code_id`, `ScResultat`.`swimoff`, `ScResultat`.`place`, `ScResultat`.`points`, `ScResultat`.`comment`, `ScResultat`.`club_id`, `ScResultat`.`banniere_id`, `ScResultat`.`team`, `ScResultat`.`scf_epreuve_format_next_id`, `ScResultat`.`cap`, `ScResultat`.`cree`, `ScResultat`.`maj_age`, `ScResultat`.`scf_epreuve_type_mixte_id`, `Licencie`.`id`, `Licencie`.`firstname`, `Licencie`.`lastname`, `Licencie`.`gender`, `Licencie`.`birthdate`, `Licencie`.`nation`, `Licencie`.`club_id`, `Licencie`.`verified`, `Licencie`.`cache`, `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`, `ScfEpreuveType`.`id`, `ScfEpreuveType`.`description`, `ScfEpreuveType`.`description_short`, `ScfEpreuveType`.`description_middle`, `ScfEpreuveType`.`scf_epreuve_qualif_id`, `ScfEpreuveType`.`genre`, `ScfEpreuveType`.`olympique`, `ScfEpreuveType`.`relais`, `ScfEpreuveTypeMixte`.`id`, `ScfEpreuveTypeMixte`.`description`, `ScfEpreuveTypeMixte`.`description_short`, `ScfEpreuveTypeMixte`.`description_middle`, `ScfEpreuveTypeMixte`.`scf_epreuve_qualif_id`, `ScfEpreuveTypeMixte`.`genre`, `ScfEpreuveTypeMixte`.`olympique`, `ScfEpreuveTypeMixte`.`relais`, `ScfEpreuveFormat`.`id`, `ScfEpreuveFormat`.`description`, `ScfEpreuveFormat`.`position`, `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`, `ScfDisqualificationCode`.`id`, `ScfDisqualificationCode`.`description`, `ScfDisqualificationCode`.`short_description` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' GROUP BY `ScfEpreuveType`.`id`343465
107SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 1116
108SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 1115
109SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 1115
110SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 1115
111SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 2115
112SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 2115
113SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 2115
114SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 2115
115SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 3115
116SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 3115
117SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 3115
118SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 3115
119SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 4115
120SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 4115
121SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 4115
122SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 4115
123SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 5115
124SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 60 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 5115
125SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 60 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 5115
126SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 60 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 5115
127SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 6115
128SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 60 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 6116
129SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 60 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 6115
130SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 60 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 6115
131SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 11115
132SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 11115
133SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 11115
134SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 11115
135SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 12115
136SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 12115
137SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 12115
138SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 12115
139SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 13115
140SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 13115
141SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 13115
142SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 13115
143SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 21115
144SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 21115
145SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 21115
146SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 21115
147SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 22115
148SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 22115
149SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 22115
150SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 22115
151SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 23115
152SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 23115
153SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 23115
154SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 23115
155SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 31115
156SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 31115
157SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 31115
158SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 31115
159SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 32115
160SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 32115
161SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 32115
162SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 32115
163SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 33115
164SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 33115
165SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 33115
166SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 33115
167SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 41115
168SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 41115
169SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 41115
170SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 41115
171SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 42115
172SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 42115
173SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 42115
174SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 42115
175SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 51115
176SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 51115
177SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 51115
178SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 51115
179SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 52115
180SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 52115
181SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 52115
182SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 52115
183SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 53115
184SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 53115
185SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 53115
186SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 53115
187SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 54115
188SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 54115
189SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 54115
190SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 54115
191SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 55115
192SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 60 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 55115
193SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 60 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 55115
194SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 60 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 55115
195SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 56115
196SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 60 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 56115
197SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 60 AND `ScResultat`.`place` = 2 AND `ScfEpreuveType`.`id` = 56115
198SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 60 AND `ScResultat`.`place` = 3 AND `ScfEpreuveType`.`id` = 56115
199SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScfEpreuveType`.`id` = 61115
200SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`sc_resultats` AS `ScResultat` LEFT JOIN `abcnatation-fr`.`licencies` AS `Licencie` ON (`ScResultat`.`licencie_id` = `Licencie`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ScResultat`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_types` AS `ScfEpreuveType` ON (`ScResultat`.`scf_epreuve_type_id` = `ScfEpreuveType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_type_mixtes` AS `ScfEpreuveTypeMixte` ON (`ScResultat`.`scf_epreuve_type_mixte_id` = `ScfEpreuveTypeMixte`.`id`) LEFT JOIN `abcnatation-fr`.`scf_epreuve_formats` AS `ScfEpreuveFormat` ON (`ScResultat`.`scf_epreuve_format_id` = `ScfEpreuveFormat`.`id`) LEFT JOIN `abcnatation-fr`.`sc_competitions` AS `ScCompetition` ON (`ScResultat`.`sc_competition_id` = `ScCompetition`.`id`) LEFT JOIN `abcnatation-fr`.`scf_disqualification_codes` AS `ScfDisqualificationCode` ON (`ScResultat`.`scf_disqualification_code_id` = `ScfDisqualificationCode`.`id`) WHERE `ScResultat`.`sc_competition_id` = '57767' AND `ScResultat`.`club_id` = '130943032' AND `ScResultat`.`scf_epreuve_format_id` = 11 AND `ScResultat`.`place` = 1 AND `ScfEpreuveType`.`id` = 61115