Aachener Schachverband 1928 e. V.

Verein Karte? Mitglieder jugendlich U25 weiblich DWZ-Liste
Aachener Schachverband 1928 e. V. · Karte 806 246 246 54 30,5 % 54 6,7 %
Aachener Schach-Gesellschaft 1930 ja 10 0 1 66101 1 10,0 % 66101
Aachener Schachverein 1856 e. V. ja 91 23 23 11 25,3 % 66102 11 12,1 % 66102
Schachvereinigung 1928 Alsdorf e. V. ja 19 5 5 0 26,3 % 66103 66103
Turnverein „Eifeler Turnkraft“ Konzen 1922 e. V. ja 1 0 0 66104 66104
DJK Aufwärts St. Josef Aachen 1920 ja 101 32 32 7 31,7 % 66105 7 6,9 % 66105
DJK Arminia Eilendorf 1919 e. V. ja 39 17 17 1 43,6 % 66107 1 2,6 % 66107
Eschweiler Schachclub 1921 e. V. ja 23 1 1 2 4,4 % 66108 2 8,7 % 66108
Schachverein 1949 Herzogenrath ja 55 8 8 6 14,6 % 66109 6 10,9 % 66109
Schachgesellschaft Kohlscheid 1926 e. V. ja 25 3 3 0 12,0 % 66110 66110
Post-Telekom SV 1925 Aachen e. V. ja 39 2 2 1 5,1 % 66113 1 2,6 % 66113
Schachclub Roetgen 1952 ja 23 1 1 0 4,4 % 66114 66114
Stolberger Schachverein 1927 ja 40 11 11 4 27,5 % 66117 4 10,0 % 66117
Schachvereinigung Übach-Palenberg 1934 e. V. ja 28 9 9 3 32,1 % 66118 3 10,7 % 66118
Schachverein Würselen 1926 e. V. ja 79 50 50 5 63,3 % 66119 5 6,3 % 66119
Schachverein Lendersdorf 57 e. V. ja 36 12 12 0 33,3 % 66410 66410
Schachfreunde 1980 Baesweiler e. V. ja 34 6 6 0 17,7 % 66121 66121
Schachclub Kalterherberg 1980 e. V. ja 27 8 8 1 29,6 % 66122 1 3,7 % 66122
Schachfreunde Brand 1981 e. V. ja 44 15 15 3 34,1 % 66124 3 6,8 % 66124
Schachclub Tigerli PP Aachen ja 17 2 2 2 11,8 % 66125 2 11,8 % 66125
Schachfreunde Geilenkirchen 1984 ja 42 26 26 3 61,9 % 66126 3 7,1 % 66126
SV Sportfreunde Aachen-Hörn 1948 e. V. ja 19 14 14 2 73,7 % 66127 2 10,5 % 66127
Salonremis Aachen Null-Null ja 14 1 1 2 7,1 % 66128 2 14,3 % 66128

Verband

Anzeige auf der Karte

SQL query in 0.0008089542388916 - 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 = "aachener-schachverband-1928-ev"

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

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

SQL query in 0.0016069412231445 - 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 (27855,27856,27857,29103,27858,27859,27860,27861,27862,27864,27866,27867,27868,27928,27869,27870,27871,27872,27873,27875,27863,27874) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.00068902969360352 - SELECT contact_id, contact, mother_contact_id, 0 AS _level
, contacts.identifier, contacts.description
FROM contacts
WHERE contacts.identifier = "aachener-schachverband-1928-ev"
AND contact_category_id = 116

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

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

SQL query in 0.00053215026855469 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26438)

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

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

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

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

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

SQL query in 0.0012428760528564 - SHOW FIELDS FROM media

SQL query in 0.00075006484985352 - SHOW WARNINGS

SQL query in 0.0011270046234131 - 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.0011849403381348 - 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.00056099891662598 - SELECT mother_page_id FROM webpages WHERE page_id = 140

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

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