< | Octobre 2023 | > | ||||
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 |
du Vendredi 29 Juillet au DImanche 31 Juillet à Thorenc
Thorenc
Site réalisé par Mai'lie Copyright (C) 2011
Classe: | SportingEventsClassTables |
Fonction: | SportingEventsClassTables::getData |
Ligne: | 977 |
Erreur: | Disk full (/tmp/#sql-temptable-754f-1819c6-9ded.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 |
Classe: | SportingEventsClassTables |
Fonction: | SportingEventsClassTables::getData |
Ligne: | 977 |
Erreur: | Disk full (/tmp/#sql-temptable-754f-1819c6-9df4.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 |