CN MOIRANS


Rue Roger Dumarais
38430 Moirans
Plan Google Maps

Secrétariat cnmoirans@yahoo.fr
Nous écrire
  • FFN : 3 35 038 01157




Abcnatation
Le club

Publié le 27/11/2019 à 17h08 - Mis à jour le 27/11/2019 à 17h11

Ce samedi 23 novembre, 4 de nos masters ont participé au 15ème challenge de l’ACS à Seyssinet.

Pour cette première compétition de la saison, nos nageurs ont pu se mesurer à une grosse centaine de nageurs des clubs de l’Isère.

Ils ont fait de belles courses prometteuses pour le reste de la saison.

[Lire]
Le club

Publié le 20/11/2019 à 13h38 - Mis à jour le 22/11/2019 à 14h15

Ce week-end avaient lieu les championnats départementaux d’automne Juniors Seniors à la piscine de Chatte près de Saint Marcellin. 13 nageurs du club encadrés par Jérôme y ont participé et plusieurs records personnels ont été établis. Pour certains d’entre eux, dont c’était leur toute 1ère compétition, les résultats ont été plutôt positifs. Désormais...
[Lire]
Le club

Publié le 13/11/2019 à 07h44 - Mis à jour le 24/11/2019 à 14h22

Ce lundi 11 novembre, le club a participé au challenge avenirs à Pont de Claix. Nouveau cette année, le challenge sert de support à l’obtention du Pass’ Compétition Natation Course (sésame pour participer à toutes les compétitions du circuit départemental).

Cinq de nos nageurs ont participé et trois d’entre eux, qui n’ont pas encore le pass compétition, ont validé trois des...
[Lire]

Le club

Publié le 16/10/2019 à 11h40

la messagerie à partir de notre site ne fonctionne pas actuellement.

 

merci de nous contacter directement sur l'adresse mail ci-dessous :

 

cnmoirans@yahoo.fr

 

 

 


[Lire]

Voir toutes les actualités

Club des Nageurs de Moirans

