Annuaire des clubs

Cette icône indique que le club a un site web Abcnatation
Cette icône indique que le club a un site web Abcnatation en construction

Numéro
Nom
Département
Page 16 sur 28. Résultat 751 sur 800 (total 1351)
12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Nom Département Type
240653581 DAUPHINS ARGELÈS-GAZOST Hautes-Pyrénées Club FFN Voir sa page
240652490 DAUPHINS BAGNÈRES-DE-BIGORRE Hautes-Pyrénées Club FFN Voir sa page
240463936 DAUPHINS CANTON PUY-L'EVÊQUE Lot Club FFN Voir sa page
220863520 DAUPHINS CHÂTELLERAULT Vienne Club FFN Voir sa page
140349310 DAUPHINS CLERMONT-L'HÉRAULT Hérault Club FFN Voir sa page
170422512 DAUPHINS COSTELLOIS Loire Club FFN Voir sa page
130943358 DAUPHINS CRETEIL Val-de-Marne Club FFN Voir sa page
180594179 DAUPHINS DE LOOS-HAUBOURDIN Nord Club FFN Voir sa page
200532323 DAUPHINS DE MAYENNE Mayenne Club FFN Voir sa page
160573771 DAUPHINS DE NILVANGE Moselle Club FFN Voir sa page
010682848 DAUPHINS DE ST-LOUIS Haut-Rhin Club FFN Voir sa page
240123266 DAUPHINS DECAZEVILLE Aveyron Club FFN Voir sa page
050293733 DAUPHINS ELORN LANDERNEAU Finistère Club FFN Voir sa page
230054002 DAUPHINS EMBRUNAIS Hautes-Alpes Club FFN Voir sa page
100383124 DAUPHINS EYZIN-PINET Isère Club FFN Voir sa page
140340556 DAUPHINS FC SÈTE Hérault Club FFN Voir sa page
100073810 DAUPHINS GRANGES-LES-VALENCE Ardèche Club FFN Voir sa page
150233696 DAUPHINS GUÉRET Creuse Club FFN Voir sa page
140302802 DAUPHINS LA GRAND-COMBE Gard Club FFN Voir sa page
230133791 DAUPHINS LES PENNES-MIRABEAU Bouches du Rhône Club FFN Voir sa page
180629856 DAUPHINS LIÉVIN Pas-de-Calais Club FFN Voir sa page
120702734 DAUPHINS LURE Haute-Saône Club FFN Voir sa page
220179311 DAUPHINS MARANS Charente-Maritime Club FFN Voir sa page
100384068 DAUPHINS MATHEYSINS Isère Club FFN Voir sa page
230133154 DAUPHINS MIRAMAS Bouches du Rhône Club FFN Voir sa page
100264357 DAUPHINS MONTÉLIMAR Drôme Club FFN Voir sa page
240823463 DAUPHINS MONTAUBAN Tarn-et-Garonne Club FFN Voir sa page
010673814 DAUPHINS OBERNAI Bas-Rhin Club FFN Voir sa page
220173370 DAUPHINS PONS Charente-Maritime Club FFN Voir sa page
020243253 DAUPHINS SARLAT Dordogne Club FFN Voir sa page
020403041 DAUPHINS ST-PIERRE-DU-MONT Landes Club FFN Voir sa page
220794224 DAUPHINS ST-VARENT Deux-Sèvres Club FFN Voir sa page
050294390 DAUPHINS ST-YVI Finistère Club FFN Voir sa page
200490143 DAUPHINS VERNOIS Maine-et-Loire Club FFN Voir sa page
030031294 DAUPHINS VICHY-BELLERIVE Allier Club FFN Voir sa page
030433413 DAUPHINS YSSINGEAUX Haute-Loire Club FFN Voir sa page
180594138 DC BOUSSOIS RECQUIGNIES Nord Club FFN Voir sa page
190769544 DC FAUVILLE-EN-CAUX Seine-Maritime Club FFN Voir sa page
180595962 DENAIN NATATION - PORTE DU HAINAUT Nord Club FFN Voir sa page
050352863 DINARD OLYMPIQUE N Ile-et-Vilaine Club FFN Voir sa page
190504394 DISTRICT LES PIEUX NATATION Manche Club FFN Voir sa page
050350001 DOL NATATION Ile-et-Vilaine Club FFN Voir sa page
050293890 DOUARNENEZ NATATION Finistère Club FFN Voir sa page
259880001 DUMBEA NATATION Club FFN Voir sa page
040210002 E.N MONTBARDOISE Côte-d'Or Club FFN Voir sa page
240650001 E.P SEMEAC TARBES NAT Hautes-Pyrénées Club FFN Voir sa page
130770008 E.S VERNOUCELLOISE Seine-et-Marne Club FFN Voir sa page
060364366 EA ISSOUDUN NATATION Indre Club FFN Voir sa page
050353986 ECN CHARTRES-DE-BRETAGNE Ile-et-Vilaine Club FFN Voir sa page
200440027 ECOLE NANTAISE DE NATATION Loire-Atlantique Club FFN Voir sa page
Page 16 sur 28. Résultat 751 sur 800 (total 1351)
12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
(default) 15 queries took 85 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Club`.`id`, `Club`.`statut`, `Club`.`abonne_depuis`, `Club`.`name`, `Club`.`name_officiel`, `Club`.`offre_v2`, `Club`.`siret`, `Club`.`cnil`, `Club`.`agrement`, `Club`.`code_parrain`, `Club`.`nation`, `Club`.`correspondant_licencie_id`, `Club`.`scf_structure_type_id`, `Club`.`scf_structure_statut_id`, `Club`.`sport_id`, `Club`.`profil_id`, `Club`.`coordonnee_id`, `Club`.`departement_id`, `Club`.`region_id`, `Club`.`correspondant`, `Club`.`content_id`, `Club`.`content_type_id`, `Club`.`maj_ffn`, `Club`.`maj_csv`, `Club`.`logo_upload`, `Club`.`signature_upload`, `Club`.`site_web`, `Club`.`sous_domaine`, `Club`.`assurance`, `Club`.`label`, `Club`.`email`, `Club`.`email_webmaster`, `Club`.`email_expediteur`, `Club`.`option_membre_illimite`, `Club`.`option_scoring_pro`, `Club`.`option_inscriptions`, `Club`.`option_convocations`, `Club`.`option_domaine`, `Club`.`date_fin_membre_illimite`, `Club`.`date_fin_scoring_pro`, `Club`.`date_fin_inscriptions`, `Club`.`date_fin_convocations`, `Club`.`date_fin_option_domaine`, `Club`.`date_fin_site_web`, `Club`.`forcer_recevoir_news`, `Club`.`IdCISS`, `Club`.`PassCISS`, `Club`.`idWallet`, `Club`.`url_swimcommunity`, `Club`.`activer_sc`, `Club`.`activer_pagesc`, `Club`.`txtbtn_swimcommunity`, `Club`.`h1_sc`, `Club`.`page1_swimcommunity`, `Club`.`page2_swimcommunity`, `Coordonnee`.`id`, `Coordonnee`.`numero`, `Coordonnee`.`contact_id`, `Coordonnee`.`adresse_1`, `Coordonnee`.`adresse_2`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`departement_id`, `Coordonnee`.`departement`, `Coordonnee`.`region_id`, `Coordonnee`.`region`, `Coordonnee`.`countrie_id`, `Coordonnee`.`pays_id`, `Coordonnee`.`pays`, `Coordonnee`.`tel_1`, `Coordonnee`.`tel_2`, `Coordonnee`.`mobile`, `Coordonnee`.`email`, `Coordonnee`.`site_web`, `Coordonnee`.`facebook`, `Coordonnee`.`twitter`, `Coordonnee`.`googleplus`, `Coordonnee`.`fax`, `ScfStructureType`.`id`, `ScfStructureType`.`description`, `ScfStructureType`.`sport_id`, `ScfStructureType`.`le`, `ScfStructureType`.`de`, `ScfStructureStatut`.`id`, `ScfStructureStatut`.`description`, `Departement`.`id`, `Departement`.`name_province`, `Departement`.`name_province_uppercase`, `Departement`.`province_slug`, `Departement`.`id_region`, `Region`.`id`, `Region`.`name`, `Profil`.`id`, `Profil`.`email`, `Profil`.`prenom`, `Profil`.`nom`, `Profil`.`nom_connexion`, `Profil`.`login`, `Profil`.`password`, `Profil`.`pass`, `Profil`.`coordonnee_id`, `Profil`.`club_id`, `Profil`.`group_id`, `Profil`.`licence_id`, `Profil`.`auto`, `Profil`.`created`, `Profil`.`updated`, `Profil`.`verified`, `Profil`.`disabled`, `Profil`.`previous` FROM `abcnatation-fr`.`clubs` AS `Club` LEFT JOIN `abcnatation-fr`.`coordonnees` AS `Coordonnee` ON (`Club`.`coordonnee_id` = `Coordonnee`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` ON (`Club`.`scf_structure_type_id` = `ScfStructureType`.`id`) LEFT JOIN `abcnatation-fr`.`scf_structure_statuts` AS `ScfStructureStatut` ON (`Club`.`scf_structure_statut_id` = `ScfStructureStatut`.`id`) LEFT JOIN `abcnatation-fr`.`departements` AS `Departement` ON (`Club`.`departement_id` = `Departement`.`id`) LEFT JOIN `abcnatation-fr`.`regions` AS `Region` ON (`Club`.`region_id` = `Region`.`id`) LEFT JOIN `abcnatation-fr`.`profils` AS `Profil` ON (`Club`.`profil_id` = `Profil`.`id`) WHERE `Club`.`sous_domaine` = 'abcnatation.fr' LIMIT 1000
2SELECT `Clubs`.`id`, `Clubs`.`statut`, `Clubs`.`abonne_depuis`, `Clubs`.`name`, `Clubs`.`name_officiel`, `Clubs`.`offre_v2`, `Clubs`.`siret`, `Clubs`.`cnil`, `Clubs`.`agrement`, `Clubs`.`code_parrain`, `Clubs`.`nation`, `Clubs`.`correspondant_licencie_id`, `Clubs`.`scf_structure_type_id`, `Clubs`.`scf_structure_statut_id`, `Clubs`.`sport_id`, `Clubs`.`profil_id`, `Clubs`.`coordonnee_id`, `Clubs`.`departement_id`, `Clubs`.`region_id`, `Clubs`.`correspondant`, `Clubs`.`content_id`, `Clubs`.`content_type_id`, `Clubs`.`maj_ffn`, `Clubs`.`maj_csv`, `Clubs`.`logo_upload`, `Clubs`.`signature_upload`, `Clubs`.`site_web`, `Clubs`.`sous_domaine`, `Clubs`.`assurance`, `Clubs`.`label`, `Clubs`.`email`, `Clubs`.`email_webmaster`, `Clubs`.`email_expediteur`, `Clubs`.`option_membre_illimite`, `Clubs`.`option_scoring_pro`, `Clubs`.`option_inscriptions`, `Clubs`.`option_convocations`, `Clubs`.`option_domaine`, `Clubs`.`date_fin_membre_illimite`, `Clubs`.`date_fin_scoring_pro`, `Clubs`.`date_fin_inscriptions`, `Clubs`.`date_fin_convocations`, `Clubs`.`date_fin_option_domaine`, `Clubs`.`date_fin_site_web`, `Clubs`.`forcer_recevoir_news`, `Clubs`.`IdCISS`, `Clubs`.`PassCISS`, `Clubs`.`idWallet`, `Clubs`.`url_swimcommunity`, `Clubs`.`activer_sc`, `Clubs`.`activer_pagesc`, `Clubs`.`txtbtn_swimcommunity`, `Clubs`.`h1_sc`, `Clubs`.`page1_swimcommunity`, `Clubs`.`page2_swimcommunity` FROM `abcnatation-fr`.`clubs` AS `Clubs` WHERE `Clubs`.`id` IS NULL LIMIT 1000
3SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE 1 = 1 ORDER BY `date_debut` DESC990
4SELECT `SiteWeb`.`id`, `SiteWeb`.`club_id`, `SiteWeb`.`statut`, `SiteWeb`.`url_bandeau`, `SiteWeb`.`msg_bandeau`, `SiteWeb`.`saison_id`, `SiteWeb`.`degroupe_menu_activite`, `SiteWeb`.`degroupe_menu_evenements`, `SiteWeb`.`degroupe_menu_commissions`, `SiteWeb`.`actualites`, `SiteWeb`.`cache_auteur_actu`, `SiteWeb`.`cache_pictos_menu`, `SiteWeb`.`cache_accueil`, `SiteWeb`.`cache_email`, `SiteWeb`.`publication`, `SiteWeb`.`cache_email_web`, `SiteWeb`.`nom_medias`, `SiteWeb`.`widget_part`, `SiteWeb`.`widget_part_top_position`, `SiteWeb`.`widget_photos`, `SiteWeb`.`widget_res`, `SiteWeb`.`widget_pages`, `SiteWeb`.`widget_cal`, `SiteWeb`.`widget_act`, `SiteWeb`.`gestion_droits`, `SiteWeb`.`boutique`, `SiteWeb`.`forcer_recevoir_news`, `SiteWeb`.`flickr_user_id`, `SiteWeb`.`template`, `SiteWeb`.`recaptcha`, `SiteWeb`.`meta_description` FROM `abcnatation-fr`.`site_webs` AS `SiteWeb` WHERE `SiteWeb`.`club_id` IS NULL LIMIT 1000
5SELECT `Saison`.`id`, `Saison`.`name`, `Saison`.`date_debut`, `Saison`.`date_fin` FROM `abcnatation-fr`.`saisons` AS `Saison` WHERE `date_debut` <= '2019-12-07' AND `date_fin` > '2019-12-07' LIMIT 1110
6SELECT `ScfStructureType`.`id`, `ScfStructureType`.`description` FROM `abcnatation-fr`.`scf_structure_types` AS `ScfStructureType` WHERE 1 = 119190
7SELECT `Departement`.`id`, `Departement`.`name_province` FROM `abcnatation-fr`.`departements` AS `Departement` WHERE 1 = 1 ORDER BY `Departement`.`name_province` asc1031031
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`.`id` REGEXP '^[a-zA-Z0-9]{9,9}$' AND ((`Club`.`scf_structure_type_id` = 3) OR (`Club`.`scf_structure_type_id` = 4) OR (`Club`.`scf_structure_type_id` = 99)) AND ((NOT (`Club`.`statut` = 'ancien')) AND (NOT (`Club`.`statut` = 'ancien_testeur'))) ORDER BY `Club`.`site_web` DESC, `Club`.`statut` ASC, `Club`.`name` ASC LIMIT 750, 50505060
9SELECT `Piscine`.`id`, `Piscine`.`nom`, `Piscine`.`coordonnee_id`, `Piscine`.`club_id` FROM `abcnatation-fr`.`piscines` AS `Piscine` WHERE `Piscine`.`club_id` IN ('240653581', '240652490', '240463936', '220863520', '140349310', '170422512', '130943358', '180594179', '200532323', '160573771', '010682848', '240123266', '050293733', '230054002', '100383124', '140340556', '100073810', '150233696', '140302802', '230133791', '180629856', '120702734', '220179311', '100384068', '230133154', '100264357', '240823463', '010673814', '220173370', '020243253', '020403041', '220794224', '050294390', '200490143', '030031294', '030433413', '180594138', '190769544', '180595962', '050352863', '190504394', '050350001', '050293890', '259880001', '040210002', '240650001', '130770008', '060364366', '050353986', '200440027') 220
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` IN ('240653581', '240652490', '240463936', '220863520', '140349310', '170422512', '130943358', '180594179', '200532323', '160573771', '010682848', '240123266', '050293733', '230054002', '100383124', '140340556', '100073810', '150233696', '140302802', '230133791', '180629856', '120702734', '220179311', '100384068', '230133154', '100264357', '240823463', '010673814', '220173370', '020243253', '020403041', '220794224', '050294390', '200490143', '030031294', '030433413', '180594138', '190769544', '180595962', '050352863', '190504394', '050350001', '050293890', '259880001', '040210002', '240650001', '130770008', '060364366', '050353986', '200440027') AND `ClubactivitesClub`.`clubactivite_id` = `ClubActiv`.`id`) 111
11SELECT COUNT(*) AS `count` 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` REGEXP '^[a-zA-Z0-9]{9,9}$' AND ((`Club`.`scf_structure_type_id` = 3) OR (`Club`.`scf_structure_type_id` = 4) OR (`Club`.`scf_structure_type_id` = 99)) AND ((NOT (`Club`.`statut` = 'ancien')) AND (NOT (`Club`.`statut` = 'ancien_testeur')))1121
12SELECT `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
13SELECT `Content`.`lft`, `Content`.`rght` FROM `abcnatation-fr`.`contents` AS `Content` WHERE `Content`.`id` = '' LIMIT 1000
14SELECT `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
15SELECT `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