calendrier.jpg

Agenda

< Mars 2021 >
Lun Mar Mer Jeu Ven Sam Dim
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31        

Agenda des manifestations

Voici la liste des évènements qui auront lieu sur la commune (ou ses environs proches).

Vous pouvez utiliser le petit calendrier sur la droite pour aller directement à un jour ou au mois que vous souhaitez.

Une erreur d'instruction SQL a été rencontrée. Si vous a avez la possitilité, merci d'en aviser le développeur de SportingEvents (http://forum.joomla.fr/forumdisplay.php?169-extension-sportingevents).

Classe:SportingEventsClassTables
Fonction:SportingEventsClassTables::getData
Ligne:977
Erreur:Disk full (/tmp/#sql_dda9_7.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT course.titre,course.sport_id, course.distance_id, course.parcours_id, course.section_id, course.category_id, course.photo, course.hot, course.intro,course.contact_id, course.place_id, enrolment_enabled, classement.nbr_items, classement.last_ranking_date, ranking.id as rank_id, course.date, course.enddate, course.openingdate, course.closingdate, course.expirationdate, course.hits, course.access, course.published, course.proposal, course.id, course.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, course.created_date FROM `jos_course` course LEFT JOIN (SELECT event_id, count(id) as nbr_items, max(lastmod) as last_ranking_date FROM `jos_course_classement` GROUP BY event_id) as classement ON course.id = classement.event_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `jos_course_links` links LEFT JOIN `jos_course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='1') GROUP BY ressources.id) as ranking ON course.ressource_id = ranking.ressource_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `jos_course_links` links LEFT JOIN `jos_course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='2') GROUP BY ressources.id) as enrolment ON course.ressource_id = enrolment.ressource_id LEFT JOIN `jos_course_sport` sport ON course.sport_id = sport.id WHERE (course.published='1') AND (course.access<=0) AND ((DATE_FORMAT(course.date,'%Y-%m-%d')=curdate()) OR (DATE_FORMAT(course.enddate,'%Y-%m-%d')=curdate()) OR ((course.contiguous_date=1) AND (course.datecurdate()))) AND (course.`published`='1') AND ((sport.id is null) OR ((sport.access<=0) AND (sport.published=1))) AND ((course.expirationdate is null) OR (course.expirationdate="0000-00-00 00:00:00") OR (course.expirationdate > now())) GROUP BY course.id ORDER BY `id` asc
SQL:SELECT course.titre,course.sport_id, course.distance_id, course.parcours_id, course.section_id, course.category_id, course.photo, course.hot, course.intro,course.contact_id, course.place_id, enrolment_enabled, classement.nbr_items, classement.last_ranking_date, ranking.id as rank_id, course.date, course.enddate, course.openingdate, course.closingdate, course.expirationdate, course.hits, course.access, course.published, course.proposal, course.id, course.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, course.created_date FROM `course` course LEFT JOIN (SELECT event_id, count(id) as nbr_items, max(lastmod) as last_ranking_date FROM `course_classement` GROUP BY event_id) as classement ON course.id = classement.event_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `course_links` links LEFT JOIN `course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='1') GROUP BY ressources.id) as ranking ON course.ressource_id = ranking.ressource_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `course_links` links LEFT JOIN `course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='2') GROUP BY ressources.id) as enrolment ON course.ressource_id = enrolment.ressource_id LEFT JOIN `course_sport` sport ON course.sport_id = sport.id WHERE (course.published='1') AND (course.access<=0) AND ((DATE_FORMAT(course.date,'%Y-%m-%d')=curdate()) OR (DATE_FORMAT(course.enddate,'%Y-%m-%d')=curdate()) OR ((course.contiguous_date=1) AND (course.date<curdate()) AND (course.enddate>curdate()))) AND (course.`published`='1') AND ((sport.id is null) OR ((sport.access<=0) AND (sport.published=1))) AND ((course.expirationdate is null) OR (course.expirationdate="0000-00-00 00:00:00") OR (course.expirationdate > now())) GROUP BY course.id ORDER BY `id` asc
 
