Mallette pédagogique - Sarbacane



Réseau FFH uniquement

Auteur(s) Fédération Française Handisport
Publication ARTEI Communication • 2013
Langue(s) Français
Résumé Vidéo pédagogique comprenant l'essentiel de l'activité
Sommaire - Présentation de l'activité - Le matériel - Situations pédagogiques
Thématique(s) Pédagogie Matériel
Handicap(s) Handicap moteur
Sport(s) Sarbacane
Cible(s) Etudiants Cadres sportifs Structures fédérales
Disponibilité Document intégral En téléchargement
Format(s) Vidéo Numérique
Mis en ligne le 23 Novembre 2018


Retour

(production) 21 queries took 765 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Document`.`id`, `Document`.`code`, `Document`.`code_papier`, `Document`.`code_papier2`, `Document`.`event_id`, `Document`.`type`, `Document`.`type_redactionnel_old`, `Document`.`type_redactionnel`, `Document`.`categorie`, `Document`.`name`, `Document`.`authors`, `Document`.`publication`, `Document`.`pages`, `Document`.`exemplaires`, `Document`.`url`, `Document`.`url_key`, `Document`.`thumb_url`, `Document`.`thumb_url_key`, `Document`.`thumb_url_media`, `Document`.`url_doc_complet`, `Document`.`disponibilite`, `Document`.`created`, `Document`.`user_create_id`, `Document`.`modified`, `Document`.`user_modify_id`, `Document`.`resume`, `Document`.`resume_full`, `Document`.`sommaire`, `Document`.`commentaires_pierre`, `Document`.`commentaires`, `Document`.`published`, `Document`.`user_publish_id`, `Document`.`annee`, `Document`.`validate`, `Document`.`user_validate_id`, `Document`.`url_medias`, `Document`.`proposed`, `Document`.`doute_proposed`, `Document`.`doute`, `Document`.`user_proposed_id`, `Document`.`blocked`, `Document`.`motif_blocked`, `Document`.`verified_by_pierre`, `Document`.`reseau_ffh`, `Document`.`une_ressources`, `Document`.`mis_en_avant`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_create_id`) AS `Document__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_modify_id`) AS `Document__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_validate_id`) AS `Document__UVY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_publish_id`) AS `Document__UPY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_proposed_id`) AS `Document__UPR`, (SELECT `E`.`NAME` FROM events E where `E`.`id` = `Document`.`event_id`) AS `Document__EVNAME`, (SELECT photo_thumb FROM annuaires A where `A`.`user_id` = `Document`.`user_create_id` group by `A`.`id`) AS `Document__UCR_thumb` FROM `ExtranetFFH`.`documents` AS `Document` WHERE `Document`.`id` = 2340 ORDER BY `annee` DESC, `name` ASC LIMIT 1115
2SELECT `DocumentsTheme`.`id`, `DocumentsTheme`.`document_id`, `DocumentsTheme`.`theme_id`, `DocumentsTheme`.`created`, `DocumentsTheme`.`user_create_id`, `DocumentsTheme`.`rang`, `DocumentsTheme`.`theme_id_old`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `DocumentsTheme`.`user_create_id`) AS `DocumentsTheme__UCR` FROM `ExtranetFFH`.`documents_themes` AS `DocumentsTheme` WHERE `DocumentsTheme`.`document_id` = (2340)220
3SELECT `Theme`.`id`, `Theme`.`name`, `Theme`.`created`, `Theme`.`modified` FROM `ExtranetFFH`.`themes` AS `Theme` WHERE `Theme`.`id` = 3110
4SELECT `Theme`.`id`, `Theme`.`name`, `Theme`.`created`, `Theme`.`modified` FROM `ExtranetFFH`.`themes` AS `Theme` WHERE `Theme`.`id` = 8110
5SELECT `DocumentsLangue`.`id`, `DocumentsLangue`.`document_id`, `DocumentsLangue`.`langue_id`, `DocumentsLangue`.`user_create_id`, `DocumentsLangue`.`created`, `DocumentsLangue`.`rang`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `DocumentsLangue`.`user_create_id`) AS `DocumentsLangue__UCR` FROM `ExtranetFFH`.`documents_langues` AS `DocumentsLangue` WHERE `DocumentsLangue`.`document_id` = (2340)110
6SELECT `Langue`.`id`, `Langue`.`name`, `Langue`.`created`, `Langue`.`modified` FROM `ExtranetFFH`.`langues` AS `Langue` WHERE `Langue`.`id` = 1110
7SELECT `DocumentsCible`.`id`, `DocumentsCible`.`document_id`, `DocumentsCible`.`cible_id`, `DocumentsCible`.`user_create_id`, `DocumentsCible`.`created`, `DocumentsCible`.`rang`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `DocumentsCible`.`user_create_id`) AS `DocumentsCible__UCR` FROM `ExtranetFFH`.`documents_cibles` AS `DocumentsCible` WHERE `DocumentsCible`.`document_id` = (2340)330
8SELECT `Cible`.`id`, `Cible`.`name`, `Cible`.`created`, `Cible`.`modified` FROM `ExtranetFFH`.`cibles` AS `Cible` WHERE `Cible`.`id` = 2110
9SELECT `Cible`.`id`, `Cible`.`name`, `Cible`.`created`, `Cible`.`modified` FROM `ExtranetFFH`.`cibles` AS `Cible` WHERE `Cible`.`id` = 4110
10SELECT `Cible`.`id`, `Cible`.`name`, `Cible`.`created`, `Cible`.`modified` FROM `ExtranetFFH`.`cibles` AS `Cible` WHERE `Cible`.`id` = 5110
11SELECT `DocumentsFormat`.`id`, `DocumentsFormat`.`document_id`, `DocumentsFormat`.`format_id_old`, `DocumentsFormat`.`format_id`, `DocumentsFormat`.`user_create_id`, `DocumentsFormat`.`created`, `DocumentsFormat`.`rang`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `DocumentsFormat`.`user_create_id`) AS `DocumentsFormat__UCR` FROM `ExtranetFFH`.`documents_formats` AS `DocumentsFormat` WHERE `DocumentsFormat`.`document_id` = (2340)110
12SELECT `Format`.`id`, `Format`.`name`, `Format`.`created`, `Format`.`modified` FROM `ExtranetFFH`.`formats` AS `Format` WHERE `Format`.`id` = 4110
13SELECT `DocumentsSport`.`id`, `DocumentsSport`.`document_id`, `DocumentsSport`.`sport_id`, `DocumentsSport`.`user_create_id`, `DocumentsSport`.`created`, `DocumentsSport`.`rang`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `DocumentsSport`.`user_create_id`) AS `DocumentsSport__UCR` FROM `ExtranetFFH`.`documents_sports` AS `DocumentsSport` WHERE `DocumentsSport`.`document_id` = (2340)110
14SELECT `Sport`.`id`, `Sport`.`active_ressources`, `Sport`.`active`, `Sport`.`name`, `Sport`.`order`, `Sport`.`DisciplineEtat`, `Sport`.`DisciplineEstCompetion`, `Sport`.`DisciplineLabel`, `Sport`.`DisciplineElh`, `Sport`.`DisciplineSportCo`, `Sport`.`DisciplineAdversaire`, `Sport`.`DisciplineRecord`, `Sport`.`DisciplineCategorie`, `Sport`.`DisciplineRegate`, `Sport`.`DisciplineParalympique`, `Sport`.`LibelleAide`, `Sport`.`LibelleHautNiveau`, `Sport`.`cms`, `Sport`.`cms_priority`, `Sport`.`created`, `Sport`.`modified`, `Sport`.`acred_jp`, `Sport`.`ipc_name`, `Sport`.`ipc_code`, `Sport`.`sport_nature` FROM `ExtranetFFH`.`sports` AS `Sport` WHERE `Sport`.`id` = '33'110
15SELECT `DocumentsHandicap`.`id`, `DocumentsHandicap`.`document_id`, `DocumentsHandicap`.`handicap_id`, `DocumentsHandicap`.`handicap_id_old`, `DocumentsHandicap`.`user_create_id`, `DocumentsHandicap`.`created`, `DocumentsHandicap`.`modified`, `DocumentsHandicap`.`user_modify_id`, `DocumentsHandicap`.`rang`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `DocumentsHandicap`.`user_create_id`) AS `DocumentsHandicap__UCR` FROM `ExtranetFFH`.`documents_handicaps` AS `DocumentsHandicap` WHERE `DocumentsHandicap`.`document_id` = (2340)110
16SELECT `DocumentsPersonne`.`id`, `DocumentsPersonne`.`document_id`, `DocumentsPersonne`.`personne_id`, `DocumentsPersonne`.`nf`, `DocumentsPersonne`.`user_create_id`, `DocumentsPersonne`.`created`, `DocumentsPersonne`.`rang`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `DocumentsPersonne`.`user_create_id`) AS `DocumentsPersonne__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM personnes P where `P`.`id` = `DocumentsPersonne`.`personne_id`) AS `DocumentsPersonne__DPNF` FROM `ExtranetFFH`.`documents_personnes` AS `DocumentsPersonne` WHERE `DocumentsPersonne`.`document_id` = (2340)000
17BEGIN000
18INSERT INTO `ExtranetFFH`.`documents_connections` (`document_id`, `user_id`, `created`) VALUES (2340, 0, '2020-06-03 02:31:10')110
19COMMIT000
20SELECT COUNT(*) AS `count` FROM `ExtranetFFH`.`licences` AS `Licence` WHERE `SaisonAnnee` IS NULL AND `personne_id` IS NULL11394
21SELECT COUNT(*) AS `count` FROM `ExtranetFFH`.`licences` AS `Licence` WHERE `SaisonAnnee` IS NULL AND `personne_id` IS NULL11366