Auszeichnung und Förderung
Die Deutsche Schachjugend und der Deutsche Schachbund sowie andere Organisationen zeichnen besondere Leistungen in den Vereinen aus.
Übersicht Auszeichung und Förderung
| Verein | Mitglieder | jugendlich U25 | weiblich | DWZ-Liste | Auszeichnung | ||
|---|---|---|---|---|---|---|---|
| Auszeichnung und Förderung · Karte | 6 136 | 3311 3 311 | 1046 54,0 % | 1 046 | 17,0 % | ||
| 60. Schule Leipzig | – | – | – | 2015 – | 2015–2019 | ||
| Adalbert-Stifter-Volksschule Wegscheid | – | – | – | 2006 – | 2006–2010 | ||
| Adolf-Reichwein-Schule Kiel | – | – | – | 2017 – | 2017–2021 | ||
| Aktiv-Schule Emleben | – | – | – | 2014 – | 2014–2018 | ||
| Albert-Schweitzer-Schule Leipzig | – | – | – | 2016 – | 2016–2020, 2021–2025 | ||
| Albertus-Magnus-Gymnasium Regensburg | – | – | – | 2013 – | 2013–2017, 2018–2022 | ||
| Amandusschule Aschendorf | – | – | – | 2014 – | 2014–2018 | ||
| Anton-Bruckner-Gymnasium Straubing | – | – | – | 2017 – | 2017–2021 | ||
| Arnoldi-Gymnasium Gotha / Arnoldischule Gotha | – | – | – | 2011 – | 2011–2015, 2016–2020, 2021–2025 | ||
| Astrid-Lindgren-Grundschule Heidenau | – | – | – | 2018 – | 2018–2022 | ||
| August-Hermann-Francke Schule Bahrenfeld | – | – | – | 2017 – | 2017–2021 | ||
| Bewegte Grundschule Hermsdorf | – | – | – | 2014 – | 2014–2018 | ||
| Bilinguale Montessori Schule Heidesheim | – | – | – | 2016 – | 2016–2020 | ||
| Brüder-Grimm-Schule Hannover | – | – | – | 2008 – | 2008–2012 | ||
| Brüder-Grimm-Schule Issum | – | – | – | 2017 – | 2017–2021 | ||
| Carl-Friedrich-Gauß Privatschulen Ludwigsburg | – | – | – | 2015 – | 2015–2019 | ||
| Daniel Sanders Grundschule / Daniel Sanders Grundschule Neustrelitz | – | – | – | 2011 – | 2011–2015, 2016–2020, 2021–2025 | ||
| Grundschule Knauerstraße | – | – | – | 2020 – | 2020–2024 | ||
| Dr.-Emanuel-Lasker-Schule Ströbeck | – | – | – | 2016 – | 2016–2020 | ||
| Dürer-Gymnasium Nürnberg | – | – | – | 2014 – | 2014–2018, 2018–2022 | ||
| Ecolea Internationale Schule Schwerin | – | – | – | 2015 – | 2015–2019 | ||
| Erasmus-Bildungshaus Offenbach | – | – | – | 2015 – | 2015–2019 | ||
| Erasmus-Grundschule Offenbach | – | – | – | 2011 – | 2011–2015, 2016–2020 | ||
| Familienzentrum Flintacker | – | – | – | 2016 – | 2016–2020 | ||
| Freie Evangelische Schule Lindach | – | – | – | 2020 – | 2020–2024, 2020–2024 | ||
| Franziskusgymnasium Lingen | – | – | – | 2017 – | 2017–2021 | ||
| Friedrich-Ebert-Realschule Oberhausen | – | – | – | 2017 – | 2017–2021 | ||
| Gemeinschaftsgrundschule Hockstein | – | – | – | 2018 – | 2018–2022 | ||
| Gesamtschule Obersberg Bad Hersfeld | – | – | – | 2014 – | 2014–2018, 2020–2024 | ||
| Grund- und Gemeinschaftsschule St. Jürgen Lübeck | – | – | – | 2018 – | 2018–2022 | ||
| Goethe-Gymnasium Hamburg | – | – | – | 2018 – | 2018–2022 | ||
| Goethe-Gymnasium Regensburg | – | – | – | 2008 – | 2008–2012, 2016–2020 | ||
| Grundschule Altenlingen | – | – | – | 2018 – | 2018–2022 | ||
| Grundschule am Ebersberg Springe | – | – | – | 2013 – | 2013–2017 | ||
| Grundschule Am Grünen Kamp Delmenhorst | – | – | – | 2020 – | 2020–2024 | ||
| Grundschule am Koggenweg Lübeck | – | – | – | 2018 – | 2018–2022 | ||
| Grundschule Am Sandberge Hannover | – | – | – | 2010 – | 2010–2014, 2015–2019, 2020–2024 | ||
| Grundschule an der Münchener Straße Ingolstadt | – | – | – | 2013 – | 2013–2017, 2018–2022 | ||
| Grundschule Frohmestraße Hamburg | – | – | – | 2016 – | 2016–2020, 2021–2025 | ||
| Grundschule Garching-West | – | – | – | 2016 – | 2016–2020, 2021–2025 | ||
| Grundschule Genslerstraße Hamburg | – | – | – | 2010 – | 2010–2014, 2015–2019, 2020–2024 | ||
| Grundschule Idarbachtal Idar-Oberstein | – | – | – | 2015 – | 2015–2019 | ||
| Grundschule Karl Liebknecht Neuruppin | – | – | – | 2018 – | 2018–2022 | ||
| Grundschule Kletterrose Burg Stargard | – | – | – | 2014 – | 2014–2018, 2019–2024 | ||
| Grundschule Klettham | – | – | – | 2016 – | 2016–2020, 2021–2025 | ||
| Grundschule Königswiesen Regensburg | – | – | – | 2016 – | 2016–2020 | ||
| Grundschule Lankow Schwerin | – | – | – | 2012 – | 2012–2016, 2017–2021 | ||
| Grundschule Lichtenhagen | – | – | – | 2019 – | 2019–2023 | ||
| Grundschule Mahndorf Bremen | – | – | – | 2014 – | 2014–2018 | ||
| Grundschule »Otto Dix« Gera | – | – | – | 2011 – | 2011–2015, 2016–2020 | ||
| Grundschule Portitz Leipzig | – | – | – | 2013 – | 2013–2017, 2017–2021 | ||
| Grundschule Stadtilm | – | – | – | 2013 – | 2013–2017 | ||
| Grundschule Täferrot | – | – | – | 2016 – | 2016–2020 | ||
| Grundschule Wachenheim | – | – | – | 2011 – | 2011–2015 | ||
| Grundschule Wasserkampstraße Hannover | – | – | – | 2015 – | 2015–2019, 2020–2024 | ||
| Grundschule Windach | – | – | – | 2012 – | 2012–2016 | ||
| Grundschule Zusamaltheim | – | – | – | 2014 – | 2014–2018 | ||
| Gymnasium Kirchheim | – | – | – | 2021 – | 2021–2025 | ||
| Gymnasium Ohlstedt | – | – | – | 2016 – | 2016–2020, 2021–2025 | ||
| Gymnasium Ottweiler | – | – | – | 2019 – | 2019–2023 | ||
| Gymnasium Roth | – | – | – | 2012 – | 2012–2016, 2016–2020 | ||
| Gymnasium Schillerschule Hannover | – | – | – | 2021 – | 2021–2025 | ||
| Hainberg-Gymnasium Göttingen | – | – | – | 2012 – | 2012–2016 | ||
| Hans-Böckler-Realschule Fürth | – | – | – | 2017 – | 2017–2021 | ||
| Hans-Scholl-Realschule Weiden | – | – | – | 2015 – | 2015–2019 | ||
| Hans-Thoma-Schule Karlsruhe | – | – | – | 2015 – | 2015–2019 | ||
| Heinrich-Middendorf-Oberschule Aschendorf | – | – | – | 2014 – | 2014–2018 | ||
| Herder-Gymnasium Berlin | – | – | – | 2007 – | 2007–2011 | ||
| Käthe-Kollwitz-Gymnasium Halberstadt | – | – | – | 2012 – | 2012–2016 | ||
| Käthe-Kollwitz-Oberschule Berlin | – | – | – | 2015 – | 2015–2019 | ||
| Karl-Marx-Schule Bremerhaven | – | – | – | 2016 – | 2016–2020, 2021–2025 | ||
| Kaspar-Zeuß-Gymnasium Kronach | – | – | – | 2009 – | 2009–2013 | ||
| Kita Farbenspiel Tangermünde | – | – | – | 2018 – | 2018–2022 | ||
| Märchenkita Schwerin-Krebsfördern | – | – | – | 2017 – | 2017–2021 | ||
| Kita Kunterbunt Magdeburg | – | – | – | 2017 – | 2017–2021 | ||
| Leibnizschule Offenbach | – | – | – | 2018 – | 2018–2022 | ||
| Leonardo-Da-Vinci-Gemeinschaftsschule Riegelsberg | – | – | – | 2012 – | 2012–2016 | ||
| Lise-Meitner-Gymnasium Maxdorf | – | – | – | 2014 – | 2014–2018 | ||
| Ludgerus-Schule Rhede (Ems) | – | – | – | 2008 – | 2008–2012, 2017–2021 | ||
| Luzia-Grundschule Pflaumheim | – | – | – | 2011 – | 2011–2015, 2016–2020 | ||
| Martin-von-Tours-Schule Neustadt | – | – | – | 2016 – | 2016–2020 | ||
| Max-Planck-Gymnasium Karlsruhe | – | – | – | 2018 – | 2018–2022 | ||
| Meranier-Gymnasium Lichtenfels | – | – | – | 2010 – | 2010–2014 | ||
| Michael-Poeschke-Grundschule Erlangen | – | – | – | 2013 – | 2013–2017 | ||
| Montessori-Volksschule Aufkirchen | – | – | – | 2014 – | 2014–2018, 2020–2024 | ||
| Norddörferschule Sylt | – | – | – | 2016 – | 2016–2020 | ||
| Oberschule Adolph Diesterweg Hennigsdorf | – | – | – | 2018 – | 2018–2022 | ||
| Paul-Gerhardt-Grundschule Lübeck | – | – | – | 2012 – | 2012–2016 | ||
| Scharnhorst-Gymnasium Hildesheim | – | – | – | 2012 – | 2012–2016, 2016–2020 | ||
| Schule am Nicolaitor Höxter | – | – | – | 2017 – | 2017–2021 | ||
| Schule Am Roten Berg Hasbergen | – | – | – | 2018 – | 2018–2022 | ||
| Schule an der Gete Bremen | – | – | – | 2015 – | 2015–2019 | ||
| Schule in der Alten Forst Hamburg | – | – | – | 2018 – | 2018–2022 | ||
| St.-Amandus-Kindergarten Aschendorf | – | – | – | 2014 – | 2014–2018 | ||
| St.-Sebastian-Grundschule Raesfeld | – | – | – | 2010 – | 2010–2014, 2015–2019 | ||
| Stadtschule Bad Oldesloe | – | – | – | 2016 – | 2016–2020, 2021–2025 | ||
| Stadtteilschule Ehestorfer Weg Hamburg | – | – | – | 2016 – | 2016–2020 | ||
| Staufer-Gymnasium Pfullendorf | – | – | – | 2017 – | 2017–2021 | ||
| Südendschule Karlsruhe | – | – | – | 2020 – | 2020–2024 | ||
| Tassilo-Gymnasium Simbach | – | – | – | 2012 – | 2012–2016, 2017–2021 | ||
| Theo-Betz-Schule Neumarkt | – | – | – | 2015 – | 2015–2019 | ||
| Viscardi-Gymnasium Fürstenfeldbrück | – | – | – | 2018 – | 2018–2022 | ||
| Volksschule Bindlach | – | – | – | 2019 – | 2019–2023 | ||
| Walter-Gemm-Schule Halberstadt | – | – | – | 2015 – | 2015–2019 | ||
| Wilhelm-Neuhaus-Schule Bad Hersfeld | – | – | – | 2008 – | 2008–2012, 2016–2020 | ||
| Zwötzener Schule Gera – Staatliche Grundschule | – | – | – | 2016 – | 2016–2020, 2021–2025 | ||
| Karlsruher SF 1853 | 198 | 110 110 | 53 55,6 % | 10422 53 | 1991 26,8 % | 10422 | 1991, 2015, 2015–2017, 2016–2018, 2020–2023, 2021 |
| SK Freiburg-Zähringen 1887 e.V. | 152 | 92 92 | 31 60,5 % | 10806 31 | 2017 20,4 % | 10806 | 2017–2019, 2020–2022 |
| SK Neumarkt e.V. | 125 | 58 58 | 21 46,4 % | 21103 21 | 2014 16,8 % | 21103 | 2014–2016, 2016–2018, 2018–2020 |
| Allersberger SC 2000 e.V. | 76 | 44 44 | 23 57,9 % | 21405 23 | 2006 30,3 % | 21405 | 2006–2008, 2020–2023 |
| SC Bechhofen 1923 e.V. | 73 | 33 33 | 10 45,2 % | 21503 10 | 2009 13,7 % | 21503 | 2009–2011, 2009–2011, 2012–2014, 2012–2014 |
| Schach-Club Vaterstetten / Schach-Club Vaterstetten-Grasbrunn | 141 | 82 82 | 23 58,2 % | 22009 23 | 2000 16,3 % | 22009 | 2000–2002, 2003–2005, 2006–2008, 2009–2011, 2015–2017 |
| Spvgg 1946 e.V. Stetten | 103 | 50 50 | 31 48,5 % | 28224 31 | 2012 30,1 % | 28224 | 2012–2014 |
| SC Bad Königshofen 1957 | 98 | 38 38 | 41 38,8 % | 28308 41 | 2002 41,8 % | 28308 | 2002–2004 |
| Sfr. Neukölln 03 | 131 | 19 19 | 4 14,5 % | 30008 4 | 1989 3,1 % | 30008 | 1989 |
| SK König Tegel 1949 e.V. | 95 | 20 20 | 6 21,1 % | 30014 6 | 1998 6,3 % | 30014 | 1998 |
| SC Diogenes e.V. | 90 | 33 33 | 10 36,7 % | 40013 10 | 1988 11,1 % | 40013 | 1988, 2000–2002 |
| Hamburger SK von 1830 eV | 680 | 355 355 | 109 52,2 % | 40023 109 | 1990 16,0 % | 40023 | 1990, 2017 |
| SC Schachelschweine e.V. / SC Schachelschweine Hamburg e.V. | 87 | 22 22 | 15 25,3 % | 40041 15 | 2000 17,2 % | 40041 | 2000–2002, 2000–2002, 2000–2002 |
| Königsspringer SC 1984 e. V. | 99 | 33 33 | 6 33,3 % | 40055 6 | 1995 6,1 % | 40055 | 1995 |
| Schachklub Baunatal 1963 | 20 | 2 2 | 0 10,0 % | 51025 – | 2000 – | 51025 | 2000–2002 |
| Schachjugend Herborn | 28 | 15 15 | 2 53,6 % | 53039 2 | 2008 7,1 % | 53039 | 2008–2010, 2012–2014 |
| SC „Turm“ Breuberg | 33 | 10 10 | 4 30,3 % | 56010 4 | 2001 12,1 % | 56010 | 2001–2003 |
| Schachforum Darmstadt 1994 | 140 | 83 83 | 13 59,3 % | 56036 13 | 2011 9,3 % | 56036 | 2011–2013 |
| Schachjugendgruppe Limburg | 88 | 53 53 | 4 60,2 % | 59004 4 | 2001 4,6 % | 59004 | 2001–2003 |
| Schachfreunde Brackel 1930 e.V. | 204 | 116 116 | 12 56,9 % | 61209 12 | 1993 5,9 % | 61209 | 1993, 2007 |
| SV Welver e.V. | – | – | 61521 – | 2002 – | 2002–2004 | ||
| Krefelder Schachklub Turm 1851 e. V. | 128 | 49 49 | 14 38,3 % | 62419 14 | 2018 10,9 % | 62419 | 2018–2020 |
| Schachklub Münster 32 e.V. | 179 | 75 75 | 17 41,9 % | 65301 17 | 2019 9,5 % | 65301 | 2019–2021 |
| Schachfreunde Köln-Mülheim e.V. | 46 | 19 19 | 0 41,3 % | 66323 – | 2003 – | 66323 | 2003–2005 |
| Schachverein Erftstadt e. V. | 94 | 47 47 | 13 50,0 % | 66357 13 | 2000 13,8 % | 66357 | 2000–2002, 2003–2005, 2006–2008, 2009–2011, 2012–2014, 2015–2017, 2018–2020 |
| SK Lehrte von 1919 e. V. | 159 | 74 74 | 44 46,5 % | 70156 44 | 2009 27,7 % | 70156 | 2009–2011, 2009–2011, 2014–2016, 2014–2016, 2019–2021, 2019–2021 |
| KSV Rochade Göttingen | 61 | 52 52 | 4 85,3 % | 70352 4 | 2012 6,6 % | 70352 | 2012–2014 |
| Hildesheimer SV | 61 | 29 29 | 7 47,5 % | 70306 7 | 2020 11,5 % | 70306 | 2020–2023 |
| Stader SV | 89 | 41 41 | 6 46,1 % | 70422 6 | 2010 6,7 % | 70422 | 2010–2012 |
| SK Union Oldenburg | 59 | 7 7 | 2 11,9 % | 70514 2 | 2002 3,4 % | 70514 | 2002–2004 |
| SG Oesede-Georgsmarienhütte | 7 | 0 – | 0 – | 70610 – | 2000 – | 70610 | 2000–2002, 2000–2002 |
| SF St. Johannes Spelle | 48 | 27 27 | 8 56,3 % | 70619 8 | 2002 16,7 % | 70619 | 2002–2004, 2002–2004, 2002–2004 |
| Integrierte Gesamtschule Trier | 28 | 17 17 | 3 60,7 % | 8150A 3 | 2015 10,7 % | 8150A | 2015–2019 |
| SV 1926 Riegelsberg | 114 | 64 64 | 33 56,1 % | 90032 33 | 2010 29,0 % | 90032 | 2010–2012, 2012–2014, 2013–2015 |
| SC Turm Winterbach | 15 | 0 – | 1 – | 90050 1 | 1992 6,7 % | 90050 | 1992 |
| SK Kaltenkirchen | 67 | 27 27 | 10 40,3 % | A080C 10 | 2004 14,9 % | A080C | 2004–2006, 2004–2006, 2004–2006 |
| TuRa Harksheide von 1945 Norderstedt e.V. | 105 | 90 90 | 44 85,7 % | A080G 44 | 2011 41,9 % | A080G | 2011–2013, 2016–2018, 2016–2018, 2020 |
| Lübecker SV von 1873 | 212 | 101 101 | 29 47,6 % | A080I 29 | 2013 13,7 % | A080I | 2013 |
| SC Meerbauer MPS '90 Kiel / SC Meerbauer Kiel | – | – | A0629 – | 1994 – | 1994, 2000–2002 | ||
| Delmenhorster SK V 1931 | 90 | 39 39 | 14 43,3 % | B0005 14 | 1997 15,6 % | B0005 | 1997 |
| SC Bisingen-Steinhofen | 85 | 41 41 | 21 48,2 % | C0203 21 | 2017 24,7 % | C0203 | 2017–2019 |
| SC Christophorusschule Altensteig | – | – | C0229 – | 1987 – | 1987 | ||
| SG Königskinder Hohentübingen e.V. | 77 | 44 44 | 9 57,1 % | C0361 9 | 2008 11,7 % | C0361 | 2008–2010, 2012–2014 |
| SV Wolfbusch / SV Stuttgart-Wolfbusch 1956 e.V. | 147 | 69 69 | 41 46,9 % | C0538 41 | 2004 27,9 % | C0538 | 2004, 2010, 2010–2012, 2010–2012 |
| TSV Heumaden | 19 | 7 7 | 2 36,8 % | C0560 2 | 2004 10,5 % | C0560 | 2004–2006 |
| SC Tamm 74 | 70 | 28 28 | 7 40,0 % | C0631 7 | 2002 10,0 % | C0631 | 2002 |
| SVG Vaihingen/Enz | 28 | 6 6 | 2 21,4 % | C0633 2 | 2002 7,1 % | C0633 | 2002–2004 |
| SF 59 Kornwestheim | 105 | 49 49 | 7 46,7 % | C0645 7 | 2002 6,7 % | C0645 | 2002–2004, 2007–2009, 2018–2020, 2021–2023 |
| SV „Glück auf“ Rüdersdorf e.V. | 212 | 175 175 | 59 82,6 % | D2004 59 | 2001 27,8 % | D2004 | 2001 |
| SAV Torgelow | 61 | 32 32 | 9 52,5 % | E0327 9 | 2009 14,8 % | E0327 | 2009–2011 |
| SC Leipzig-Gohlis | 151 | 57 57 | 24 37,8 % | F1508 24 | 1999 15,9 % | F1508 | 1999, 2005 |
| SC Leipzig-Lindenau | 46 | 34 34 | 18 73,9 % | F1523 18 | 2009 39,1 % | F1523 | 2009–2011 |
| Post SV Dresden / USV TU Dresden | 137 | 70 70 | 10 51,1 % | F2813 10 | 1991 7,3 % | F2813 | 1991, 2006 |
| Schachfreunde Hettstedt | 82 | 47 47 | 5 57,3 % | G0214 5 | 2000 6,1 % | G0214 | 2000 |
| Schachzwerge Magdeburg | 541 | 533 533 | 130 98,5 % | G0353 130 | 2018 24,0 % | G0353 | 2018–2020, 2021–2023 |
| SV Empor Erfurt | 91 | 51 51 | 18 56,0 % | H2104 18 | 1996 19,8 % | H2104 | 1996 |
| SG Blau-Weiß Stadtilm | 61 | 42 42 | 17 68,9 % | H2409 17 | 2002 27,9 % | H2409 | 2002–2004, 2003, 2013–2015 |
| TSV Zeulenroda | – | – | H3074 – | 2000 – | 2000–2002, 2000–2002 | ||
SQL query in 0.00086808204650879 - SELECT contact_id, contact, category_id, category, mother_contact_id
, 1 AS aktiv
, contacts.identifier
FROM contacts
LEFT JOIN categories
ON contacts.contact_category_id = categories.category_id
WHERE contacts.identifier = "auszeichnung-und-foerderung"
SQL query in 0.0010530948638916 - SELECT category_id, category, description
, SUBSTRING_INDEX(path, "/", -1) AS path
FROM categories
WHERE SUBSTRING_INDEX(path, "/", -1) = "auszeichnung-und-foerderung"
SQL query in 0.0017890930175781 - SELECT category_id, category, SUBSTRING_INDEX(path, "/", -1) AS path
, (SELECT IFNULL(COUNT(DISTINCT contact_id), NULL) FROM auszeichnungen
WHERE auszeichnungen.auszeichnung_category_id = categories.category_id) AS auszeichnungen
FROM categories
WHERE main_category_id IN (254)
SQL query in 0.0016980171203613 - SELECT category_id, category, SUBSTRING_INDEX(path, "/", -1) AS path
, (SELECT IFNULL(COUNT(DISTINCT contact_id), NULL) FROM auszeichnungen
WHERE auszeichnungen.auszeichnung_category_id = categories.category_id) AS auszeichnungen
FROM categories
WHERE main_category_id IN (260,261,262,263,264,265,266)
SQL query in 0.00076699256896973 - SELECT category_id, category, SUBSTRING_INDEX(path, "/", -1) AS path
, (SELECT IFNULL(COUNT(DISTINCT contact_id), NULL) FROM auszeichnungen
WHERE auszeichnungen.auszeichnung_category_id = categories.category_id) AS auszeichnungen
FROM categories
WHERE main_category_id IN (365,366,367,368,370,371,372)
SQL query in 0.00065112113952637 - SELECT contact_id, contact, mother_contact_id, 0 AS _level
, contacts.identifier, contacts.description
FROM contacts
WHERE contacts.identifier = "auszeichnung-und-foerderung"
AND contact_category_id = 116
SQL query in 0.00094509124755859 - SELECT category_id, category, description
, SUBSTRING_INDEX(path, "/", -1) AS path
FROM categories
WHERE SUBSTRING_INDEX(path, "/", -1) = "auszeichnung-und-foerderung"
SQL query in 0.0013260841369629 - SELECT category_id, category, SUBSTRING_INDEX(path, "/", -1) AS path
, (SELECT IFNULL(COUNT(DISTINCT contact_id), NULL) FROM auszeichnungen
WHERE auszeichnungen.auszeichnung_category_id = categories.category_id) AS auszeichnungen
FROM categories
WHERE main_category_id IN (254)
SQL query in 0.0015549659729004 - SELECT category_id, category, SUBSTRING_INDEX(path, "/", -1) AS path
, (SELECT IFNULL(COUNT(DISTINCT contact_id), NULL) FROM auszeichnungen
WHERE auszeichnungen.auszeichnung_category_id = categories.category_id) AS auszeichnungen
FROM categories
WHERE main_category_id IN (260,261,262,263,264,265,266)
SQL query in 0.00085902214050293 - SELECT category_id, category, SUBSTRING_INDEX(path, "/", -1) AS path
, (SELECT IFNULL(COUNT(DISTINCT contact_id), NULL) FROM auszeichnungen
WHERE auszeichnungen.auszeichnung_category_id = categories.category_id) AS auszeichnungen
FROM categories
WHERE main_category_id IN (365,366,367,368,370,371,372)
SQL query in 0.010745048522949 - SELECT contact_id, contact, contacts.identifier
, contacts_identifiers.identifier AS zps_code
, members, members_female, members_u25
, members_u25/members AS anteil_members_u25
, members_female/members AS anteil_members_female
, IF((SELECT COUNT(*) FROM contacts_contacts
WHERE contacts_contacts.main_contact_id = contacts.contact_id
AND contacts_contacts.published = "yes"), "ja", "nein"
) AS spielort
, 1 AS _level
, aufloesung
FROM contacts
LEFT JOIN contacts_identifiers USING (contact_id)
LEFT JOIN vereinsdb_stats USING (contact_id)
LEFT JOIN auszeichnungen USING (contact_id)
WHERE auszeichnung_category_id IN (254,260,261,262,263,264,265,266,365,366,367,368,370,371,372)
ORDER BY contacts_identifiers.identifier, contacts.identifier
SQL query in 0.0033349990844727 - SELECT auszeichnung_id, contact_id, dauer_von, dauer_bis, anzeigename
FROM auszeichnungen
WHERE contact_id IN (29575,29550,29753,29206,29581,29567,29574,29754,29247,29817,29755,29572,29582,29552,29752,29425,29403,17746,29878,29231,29576,29723,29407,29722,30103,29155,29775,29388,29474,29259,29720,29553,29941,29569,29189,29881,29214,29566,29739,29381,29555,29408,29942,29218,29583,29742,29207,29812,29198,29186,29201,29192,29740,29557,29579,29564,29399,30046,29741,29076,29558,29984,29560,29880,29578,29577,29571,29232,29562,29090,29394,29554,29945,29884,29883,29747,29563,29570,29551,29199,29261,29679,29556,29568,29573,29619,29180,29565,29559,29598,29233,29183,29943,29580,29195,29410,29419,29882,29492,29561,29549,29940,29374,29548,29210,29735,26617,26683,26735,26787,26799,26812,27131,27148,27179,27183,27243,27250,27264,27268,27288,27330,27398,27414,27455,27500,29280,27628,27833,27904,27917,27978,28032,28012,28040,28078,28109,28117,29541,28294,28307,28362,28367,28369,29278,26314,28434,29769,28499,28556,28569,28599,28601,28609,28645,28742,28751,28760,28805,28916,28968,28997,29005,29281)
AND auszeichnung_category_id IN (254,260,261,262,263,264,265,266,365,366,367,368,370,371,372)
ORDER BY dauer_von ASC
SQL query in 0.0014169216156006 - SELECT setting_key, setting_value
FROM _settings
WHERE setting_key = "query_strings"
SQL query in 0.0011160373687744 - SHOW FIELDS FROM media
SQL query in 0.00046205520629883 - SHOW WARNINGS
SQL query in 0.00094008445739746 - SELECT page_id, medium_id, webpages_media.sequence
, IF(ISNULL(description), media.title, description) AS title
, description, alternative_text
, source, filename, version
, thumb_filetypes.extension AS thumb_extension
, media.date
, filetypes.extension AS extension
, filetypes.mime_content_type
, filetypes.mime_subtype
, filetypes.filetype
, filesize
, filetypes.filetype_description
, width_px, height_px
, IF(height_px > width_px, "portrait", "panorama") AS orientation
, CASE filetypes.mime_content_type
WHEN "image" THEN "images"
WHEN "video" THEN "videos"
ELSE "links" END
AS filecategory
FROM webpages_media
LEFT JOIN media USING (medium_id)
LEFT JOIN filetypes thumb_filetypes
ON media.thumb_filetype_id = thumb_filetypes.filetype_id
LEFT JOIN filetypes
ON media.filetype_id = filetypes.filetype_id
WHERE page_id IN (140)
AND published = "yes"
ORDER BY webpages_media.sequence, title, filename
SQL query in 0.0010490417480469 - SELECT page_id, title , CONCAT(identifier, IF(STRCMP(ending, 'none'), ending, '')) AS identifier , mother_page_id FROM webpages WHERE (website_id = 3) AND (live = "yes")
SQL query in 0.00052905082702637 - SELECT mother_page_id FROM webpages WHERE page_id = 140
SQL query in 0.0005190372467041 - SELECT mother_page_id FROM webpages WHERE page_id = 136
SQL query in 0.00095105171203613 - SELECT page_id, IF(LENGTH(title) > 24, SUBSTRING_INDEX(title, " ", 1), title) AS title , CONCAT(identifier, IF(ending != "none", ending, "")) AS url , mother_page_id, menu, description FROM webpages WHERE (NOT ISNULL(menu) AND live = 'yes' ) AND (website_id = 3) ORDER BY sequence