Notice (8): Undefined index: cache_pictos_menu [APP/Plugin/SiteClub/Controller/SiteClubAppController.php, line 178]
Notice (8): Undefined index: actualites [APP/Plugin/SiteClub/Controller/SiteClubAppController.php, line 237]
CN VITRÉ - Actualités // Abcnatation

Actualités

(default) 31 queries took 25 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-com`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC440
2SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-com`.`saisons` AS `Saison` WHERE `date_debut` <= '2014-04-19' AND `date_fin` > '2014-04-19' LIMIT 1110
3SELECT `Club`.`id`, `Club`.`statut`, `Club`.`name`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_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`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `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`, `Coordonnee`.`id`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`region_id`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id_region`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `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`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled` FROM `abcnatation-com`.`clubs` AS `Club` LEFT JOIN `abcnatation-com`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-com`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-com`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-com`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-com`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-com`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE ((`Club`.`sous_domaine` = '050353950') OR (`Club`.`id` = '050353950')) LIMIT 1111
4SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-com`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('050353950') 000
5SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation` FROM `abcnatation-com`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-com`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '050353950' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 000
6SELECT `SiteWeb`.`id`, `SiteWeb`.`club_id`, `SiteWeb`.`url_bandeau`, `SiteWeb`.`saison_id`, `SiteWeb`.`degroupe_menu_activite`, `SiteWeb`.`actualites`, `SiteWeb`.`cache_auteur_actu`, `SiteWeb`.`cache_pictos_menu` FROM `abcnatation-com`.`site_webs` AS `SiteWeb` WHERE `SiteWeb`.`club_id` = '050353950' LIMIT 1000
7SELECT `SiteWeb`.`id`, `SiteWeb`.`club_id`, `SiteWeb`.`url_bandeau`, `SiteWeb`.`saison_id`, `SiteWeb`.`degroupe_menu_activite`, `SiteWeb`.`actualites`, `SiteWeb`.`cache_auteur_actu`, `SiteWeb`.`cache_pictos_menu` FROM `abcnatation-com`.`site_webs` AS `SiteWeb` WHERE `SiteWeb`.`club_id` = '050353950' LIMIT 1000
8SELECT `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-com`.`contents` AS `Content` LEFT JOIN `abcnatation-com`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-com`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-com`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-com`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '050353950' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = '' ORDER BY `Content`.`position` ASC001
9SELECT `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-com`.`contents` AS `Content` LEFT JOIN `abcnatation-com`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-com`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-com`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-com`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '050353950' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = '' ORDER BY `Content`.`position` ASC000
10SELECT `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-com`.`contents` AS `Content` LEFT JOIN `abcnatation-com`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-com`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-com`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-com`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '050353950' AND ((`Content`.`content_type_id` = 7) OR (`Content`.`content_type_id` = 10)) AND `ClubPage`.`menu` = 'home' ORDER BY `Content`.`position` ASC000
11SELECT `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-com`.`contents` AS `Content` LEFT JOIN `abcnatation-com`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-com`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-com`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-com`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '050353950' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'activite' ORDER BY `Content`.`position` ASC000
12SELECT `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-com`.`contents` AS `Content` LEFT JOIN `abcnatation-com`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-com`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-com`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-com`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '050353950' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'edition' ORDER BY `Content`.`position` ASC001
13SELECT `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-com`.`contents` AS `Content` LEFT JOIN `abcnatation-com`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-com`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-com`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-com`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '050353950' AND `Content`.`content_type_id` = 7 AND `ClubPage`.`menu` = 'medias' ORDER BY `Content`.`position` ASC000
14SELECT `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `Clubevenement`.`id`, `Clubevenement`.`description` FROM `abcnatation-com`.`clubevenements_clubs` AS `ClubevenementsClub` LEFT JOIN `abcnatation-com`.`clubevenements` AS `Clubevenement` ON (`ClubevenementsClub`.`clubevenement_id` = `Clubevenement`.`id`) WHERE `ClubevenementsClub`.`club_id` = '050353950' AND `ClubevenementsClub`.`etat_id` = '1'000
15SELECT `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation` FROM `abcnatation-com`.`clubactivites_clubs` AS `ClubactivitesClub` WHERE `ClubactivitesClub`.`club_id` = '050353950' AND `ClubactivitesClub`.`saison_id` = '2013-2014' ORDER BY `ClubactivitesClub`.`id` ASC000
16SELECT `ClubAlbum`.`id`, `ClubAlbum`.`name`, `ClubAlbum`.`description`, `ClubAlbum`.`club_id`, `ClubAlbum`.`date`, `ClubAlbum`.`created`, `ClubAlbum`.`updated` FROM `abcnatation-com`.`club_albums` AS `ClubAlbum` WHERE `ClubAlbum`.`club_id` = '050353950'000
17SELECT `Club`.`id`, `Club`.`statut`, `Club`.`name`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_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`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `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`, `Coordonnee`.`id`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`region_id`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id_region`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `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`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled` FROM `abcnatation-com`.`clubs` AS `Club` LEFT JOIN `abcnatation-com`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-com`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-com`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-com`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-com`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-com`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`id` = '050353950' LIMIT 1111
18SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-com`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('050353950') 000
19SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation` FROM `abcnatation-com`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-com`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '050353950' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 000
20SELECT `ClubActu`.`id`, `ClubActu`.`club_id`, `ClubActu`.`profil_id`, `ClubActu`.`content_id`, `ClubActu`.`epingler`, `ClubActu`.`image`, `ClubActu`.`content_type_id`, `ClubActu`.`clubactivites_club_id`, `ClubActu`.`club_group_id`, `ClubActu`.`clubevenements_club_id`, `ClubActu`.`clubedition_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`.`name`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_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`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `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`, `ClubevenementsClub`.`id`, `ClubevenementsClub`.`etat_id`, `ClubevenementsClub`.`clubevenement_id`, `ClubevenementsClub`.`club_id`, `ClubevenementsClub`.`libelle`, `ClubevenementsClub`.`presentation`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation`, `ClubGroup`.`id`, `ClubGroup`.`nom`, `ClubGroup`.`saison_id`, `ClubGroup`.`club_id`, `ClubGroup`.`clubactivites_club_id`, `ClubGroup`.`club_niveau_pratique_id`, `ClubGroup`.`inscription_niveau_seance`, `ClubGroup`.`age_min`, `ClubGroup`.`age_max`, `ClubGroup`.`nbr_place`, `ClubGroup`.`obj_sportif`, `ClubGroup`.`parent_id`, `ClubGroup`.`rght`, `ClubGroup`.`lft`, `ClubGroup`.`affiche_membres`, `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`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled` FROM `abcnatation-com`.`club_actus` AS `ClubActu` LEFT JOIN `abcnatation-com`.`contents` AS `Content` ON (`ClubActu`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`clubs` AS `Club` ON (`ClubActu`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-com`.`clubevenements_clubs` AS `ClubevenementsClub` ON (`ClubActu`.`clubevenements_club_id` = `ClubevenementsClub`.`id`) LEFT JOIN `abcnatation-com`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubActu`.`clubactivites_club_id` = `ClubactivitesClub`.`id`) LEFT JOIN `abcnatation-com`.`club_groups` AS `ClubGroup` ON (`ClubActu`.`club_group_id` = `ClubGroup`.`id`) LEFT JOIN `abcnatation-com`.`content_types` AS `ContentType` ON (`ClubActu`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-com`.`profils` AS `Profil` ON (`ClubActu`.`profil_id` = `Profil`.`id`) WHERE `ClubActu`.`club_id` = '050353950' AND `ClubActu`.`epingler` = '0' AND `Content`.`etat_id` = '1' ORDER BY `Content`.`created` desc001
21SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-com`.`contents` AS `Content` LEFT JOIN `abcnatation-com`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-com`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-com`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-com`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`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` ASC84849
22SELECT `Content`.`lft`, `Content`.`rght` FROM `abcnatation-com`.`contents` AS `Content` WHERE `Content`.`id` = '' LIMIT 1000
23SELECT `Content`.`id`, `Content`.`etat_id`, `Content`.`parent_id`, `Content`.`content_type_id`, `Content`.`url`, `Content`.`non_cliquable`, `Content`.`slug`, `Content`.`h1`, `Content`.`nom_raccourci`, `Content`.`created`, `Content`.`updated` FROM `abcnatation-com`.`contents` AS `Content` LEFT JOIN `abcnatation-com`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-com`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-com`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-com`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`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` ASC49498
24SELECT `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-com`.`content_types` AS `ContentType` WHERE 1 = 110100
25SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-com`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC440
26SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-com`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC440
27SELECT `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-com`.`contents` AS `Content` LEFT JOIN `abcnatation-com`.`media` AS `Vignette` ON (`Content`.`vignette_id` = `Vignette`.`id`) LEFT JOIN `abcnatation-com`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `abcnatation-com`.`groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `abcnatation-com`.`homes` AS `Home` ON (`Home`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`mentions_legales` AS `MentionsLegale` ON (`MentionsLegale`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`pages` AS `Page` ON (`Page`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`contacts` AS `ContactManagerContact` ON (`ContactManagerContact`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`media` AS `MediaManagerMedia` ON (`MediaManagerMedia`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`club_pages` AS `ClubPage` ON (`ClubPage`.`content_id` = `Content`.`id`) WHERE `Content`.`etat_id` = '1' AND `ClubPage`.`club_id` = '050353950' AND `Content`.`content_type_id` = 7 ORDER BY `Content`.`position` ASC001
28SELECT `Club`.`id`, `Club`.`statut`, `Club`.`name`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_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`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `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`, `Coordonnee`.`id`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`region_id`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id_region`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `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`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled` FROM `abcnatation-com`.`clubs` AS `Club` LEFT JOIN `abcnatation-com`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-com`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-com`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-com`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-com`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-com`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`id` = '050353950' LIMIT 1111
29SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-com`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` = ('050353950') 000
30SELECT `ClubActiv`.`id`, `ClubActiv`.`description`, `ClubactivitesClub`.`id`, `ClubactivitesClub`.`clubactivite_id`, `ClubactivitesClub`.`club_id`, `ClubactivitesClub`.`libelle`, `ClubactivitesClub`.`saison_id`, `ClubactivitesClub`.`cotisation`, `ClubactivitesClub`.`presentation` FROM `abcnatation-com`.`clubactivites` AS `ClubActiv` JOIN `abcnatation-com`.`clubactivites_clubs` AS `ClubactivitesClub` ON (`ClubactivitesClub`.`club_id` = '050353950' AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 000
31SELECT `ClubPartenaire`.`id`, `ClubPartenaire`.`club_id`, `ClubPartenaire`.`profil_id`, `ClubPartenaire`.`content_id`, `ClubPartenaire`.`content_type_id`, `ClubPartenaire`.`site_web`, `ClubPartenaire`.`logo`, `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`.`name`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_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`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `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`, `ContentType`.`id`, `ContentType`.`name`, `ContentType`.`slug`, `ContentType`.`controleur`, `ContentType`.`description`, `ContentType`.`icon`, `ContentType`.`ordre`, `ContentType`.`sous_type` FROM `abcnatation-com`.`club_partenaires` AS `ClubPartenaire` LEFT JOIN `abcnatation-com`.`contents` AS `Content` ON (`ClubPartenaire`.`content_id` = `Content`.`id`) LEFT JOIN `abcnatation-com`.`clubs` AS `Club` ON (`ClubPartenaire`.`club_id` = `Club`.`id`) LEFT JOIN `abcnatation-com`.`content_types` AS `ContentType` ON (`ClubPartenaire`.`content_type_id` = `ContentType`.`id`) WHERE `ClubPartenaire`.`club_id` = '050353950' AND `Content`.`etat_id` = '1' ORDER BY `ClubPartenaire`.`ordre` ASC001