Liste Thüringer Schachbund
| Verband | Vereine | Spielorte | Mitglieder | jugendlich U25 | weiblich | |||
|---|---|---|---|---|---|---|---|---|
| Thüringer Schachbund Karte | 82 | 77 | 93,9 % | 1 994 | 746 | 37,4 % | 214 | 10,7 % |
| Schachbezirk Nord Karte · Liste | 23 | 22 | 95,7 % | 391 | 130 | 33,2 % | 32 | 8,2 % |
| Schachkreis Kyffhäuser Karte · Liste | 3 | 3 | 100,0 % | 32 | 1 | 3,1 % | 1 | 3,1 % |
| Schachkreis Eichsfeld Karte · Liste | 9 | 9 | 100,0 % | 161 | 55 | 34,2 % | 9 | 5,6 % |
| Schachkreis Nordhausen Karte · Liste | 3 | 2 | 66,7 % | 62 | 29 | 46,8 % | 8 | 12,9 % |
| Schachkreis Unstrut-Hainich Karte · Liste | 5 | 5 | 100,0 % | 68 | 11 | 16,2 % | 0 | 0,0 % |
| Schachkreis Gotha Karte · Liste | 3 | 3 | 100,0 % | 68 | 34 | 50,0 % | 14 | 20,6 % |
| Schachbezirk Mitte Karte · Liste | 21 | 19 | 90,5 % | 708 | 298 | 42,1 % | 90 | 12,7 % |
| Schachkreis Erfurt Karte · Liste | 8 | 6 | 75,0 % | 295 | 128 | 43,4 % | 46 | 15,6 % |
| Schachkreis Weimarer Land Karte · Liste | 1 | 1 | 100,0 % | 27 | 8 | 29,6 % | 1 | 3,7 % |
| Schachkreis Sömmerda Karte · Liste | 1 | 1 | 100,0 % | 48 | 22 | 45,8 % | 5 | 10,4 % |
| Schachkreis Ilm-Kreis Karte · Liste | 10 | 10 | 100,0 % | 277 | 113 | 40,8 % | 34 | 12,3 % |
| Schachkreis Weimar Karte · Liste | 1 | 1 | 100,0 % | 61 | 27 | 44,3 % | 4 | 6,6 % |
| Schachbezirk Ost Karte · Liste | 25 | 24 | 96,0 % | 621 | 244 | 39,3 % | 77 | 12,4 % |
| Schachkreis Gera Karte · Liste | 5 | 4 | 80,0 % | 174 | 81 | 46,6 % | 31 | 17,8 % |
| Schachkreis Jena/Holzlandkreis Karte · Liste | 7 | 7 | 100,0 % | 177 | 55 | 31,1 % | 11 | 6,2 % |
| Schachkreis Greiz Karte · Liste | 5 | 5 | 100,0 % | 120 | 55 | 45,8 % | 19 | 15,8 % |
| Schachkreis Altenburger Land Karte · Liste | 2 | 2 | 100,0 % | 43 | 19 | 44,2 % | 8 | 18,6 % |
| Schachkreis Saalfeld-Rudolstadt/SOK Karte · Liste | 6 | 6 | 100,0 % | 107 | 34 | 31,8 % | 8 | 7,5 % |
| Schachbezirk Süd Karte · Liste | 13 | 12 | 92,3 % | 274 | 74 | 27,0 % | 15 | 5,5 % |
| Schachkreis Schmalkalden-Meiningen/Suhl Karte · Liste | 8 | 8 | 100,0 % | 191 | 59 | 30,9 % | 10 | 5,2 % |
| Schachkreis Sonneberg/Hildburghausen | ||||||||
| Schachkreis Wartburgkreis/Eisenach Karte · Liste | 5 | 4 | 80,0 % | 83 | 15 | 18,1 % | 5 | 6,0 % |
| Thüringer Schachjugend | ||||||||
Verband
SQL query in 0.00093293190002441 - 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 = "thueringen"
SQL query in 0.0010170936584473 - SELECT contact_id, contactdetail_id, identification, contact
, categories.parameters, category, label
, category_id
FROM contactdetails
LEFT JOIN contacts USING (contact_id)
LEFT JOIN categories
ON categories.category_id = contactdetails.provider_category_id
WHERE contact_id IN (26523)
ORDER BY categories.sequence, identification
SQL query in 0.0013659000396729 - SELECT contacts.contact_id, contact, category, contacts.identifier , (SELECT COUNT(*) FROM contacts_contacts WHERE contacts_contacts.main_contact_id = contacts.contact_id AND contacts_contacts.published = "yes" ) AS spielorte , members, members_female, members_u25, category_id ,mother_contact_id FROM contacts LEFT JOIN categories ON contacts.contact_category_id = categories.category_id LEFT JOIN vereinsdb_stats USING (contact_id) LEFT JOIN contacts_identifiers ON contacts_identifiers.contact_id = contacts.contact_id AND contacts_identifiers.current = "yes" WHERE mother_contact_id IN (26523) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier
SQL query in 0.0023500919342041 - SELECT contacts.contact_id, contact, category, contacts.identifier , (SELECT COUNT(*) FROM contacts_contacts WHERE contacts_contacts.main_contact_id = contacts.contact_id AND contacts_contacts.published = "yes" ) AS spielorte , members, members_female, members_u25, category_id ,mother_contact_id FROM contacts LEFT JOIN categories ON contacts.contact_category_id = categories.category_id LEFT JOIN vereinsdb_stats USING (contact_id) LEFT JOIN contacts_identifiers ON contacts_identifiers.contact_id = contacts.contact_id AND contacts_identifiers.current = "yes" WHERE mother_contact_id IN (26524,26530,26536,26542,29073) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier
SQL query in 0.0046548843383789 - SELECT contacts.contact_id, contact, category, contacts.identifier , (SELECT COUNT(*) FROM contacts_contacts WHERE contacts_contacts.main_contact_id = contacts.contact_id AND contacts_contacts.published = "yes" ) AS spielorte , members, members_female, members_u25, category_id ,mother_contact_id FROM contacts LEFT JOIN categories ON contacts.contact_category_id = categories.category_id LEFT JOIN vereinsdb_stats USING (contact_id) LEFT JOIN contacts_identifiers ON contacts_identifiers.contact_id = contacts.contact_id AND contacts_identifiers.current = "yes" WHERE mother_contact_id IN (26525,26526,26527,26528,26529,26531,26532,26533,26534,26535,26537,26538,26539,26540,26541,26543,29098,26544,29192,29588,29673,29186,29364,29668,29089,29330,29656,29247,29641,29206,29629,29715,29194,29613,29681) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier
SQL query in 0.0036067962646484 - SELECT contacts.contact_id, contact, category, contacts.identifier , (SELECT COUNT(*) FROM contacts_contacts WHERE contacts_contacts.main_contact_id = contacts.contact_id AND contacts_contacts.published = "yes" ) AS spielorte , members, members_female, members_u25, category_id ,mother_contact_id FROM contacts LEFT JOIN categories ON contacts.contact_category_id = categories.category_id LEFT JOIN vereinsdb_stats USING (contact_id) LEFT JOIN contacts_identifiers ON contacts_identifiers.contact_id = contacts.contact_id AND contacts_identifiers.current = "yes" WHERE mother_contact_id IN (28971,28972,28973,28974,28976,28977,28978,28979,28980,28981,28983,28984,29952,28985,28986,28988,28991,28992,28989,28990,28993,28995,28994,30038,30198,28996,28997,29000,29001,28998,28999,29002,29003,29005,29006,29007,29008,29009,29010,29011,29012,29013,29014,29954,29016,29017,29018,29019,29270,29020,29021,29022,29023,29024,29025,29527,29026,29027,29028,29029,29030,29031,29033,29034,29035,29036,29269,29032,29037,29040,29041,29043,29045,29038,29039,29044,29046,29049,29050,29047,29051,29015) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier
SQL query in 0.00056815147399902 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26523)
SQL query in 0.00051188468933105 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26345)
SQL query in 0.00054597854614258 - SELECT contact_id, contact, identifier
FROM contacts
WHERE contact_id IN (26345)
SQL query in 0.0011048316955566 - SELECT setting_key, setting_value
FROM _settings
WHERE setting_key = "query_strings"
SQL query in 0.0012118816375732 - SHOW FIELDS FROM media
SQL query in 0.00064802169799805 - SHOW WARNINGS
SQL query in 0.0010030269622803 - 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.0010049343109131 - 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.00059318542480469 - SELECT mother_page_id FROM webpages WHERE page_id = 140
SQL query in 0.00055384635925293 - SELECT mother_page_id FROM webpages WHERE page_id = 136
SQL query in 0.00087094306945801 - 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