Schachvereine: Grünes Band

Das Grüne Band ist die höchstdotierte Auszeichnung für vorbildliche Talentförderung in den Sportvereinen. Gemeinsam mit dem Deutschen Olympischen Sportbund (DOSB) schreibt die Commerzbank diesen Preis jährlich aus. Die 50 besten Sportvereine aus olympischen und nicht-olympischen Sportarten – darunter auch Schach – erhalten ein Preisgeld in Höhe von jeweils 5.000 Euro.

Weitere Informationen zum Grünen Band

Anzahl der angezeigten Spielorte: 22

SQL query in 0.00064992904663086 - SELECT contact_id, contact
FROM contacts
LEFT JOIN categories
ON contacts.contact_category_id = categories.category_id
WHERE identifier = "gruenes-band"
AND categories.parameters LIKE "%&organisation=1%"

SQL query in 0.00088715553283691 - SELECT category_id, category, description
, SUBSTRING_INDEX(path, "/", -1) AS path
FROM categories
WHERE SUBSTRING_INDEX(path, "/", -1) = "gruenes-band"

SQL query in 0.00074195861816406 - 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 (261)

SQL query in 0.0008690357208252 - SELECT contact_id FROM contacts
LEFT JOIN auszeichnungen USING (contact_id)
WHERE auszeichnung_category_id IN (261)

SQL query in 0.0026350021362305 - SELECT cc_id AS id
, organisationen.contact AS title, places.contact AS veranstaltungsort
, latitude AS x_latitude, longitude AS y_longitude
, SUBSTRING_INDEX(categories.path, "/", -1) AS category
, members, members_female AS female, members_u25 AS u25, (YEAR(CURDATE()) - avg_byear) AS avg_age, avg_rating
, organisationen.identifier
, (SELECT IFNULL(COUNT(auszeichnung_id), NULL) FROM auszeichnungen
WHERE auszeichnungen.contact_id = organisationen.contact_id) AS auszeichnungen
, organisationen.contact_id

FROM contacts organisationen
LEFT JOIN vereinsdb_stats USING (contact_id)
JOIN contacts_contacts
ON contacts_contacts.main_contact_id = organisationen.contact_id
JOIN contacts places
ON contacts_contacts.contact_id = places.contact_id
JOIN addresses
ON places.contact_id = addresses.contact_id
JOIN categories
ON organisationen.contact_category_id = categories.category_id
WHERE ISNULL(organisationen.aufloesung)
AND NOT ISNULL(latitude) AND NOT ISNULL(longitude)
AND contacts_contacts.published = "yes"
AND categories.parameters LIKE "%&organisation=1%"
AND contacts_contacts.sequence = 1
AND organisationen.contact_id IN (28599,29005,28556,28751,28805,27500,28369,26617,27243,27179,27250,29769,28307,29278,27268,28997,26314,27183,28916,28645,28367)

SQL query in 0.0083029270172119 - SELECT COUNT(*) FROM contacts
WHERE contact_category_id IN (117, 578) AND ISNULL(aufloesung)

SQL query in 0.00085997581481934 - SELECT setting_key, setting_value
FROM _settings
WHERE setting_key = "query_strings"

SQL query in 0.00096011161804199 - SHOW FIELDS FROM media

SQL query in 0.00039815902709961 - SHOW WARNINGS

SQL query in 0.00076413154602051 - 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.00095701217651367 - 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.00053691864013672 - SELECT mother_page_id FROM webpages WHERE page_id = 140

SQL query in 0.00047612190246582 - SELECT mother_page_id FROM webpages WHERE page_id = 136

SQL query in 0.00075507164001465 - 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