Kölner Schachverband von 1920 e. V.

Verein Karte? Mitglieder jugendlich U25 weiblich DWZ-Liste
Kölner Schachverband von 1920 e. V. · Karte 1 496 490 490 104 32,8 % 104 7,0 %
Bergische Schachfreunde 1923 Bergisch Gladbach e. V. ja 107 36 36 4 33,6 % 66301 4 3,7 % 66301
Schachverein 1925 Hürth-Berrenrath ja 34 12 12 1 35,3 % 66302 1 2,9 % 66302
Brühler Schachklub 1920 e. V. ja 129 29 29 10 22,5 % 66304 10 7,8 % 66304
Roter Stern Köln-Mülheim e. V. ja 16 2 2 2 12,5 % 66305 2 12,5 % 66305
Schachverein Dormagen 1947 ja 42 10 10 1 23,8 % 66307 1 2,4 % 66307
Schachklub Turm Euskirchen 65 ja 45 9 9 3 20,0 % 66311 3 6,7 % 66311
Ford Schachfreunde Köln e. V. ja 57 13 13 2 22,8 % 66313 2 3,5 % 66313
Betriebssportgemeinschaft Rheinpark e. V. ja 19 0 0 66315 66315
Schachklub Köln-Südwest ja 54 25 25 0 46,3 % 66318 66318
Klub Kölner Schachfreunde e. V. 1967 ja 114 49 49 5 43,0 % 66319 5 4,4 % 66319
Kölner Schachklub Dr. Lasker 1861 e. V. ja 77 3 3 4 3,9 % 66320 4 5,2 % 66320
Schachfreunde Köln-Longerich 1956 ja 22 1 1 0 4,6 % 66322 66322
Schachfreunde Köln-Mülheim e. V. ja 46 19 19 0 41,3 % 66323 66323
Schachfreunde Rodenkirchen e. V. ja 25 1 1 2 4,0 % 66331 2 8,0 % 66331
Schachverein Horrem 1948 ja 21 1 1 2 4,8 % 66334 2 9,5 % 66334
Pulheimer Sport-Club 1924/57 e. V. ja 46 9 9 2 19,6 % 66335 2 4,4 % 66335
Schachgemeinschaft Porz e. V. ja 175 98 98 30 56,0 % 66340 30 17,1 % 66340
Schachgemeinschaft Rochade Brauweiler 1979 e. V. ja 25 10 10 1 40,0 % 66341 1 4,0 % 66341
Schachklub Köln-Worringen 1972 ja 46 27 27 3 58,7 % 66342 3 6,5 % 66342
Schachgemeinschaft Niederkassel e. V. ja 85 36 36 7 42,4 % 66343 7 8,2 % 66343
SF Köln-Müngersdorf 1935 ja 21 6 6 1 28,6 % 66344 1 4,8 % 66344
Schachfreunde Esch e. V. ja 23 2 2 1 8,7 % 66345 1 4,4 % 66345
Schachclub Poller Schachesel 80 ja 13 0 0 66348 66348
Schachverein Erftstadt e. V. ja 94 47 47 13 50,0 % 66357 13 13,8 % 66357
Schachgemeinschaft Kalker/Deutzer 19/25 ja 30 3 3 1 10,0 % 66360 1 3,3 % 66360
SC Schachuzipus Köln-Mülheim ja 15 0 1 66361 1 6,7 % 66361
Satranç Club 2000 e. V. ja 36 6 6 2 16,7 % 66362 2 5,6 % 66362
Schachklub Kerpen 64 e. V. ja 61 36 36 6 59,0 % 66364 6 9,8 % 66364
Schachverein Grünfeld e. V. ja 18 0 0 66367 66367

Verband

Anzeige auf der Karte

SQL query in 0.0008389949798584 - 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 = "koelner-schachverband-von-1920"

SQL query in 0.0007479190826416 - 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 (26440)
ORDER BY categories.sequence, identification

SQL query in 0.0020051002502441 - 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 (26440) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.0018658638000488 - 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 (27892,27893,27895,29524,27896,27897,27898,27899,27900,27901,27902,27903,27904,27905,27907,27911,27912,27914,27915,27916,27917,27918,27919,27920,27921,27922,27913,27910,27908) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.00069284439086914 - SELECT contact_id, contact, mother_contact_id, 0 AS _level
, contacts.identifier, contacts.description
FROM contacts
WHERE contacts.identifier = "koelner-schachverband-von-1920"
AND contact_category_id = 116

SQL query in 0.0018551349639893 - 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 mother_contact_id = 26440
AND contact_category_id IN (117, 578)
AND ISNULL(aufloesung)
ORDER BY contacts_identifiers.identifier, contacts.identifier

SQL query in 0.00056600570678711 - 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 (26440)
ORDER BY categories.sequence, identification

SQL query in 0.0004570484161377 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26440)

SQL query in 0.00042104721069336 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26437)

SQL query in 0.00041413307189941 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26405)

SQL query in 0.00056099891662598 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26345)

SQL query in 0.00056791305541992 - SELECT contact_id, contact, identifier
FROM contacts
WHERE contact_id IN (26345,26405,26437)

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

SQL query in 0.0010581016540527 - SHOW FIELDS FROM media

SQL query in 0.00046801567077637 - SHOW WARNINGS

SQL query in 0.00083708763122559 - 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.00086092948913574 - 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.00047087669372559 - SELECT mother_page_id FROM webpages WHERE page_id = 140

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

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