CN MOIRANS
Menu  
(default) 141 queries took 508 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`sous_domaine` = 'cnmoirans.com' LIMIT 1111
2SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('100384272') 000
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` = '100384272' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 770
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` = '100384272') OR (`Club`.`id` = '100384272')) LIMIT 1111
9SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('100384272') 000
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` = '100384272' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 770
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` = '100384272' 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` = '100384272' LIMIT 1112
14SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('100384272') 000
15SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubActiv`.`type`, `ClubActiv`.`sport_id`, `ClubActiv`.`ordre`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubactivitesClub`.`presentation_courte`, `ClubactivitesClub`.`choix_au_groupe`, `ClubactivitesClub`.`activer_inscriptions`, `ClubactivitesClub`.`ordre` FROM `abcnatation-fr`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-fr`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '100384272' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 770
16SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`club_inscription_parametres` AS `ClubInscriptionParametre` WHERE `ClubInscriptionParametre`.`club_id` = '100384272' AND `ClubInscriptionParametre`.`activer` = '1'111
17SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`club_inscription_parametres` AS `ClubInscriptionParametre` WHERE `ClubInscriptionParametre`.`club_id` = '100384272' 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` = '100384272' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = '' ORDER BY `Content`.`position` ASC773
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` = '100384272' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'boutique' ORDER BY `Content`.`position` ASC112
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` = '100384272' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'partenaire' ORDER BY `Content`.`position` ASC002
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` = '100384272' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'footer' ORDER BY `Content`.`position` ASC002
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` = '100384272' AND ((`Content`.`content_type_id` = 7) OR (`Content`.`content_type_id` = 10)) AND `ClubPage`.`menu` = 'home' ORDER BY `Content`.`position` ASC002
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` = '100384272' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'activite' ORDER BY `Content`.`position` ASC772
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 `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
28SELECT `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
29SELECT `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
30SELECT `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
31SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 42940 000
32SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 42931 000
33SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 43034 000
34SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 43035 000
35SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 43036 000
36SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 43037 000
37SELECT `Home`.`id`, `Home`.`content_type_id`, `Home`.`content_id` FROM `abcnatation-fr`.`homes` AS `Home` WHERE `Home`.`content_id` = 43038 000
38SELECT `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` = 42940 000
39SELECT `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` = 42931 000
40SELECT `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` = 43034 000
41SELECT `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` = 43035 000
42SELECT `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` = 43036 000
43SELECT `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` = 43037 000
44SELECT `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` = 43038 000
45SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 42940 000
46SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 42931 000
47SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 43034 000
48SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 43035 000
49SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 43036 000
50SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 43037 000
51SELECT `Page`.`id`, `Page`.`content_type_id`, `Page`.`content_id` FROM `abcnatation-fr`.`pages` AS `Page` WHERE `Page`.`content_id` = 43038 000
52SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 42940 000
53SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 42931 000
54SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 43034 000
55SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 43035 000
56SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 43036 000
57SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 43037 000
58SELECT `ContactManagerContact`.`id`, `ContactManagerContact`.`content_id`, `ContactManagerContact`.`content_type_id`, `ContactManagerContact`.`coordonnee_id` FROM `abcnatation-fr`.`contacts` AS `ContactManagerContact` WHERE `ContactManagerContact`.`content_id` = 43038 000
59SELECT `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` = 42940 000
60SELECT `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` = 42931 000
61SELECT `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` = 43034 000
62SELECT `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` = 43035 000
63SELECT `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` = 43036 000
64SELECT `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` = 43037 000
65SELECT `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` = 43038 000
66SELECT `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` = 42940 110
67SELECT `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` = 42940 110
68SELECT `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` = '100384272' 110
69SELECT `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
70SELECT `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` = 42931 110
71SELECT `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` = 42931 110
72SELECT `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` = '100384272' 110
73SELECT `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
74SELECT `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` = 43034 110
75SELECT `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` = 43034 110
76SELECT `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` = '100384272' 110
77SELECT `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
78SELECT `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` = 43035 110
79SELECT `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` = 43035 110
80SELECT `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` = '100384272' 110
81SELECT `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
82SELECT `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` = 43036 110
83SELECT `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` = 43036 110
84SELECT `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` = '100384272' 110
85SELECT `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
86SELECT `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` = 43037 110
87SELECT `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` = 43037 110
88SELECT `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` = '100384272' 110
89SELECT `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
90SELECT `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` = 43038 110
91SELECT `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` = 43038 110
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` FROM `abcnatation-fr`.`clubs` AS `Club` WHERE `Club`.`id` = '100384272' 110
93SELECT `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
94SELECT `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` = '100384272' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'commission' ORDER BY `Content`.`position` ASC002
95SELECT `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` = '100384272' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'edition' ORDER BY `Content`.`position` ASC002
96SELECT `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` = '100384272' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'medias' ORDER BY `Content`.`position` ASC002
97SELECT `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` = '100384272' AND ((NOT (`Content`.`etat_id` = '0')) OR (`Content`.`etat_id` = '1'))441
98SELECT `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` = '100384272' AND `ClubactivitesClub`.`saison_id` = '2018-2019' ORDER BY `ClubactivitesClub`.`ordre` ASC770
99SELECT `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` = '100384272' AND `ClubcommissionsClub`.`saison_id` = '2018-2019' ORDER BY `ClubcommissionsClub`.`ordre` ASC000
100SELECT `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` = '100384272' AND `ClubevenementsClub`.`etat_id` = '1'003
101SELECT `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` = '100384272'111
102SELECT `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` = '100384272' AND `Content`.`content_type_id` = 7 AND `Content`.`etat_id` = '1'002
103SELECT `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` = '100384272' LIMIT 1110
104SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('100384272') 000
105SELECT `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` = '100384272' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 770
106SELECT `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` = '100384272' LIMIT 1110
107SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('100384272') 000
108SELECT `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` = '100384272' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 770
109SELECT `ClubNum`.`id`, `ClubNum`.`club_id_10`, `ClubNum`.`club_id`, `ClubNum`.`name_officiel`, `ClubNum`.`name_usuel`, `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_nums` AS `ClubNum` LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubNum`.`club_id` = `Club`.`id`) WHERE `ClubNum`.`club_id` = '100384272' LIMIT 1110
110SELECT `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` = '100384272' LIMIT 1110
111SELECT `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` = '100384272' LIMIT 1110
112SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('100384272') 000
113SELECT `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` = '100384272' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 770
114SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`club_inscription_parametres` AS `ClubInscriptionParametre` WHERE `ClubInscriptionParametre`.`club_id` = '100384272' AND `ClubInscriptionParametre`.`activer` = '1'110
115SELECT COUNT(*) AS `count` FROM `abcnatation-fr`.`club_inscription_parametres` AS `ClubInscriptionParametre` WHERE `ClubInscriptionParametre`.`club_id` = '100384272' AND `ClubInscriptionParametre`.`activer_reinscriptions` = '1'110
116SELECT `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` = '100384272' AND `ClubActu`.`epingler` = 0 AND `Content`.`etat_id` = '1' AND `ClubActu`.`cache_accueil` = '0' ORDER BY `Content`.`created` desc LIMIT 0,6441
117SELECT `ScCompetition`.`id`, `ScCompetition`.`name` FROM `abcnatation-fr`.`sc_competitions` AS `ScCompetition` WHERE `ScCompetition`.`id` IS NULL000
118SELECT `ClubevenementsClub`.`id`, `ClubevenementsClub`.`libelle` FROM `abcnatation-fr`.`clubevenements_clubs` AS `ClubevenementsClub` WHERE `ClubevenementsClub`.`id` IS NULL000
119SELECT `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` = '100384272' AND `ClubActu`.`epingler` = 1 AND `Content`.`etat_id` = '1' LIMIT 1001
120SELECT `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` = '100384272' AND `ClubActu`.`epingler` = 2 AND `Content`.`etat_id` = '1' LIMIT 1001
121SELECT `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` = '100384272' AND `ScCompetition`.`startdate` <= '2019-12-07' AND `ScCompetition`.`id` NOT LIKE '%SC-%' ORDER BY `ScCompetition`.`startdate` DESC LIMIT 0,6664
122SELECT `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` = '100384272' AND `ScCompetition`.`startdate` > '2019-12-07' ORDER BY `ScCompetition`.`startdate` asc LIMIT 0,6002
123SELECT `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`, `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` 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`) LEFT JOIN `abcnatation-fr`.`club_actus` AS `ClubActu` ON (`ClubActu`.`content_id` = `Content`.`id`) WHERE ((`ClubActu`.`club_id` = '100384272') OR (`ClubPage`.`club_id` = '100384272')) AND `Content`.`etat_id` = '1' AND `Content`.`content_type_id` = 7 ORDER BY `Content`.`created` DESC LIMIT 0,666194
124SELECT `ClubAlbumFile`.`id`, `ClubAlbumFile`.`club_album_id`, `ClubAlbumFile`.`name`, `ClubAlbumFile`.`extention_id`, `ClubAlbumFile`.`type`, `ClubAlbumFile`.`slug`, `ClubAlbumFile`.`nom_fichier`, `ClubAlbumFile`.`poids`, `ClubAlbumFile`.`dossier`, `ClubAlbumFile`.`url`, `ClubAlbumFile`.`created`, `ClubAlbumFile`.`updated`, `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_album_files` AS `ClubAlbumFile` LEFT JOIN `abcnatation-fr`.`club_albums` AS `ClubAlbum` ON (`ClubAlbumFile`.`club_album_id` = `ClubAlbum`.`id`) WHERE `ClubAlbum`.`club_id` = '100384272' AND `ClubAlbum`.`cache_accueil` = '0' ORDER BY rand() ASC LIMIT 1022266
125SELECT `ClubPartenaire`.`id`, `ClubPartenaire`.`club_id`, `ClubPartenaire`.`profil_id`, `ClubPartenaire`.`content_id`, `ClubPartenaire`.`content_type_id`, `ClubPartenaire`.`site_web`, `ClubPartenaire`.`logo`, `ClubPartenaire`.`categorie`, `ClubPartenaire`.`ordre`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`club_partenaires` AS `ClubPartenaire` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubPartenaire`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubPartenaire`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubPartenaire`.`content_type_id` = `ContentType`.`id`) WHERE `ClubPartenaire`.`club_id` = '100384272' AND `Content`.`etat_id` = '1' ORDER BY `ClubPartenaire`.`ordre` ASC551
126SELECT `ClubPartenaire`.`id`, `ClubPartenaire`.`club_id`, `ClubPartenaire`.`profil_id`, `ClubPartenaire`.`content_id`, `ClubPartenaire`.`content_type_id`, `ClubPartenaire`.`site_web`, `ClubPartenaire`.`logo`, `ClubPartenaire`.`categorie`, `ClubPartenaire`.`ordre`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`club_partenaires` AS `ClubPartenaire` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubPartenaire`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubPartenaire`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubPartenaire`.`content_type_id` = `ContentType`.`id`) WHERE `ClubPartenaire`.`club_id` = '100384272' AND `Content`.`etat_id` = '1' AND `ClubPartenaire`.`categorie` = 1 ORDER BY `ClubPartenaire`.`ordre` ASC001
127SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`menu_id` = '1' AND `Content`.`etat_id` = '1' AND `Content`.`content_type_id` IN (1, 2, 3, 4) ORDER BY `lft` ASC3683681
128SELECT `Content`.`lft`, `Content`.`rght` FROM `abcnatation-fr`.`contents` AS `Content` WHERE `Content`.`id` = '' LIMIT 1000
129SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`content_type_id` IN (1, 2, 3, 4) AND `Content`.`menu_id` = '1' AND `Content`.`etat_id` = '1' AND `Content`.`parent_id` IS NULL ORDER BY `Content`.`lft` ASC3503501
130SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`content_types` AS `ContentType` WHERE 1 = 110100
131SELECT `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` = 'cnmoirans.com' LIMIT 1110
132SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('100384272') 000
133SELECT `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` = '100384272' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 770
134SELECT `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
135SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC990
136SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-fr`.`contents` AS `Content` LEFT JOIN `abcnatation-fr`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-fr`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-fr`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '100384272' AND `Content`.`content_type_id` = 7 ORDER BY `Content`.`position` ASC15153
137SELECT `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` = '100384272' LIMIT 1110
138SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('100384272') 000
139SELECT `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` = '100384272' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 770
140SELECT `Droits`.`libelle`, `Droits`.`masque` FROM `abcnatation-fr`.`droits` AS `Droits` WHERE 1 = 122220
141SELECT `ClubPartenaire`.`id`, `ClubPartenaire`.`club_id`, `ClubPartenaire`.`profil_id`, `ClubPartenaire`.`content_id`, `ClubPartenaire`.`content_type_id`, `ClubPartenaire`.`site_web`, `ClubPartenaire`.`logo`, `ClubPartenaire`.`categorie`, `ClubPartenaire`.`ordre`, `Content`.`id`, `Content`.`content_type_id`, `Content`.`etat_id`, `Content`.`menu_id`, `Content`.`vignette_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`position`, `Content`.`meta_keywords`, `Content`.`meta_description`, `Content`.`meta_title`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`resume`, `Content`.`body`, `Content`.`group_id`, `Content`.`created`, `Content`.`updated`, `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-fr`.`club_partenaires` AS `ClubPartenaire` LEFT JOIN `abcnatation-fr`.`contents` AS `Content` ON (`ClubPartenaire`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-fr`.`clubs` AS `Club` ON (`ClubPartenaire`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-fr`.`content_types` AS `ContentType` ON (`ClubPartenaire`.`content_type_id` = `ContentType`.`id`) WHERE `ClubPartenaire`.`club_id` = '100384272' AND `Content`.`etat_id` = '1' ORDER BY `ClubPartenaire`.`ordre` ASC550