Une erreur d'instruction SQL a été rencontrée. Si vous a avez la possitilité, merci d'en aviser le développeur de SportingEvents (http://forum.joomla.fr/forumdisplay.php?169-extension-sportingevents).

Classe:SportingEventsClassTables
Fonction:SportingEventsClassTables::getData
Ligne:977
Erreur:Disk full (/tmp/#sql_dda9_7.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT course.titre,course.sport_id, course.distance_id, course.parcours_id, course.section_id, course.category_id, course.photo, course.hot, course.intro,course.contact_id, course.place_id, enrolment_enabled, classement.nbr_items, classement.last_ranking_date, ranking.id as rank_id, course.date, course.enddate, course.openingdate, course.closingdate, course.expirationdate, course.hits, course.access, course.published, course.proposal, course.id, course.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, course.created_date FROM `jos_course` course LEFT JOIN (SELECT event_id, count(id) as nbr_items, max(lastmod) as last_ranking_date FROM `jos_course_classement` GROUP BY event_id) as classement ON course.id = classement.event_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `jos_course_links` links LEFT JOIN `jos_course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='1') GROUP BY ressources.id) as ranking ON course.ressource_id = ranking.ressource_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `jos_course_links` links LEFT JOIN `jos_course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='2') GROUP BY ressources.id) as enrolment ON course.ressource_id = enrolment.ressource_id LEFT JOIN `jos_course_sport` sport ON course.sport_id = sport.id WHERE (course.published='1') AND (course.access<=0) AND ((course.date <= current_timestamp) AND (course.enddate >= current_timestamp) AND NOT(course.contiguous_date=1)) AND (course.`published`='1') AND ((sport.id is null) OR ((sport.access<=0) AND (sport.published=1))) AND ((course.expirationdate is null) OR (course.expirationdate="0000-00-00 00:00:00") OR (course.expirationdate > now())) GROUP BY course.id ORDER BY course.date ASC
SQL:SELECT course.titre,course.sport_id, course.distance_id, course.parcours_id, course.section_id, course.category_id, course.photo, course.hot, course.intro,course.contact_id, course.place_id, enrolment_enabled, classement.nbr_items, classement.last_ranking_date, ranking.id as rank_id, course.date, course.enddate, course.openingdate, course.closingdate, course.expirationdate, course.hits, course.access, course.published, course.proposal, course.id, course.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, course.created_date FROM `course` course LEFT JOIN (SELECT event_id, count(id) as nbr_items, max(lastmod) as last_ranking_date FROM `course_classement` GROUP BY event_id) as classement ON course.id = classement.event_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `course_links` links LEFT JOIN `course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='1') GROUP BY ressources.id) as ranking ON course.ressource_id = ranking.ressource_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `course_links` links LEFT JOIN `course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='2') GROUP BY ressources.id) as enrolment ON course.ressource_id = enrolment.ressource_id LEFT JOIN `course_sport` sport ON course.sport_id = sport.id WHERE (course.published='1') AND (course.access<=0) AND ((course.date <= current_timestamp) AND (course.enddate >= current_timestamp) AND NOT(course.contiguous_date=1)) AND (course.`published`='1') AND ((sport.id is null) OR ((sport.access<=0) AND (sport.published=1))) AND ((course.expirationdate is null) OR (course.expirationdate="0000-00-00 00:00:00") OR (course.expirationdate > now())) GROUP BY course.id ORDER BY course.date ASC
 
