Chronik
Zeige Veranstaltungen für Chronik 
2018 · 2017 · 2016 · 2015 · 2014 · 2013 · 2012 · 2011 · 2010 · 2009 · 2008 · 2007 · 2006 · 2005 · 2004 · 2003 · 2002 · 2001 · 2000 · 1999 · 1998 · 1997 · 1996 · 1995 · 1994 · 1993 · 1992 · 1991 · 1990 · 1989 · 1988 · 1987 · 1986 · 1985 · 1984 · 1983
keine Veranstaltungen für diese Kriterien gefunden: (year(e.edate) = '2019'
SELECT distinct e.id, year(e.edate) as eyyyy, month(e.edate) as emm, dayofweek(e.edate) as edayofweek, e.edate, e.name, e.linkdocuments, e.linkwebsite FROM oea_events e LEFT JOIN oea_competitions c ON c.event_id = e.id LEFT JOIN oea_winners wc ON wc.row_id = c.id and wc.table_id = '2' LEFT JOIN oea_persons pc ON pc.id = wc.person_id LEFT JOIN oea_runs r ON r.competition_id = c.id LEFT JOIN oea_winners wr ON wr.row_id = r.id and wr.table_id = '3' LEFT JOIN oea_persons pr ON pr.id = wr.person_id LEFT JOIN oea_runmaps rm ON rm.run_id = r.id LEFT JOIN oea_maps m ON rm.map_id = m.id Where year(e.edate) = '2019' ORDER BY eyyyy desc, emm desc, e.edate desc, name desc)

Powered by ChronoForms - ChronoEngine.com