Une erreur d'instruction SQL a été rencontrée. Si vous a avez la possitilité, merci d'en aviser le développeur de SportingEvents (http://forum.joomla.fr/forumdisplay.php?169-extension-sportingevents).

Classe:SportingEventsClassTables
Fonction:SportingEventsClassTables::getData
Ligne:977
Erreur:Disk full (/tmp/#sql_dda9_7.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT course.titre,course.sport_id, course.distance_id, course.parcours_id, course.section_id, course.category_id, course.photo, course.hot, course.intro,course.contact_id, course.place_id, enrolment_enabled, classement.nbr_items, classement.last_ranking_date, ranking.id as rank_id, course.date, course.enddate, course.openingdate, course.closingdate, course.expirationdate, course.hits, course.access, course.published, course.proposal, course.id, course.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, course.created_date FROM `jos_course` course LEFT JOIN (SELECT event_id, count(id) as nbr_items, max(lastmod) as last_ranking_date FROM `jos_course_classement` GROUP BY event_id) as classement ON course.id = classement.event_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `jos_course_links` links LEFT JOIN `jos_course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='1') GROUP BY ressources.id) as ranking ON course.ressource_id = ranking.ressource_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `jos_course_links` links LEFT JOIN `jos_course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='2') GROUP BY ressources.id) as enrolment ON course.ressource_id = enrolment.ressource_id LEFT JOIN `jos_course_sport` sport ON course.sport_id = sport.id WHERE (course.published='1') AND (course.access<=0) AND (DATE_FORMAT(course.date,'%Y-%m-%d')>curdate()) AND (course.`published`='1') AND ((sport.id is null) OR ((sport.access<=0) AND (sport.published=1))) AND ((course.expirationdate is null) OR (course.expirationdate="0000-00-00 00:00:00") OR (course.expirationdate > now())) GROUP BY course.id ORDER BY course.date ASC
SQL:SELECT course.titre,course.sport_id, course.distance_id, course.parcours_id, course.section_id, course.category_id, course.photo, course.hot, course.intro,course.contact_id, course.place_id, enrolment_enabled, classement.nbr_items, classement.last_ranking_date, ranking.id as rank_id, course.date, course.enddate, course.openingdate, course.closingdate, course.expirationdate, course.hits, course.access, course.published, course.proposal, course.id, course.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, course.created_date FROM `course` course LEFT JOIN (SELECT event_id, count(id) as nbr_items, max(lastmod) as last_ranking_date FROM `course_classement` GROUP BY event_id) as classement ON course.id = classement.event_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `course_links` links LEFT JOIN `course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='1') GROUP BY ressources.id) as ranking ON course.ressource_id = ranking.ressource_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `course_links` links LEFT JOIN `course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='2') GROUP BY ressources.id) as enrolment ON course.ressource_id = enrolment.ressource_id LEFT JOIN `course_sport` sport ON course.sport_id = sport.id WHERE (course.published='1') AND (course.access<=0) AND (DATE_FORMAT(course.date,'%Y-%m-%d')>curdate()) AND (course.`published`='1') AND ((sport.id is null) OR ((sport.access<=0) AND (sport.published=1))) AND ((course.expirationdate is null) OR (course.expirationdate="0000-00-00 00:00:00") OR (course.expirationdate > now())) GROUP BY course.id ORDER BY course.date ASC
 
Une erreur d'instruction SQL a été rencontrée. Si vous a avez la possitilité, merci d'en aviser le développeur de SportingEvents (http://forum.joomla.fr/forumdisplay.php?169-extension-sportingevents).

Classe:SportingEventsClassTables
Fonction:SportingEventsClassTables::getData
Ligne:977
Erreur:Disk full (/tmp/#sql_dda9_7.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT course.titre,course.sport_id, course.distance_id, course.parcours_id, course.section_id, course.category_id, course.photo, course.hot, course.intro,course.contact_id, course.place_id, enrolment_enabled, classement.nbr_items, classement.last_ranking_date, ranking.id as rank_id, course.date, course.enddate, course.openingdate, course.closingdate, course.expirationdate, course.hits, course.access, course.published, course.proposal, course.id, course.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, course.created_date FROM `jos_course` course LEFT JOIN (SELECT event_id, count(id) as nbr_items, max(lastmod) as last_ranking_date FROM `jos_course_classement` GROUP BY event_id) as classement ON course.id = classement.event_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `jos_course_links` links LEFT JOIN `jos_course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='1') GROUP BY ressources.id) as ranking ON course.ressource_id = ranking.ressource_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `jos_course_links` links LEFT JOIN `jos_course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='2') GROUP BY ressources.id) as enrolment ON course.ressource_id = enrolment.ressource_id LEFT JOIN `jos_course_sport` sport ON course.sport_id = sport.id WHERE (course.published='1') AND (course.access<=0) AND (DATE_FORMAT(course.enddate,'%Y-%m-%d') now())) GROUP BY course.id ORDER BY course.date DESC
SQL:SELECT course.titre,course.sport_id, course.distance_id, course.parcours_id, course.section_id, course.category_id, course.photo, course.hot, course.intro,course.contact_id, course.place_id, enrolment_enabled, classement.nbr_items, classement.last_ranking_date, ranking.id as rank_id, course.date, course.enddate, course.openingdate, course.closingdate, course.expirationdate, course.hits, course.access, course.published, course.proposal, course.id, course.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, course.created_date FROM `course` course LEFT JOIN (SELECT event_id, count(id) as nbr_items, max(lastmod) as last_ranking_date FROM `course_classement` GROUP BY event_id) as classement ON course.id = classement.event_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `course_links` links LEFT JOIN `course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='1') GROUP BY ressources.id) as ranking ON course.ressource_id = ranking.ressource_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `course_links` links LEFT JOIN `course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='2') GROUP BY ressources.id) as enrolment ON course.ressource_id = enrolment.ressource_id LEFT JOIN `course_sport` sport ON course.sport_id = sport.id WHERE (course.published='1') AND (course.access<=0) AND (DATE_FORMAT(course.enddate,'%Y-%m-%d')<curdate()) AND (course.`published`='1') AND ((sport.id is null) OR ((sport.access<=0) AND (sport.published=1))) AND ((course.expirationdate is null) OR (course.expirationdate="0000-00-00 00:00:00") OR (course.expirationdate > now())) GROUP BY course.id ORDER BY course.date DESC

Retour en haut de la page

Site réalisé par Mai'lie Copyright (C) 2011

Prochains évènements

Une erreur d'instruction SQL a été rencontrée. Si vous a avez la possitilité, merci d'en aviser le développeur de SportingEvents (http://forum.joomla.fr/forumdisplay.php?169-extension-sportingevents).

Classe:SportingEventsClassTables
Fonction:SportingEventsClassTables::getData
Ligne:977
Erreur:Disk full (/tmp/#sql_dda9_7.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT course.titre,course.sport_id, course.distance_id, course.parcours_id, course.section_id, course.category_id, course.photo, course.hot, course.intro,course.contact_id, course.place_id, enrolment_enabled, classement.nbr_items, classement.last_ranking_date, ranking.id as rank_id, course.date, course.enddate, course.openingdate, course.closingdate, course.expirationdate, course.hits, course.access, course.published, course.proposal, course.id, course.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, course.created_date FROM `jos_course` course LEFT JOIN (SELECT event_id, count(id) as nbr_items, max(lastmod) as last_ranking_date FROM `jos_course_classement` GROUP BY event_id) as classement ON course.id = classement.event_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `jos_course_links` links LEFT JOIN `jos_course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='1') GROUP BY ressources.id) as ranking ON course.ressource_id = ranking.ressource_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `jos_course_links` links LEFT JOIN `jos_course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='2') GROUP BY ressources.id) as enrolment ON course.ressource_id = enrolment.ressource_id LEFT JOIN `jos_course_sport` sport ON course.sport_id = sport.id WHERE (course.published=1) AND (course.access<=0) AND ((course.date <= current_timestamp) AND (course.enddate >= current_timestamp) AND NOT(course.contiguous_date=1)) AND ((sport.id is null) OR ((sport.access<=0) AND (sport.published=1))) AND ((course.expirationdate is null) OR (course.expirationdate="0000-00-00 00:00:00") OR (course.expirationdate > now())) GROUP BY course.id ORDER BY course.date ASC LIMIT 0, 2
SQL:SELECT course.titre,course.sport_id, course.distance_id, course.parcours_id, course.section_id, course.category_id, course.photo, course.hot, course.intro,course.contact_id, course.place_id, enrolment_enabled, classement.nbr_items, classement.last_ranking_date, ranking.id as rank_id, course.date, course.enddate, course.openingdate, course.closingdate, course.expirationdate, course.hits, course.access, course.published, course.proposal, course.id, course.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, course.created_date FROM `course` course LEFT JOIN (SELECT event_id, count(id) as nbr_items, max(lastmod) as last_ranking_date FROM `course_classement` GROUP BY event_id) as classement ON course.id = classement.event_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `course_links` links LEFT JOIN `course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='1') GROUP BY ressources.id) as ranking ON course.ressource_id = ranking.ressource_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `course_links` links LEFT JOIN `course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='2') GROUP BY ressources.id) as enrolment ON course.ressource_id = enrolment.ressource_id LEFT JOIN `course_sport` sport ON course.sport_id = sport.id WHERE (course.published=1) AND (course.access<=0) AND ((course.date <= current_timestamp) AND (course.enddate >= current_timestamp) AND NOT(course.contiguous_date=1)) AND ((sport.id is null) OR ((sport.access<=0) AND (sport.published=1))) AND ((course.expirationdate is null) OR (course.expirationdate="0000-00-00 00:00:00") OR (course.expirationdate > now())) GROUP BY course.id ORDER BY course.date ASC
Une erreur d'instruction SQL a été rencontrée. Si vous a avez la possitilité, merci d'en aviser le développeur de SportingEvents (http://forum.joomla.fr/forumdisplay.php?169-extension-sportingevents).

Classe:SportingEventsClassTables
Fonction:SportingEventsClassTables::getData
Ligne:977
Erreur:Disk full (/tmp/#sql_dda9_7.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT course.titre,course.sport_id, course.distance_id, course.parcours_id, course.section_id, course.category_id, course.photo, course.hot, course.intro,course.contact_id, course.place_id, enrolment_enabled, classement.nbr_items, classement.last_ranking_date, ranking.id as rank_id, course.date, course.enddate, course.openingdate, course.closingdate, course.expirationdate, course.hits, course.access, course.published, course.proposal, course.id, course.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, course.created_date FROM `jos_course` course LEFT JOIN (SELECT event_id, count(id) as nbr_items, max(lastmod) as last_ranking_date FROM `jos_course_classement` GROUP BY event_id) as classement ON course.id = classement.event_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `jos_course_links` links LEFT JOIN `jos_course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='1') GROUP BY ressources.id) as ranking ON course.ressource_id = ranking.ressource_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `jos_course_links` links LEFT JOIN `jos_course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='2') GROUP BY ressources.id) as enrolment ON course.ressource_id = enrolment.ressource_id LEFT JOIN `jos_course_sport` sport ON course.sport_id = sport.id WHERE (course.published=1) AND (course.access<=0) AND (DATE_FORMAT(course.date,'%Y-%m-%d')>curdate()) AND ((sport.id is null) OR ((sport.access<=0) AND (sport.published=1))) AND ((course.expirationdate is null) OR (course.expirationdate="0000-00-00 00:00:00") OR (course.expirationdate > now())) GROUP BY course.id ORDER BY course.date ASC LIMIT 0, 5
SQL:SELECT course.titre,course.sport_id, course.distance_id, course.parcours_id, course.section_id, course.category_id, course.photo, course.hot, course.intro,course.contact_id, course.place_id, enrolment_enabled, classement.nbr_items, classement.last_ranking_date, ranking.id as rank_id, course.date, course.enddate, course.openingdate, course.closingdate, course.expirationdate, course.hits, course.access, course.published, course.proposal, course.id, course.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, course.created_date FROM `course` course LEFT JOIN (SELECT event_id, count(id) as nbr_items, max(lastmod) as last_ranking_date FROM `course_classement` GROUP BY event_id) as classement ON course.id = classement.event_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `course_links` links LEFT JOIN `course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='1') GROUP BY ressources.id) as ranking ON course.ressource_id = ranking.ressource_id LEFT JOIN (SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id FROM `course_links` links LEFT JOIN `course_ressources` ressources ON links.parent_id = ressources.id WHERE (`type`='2') GROUP BY ressources.id) as enrolment ON course.ressource_id = enrolment.ressource_id LEFT JOIN `course_sport` sport ON course.sport_id = sport.id WHERE (course.published=1) AND (course.access<=0) AND (DATE_FORMAT(course.date,'%Y-%m-%d')>curdate()) AND ((sport.id is null) OR ((sport.access<=0) AND (sport.published=1))) AND ((course.expirationdate is null) OR (course.expirationdate="0000-00-00 00:00:00") OR (course.expirationdate > now())) GROUP BY course.id ORDER BY course.date ASC

Recherche