Bonn/Rhein-Sieg e. V.

Verein Karte? Mitglieder jugendlich U25 weiblich DWZ-Liste
Bonn/Rhein-Sieg e. V. · Karte 780 286 286 60 36,7 % 60 7,7 %
Godesberger Schachklub 1929 e. V. ja 156 48 48 14 30,8 % 66202 14 9,0 % 66202
Schachgemeinschaft Siebengebirge e. V. ja 45 11 11 5 24,4 % 66203 5 11,1 % 66203
Schachverein Hennef 1927 e. V. ja 44 15 15 5 34,1 % 66205 5 11,4 % 66205
Schachclub 1919 Siegburg e. V. ja 60 19 19 3 31,7 % 66206 3 5,0 % 66206
Verein Rheinbacher Schachfreunde 1948 e. V. ja 38 9 9 2 23,7 % 66207 2 5,3 % 66207
1. Schach-Klub Troisdorf e. V. ja 71 37 37 4 52,1 % 66208 4 5,6 % 66208
Schachfreunde Lohmar 1974 e. V. ja 63 35 35 5 55,6 % 66211 5 7,9 % 66211
Schachklub Heimerzheim ja 27 8 8 2 29,6 % 66225 2 7,4 % 66225
Vereinigung der Schachsportfreunde Stadtverw. Bonn e. V. ja 101 48 48 8 47,5 % 66232 8 7,9 % 66232
SC Empor Maulwurf Bonn ja 14 0 1 66235 1 7,1 % 66235
Schachverein Turm Sankt Augustin e. V. ja 27 7 7 2 25,9 % 66237 2 7,4 % 66237
Tischtennisclub Grün-Weiß Fritzdorf 1958 e. V. ja 60 41 41 5 68,3 % 66239 5 8,3 % 66239
Schachclub Bonn Beuel ja 42 3 3 2 7,1 % 66243 2 4,8 % 66243
Schachfreunde Seelscheid e. V. ja 20 5 5 2 25,0 % 66244 2 10,0 % 66244
Schachclub Limperich e. V. ja 12 0 0 66248 66248

Verband

Anzeige auf der Karte

SQL query in 0.00090599060058594 - 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 = "bonn-rhein-sieg-ev"

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

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

SQL query in 0.0012838840484619 - 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 (27876,27877,27878,27879,27880,27881,27882,27883,27884,27885,27886,27888,27889,27890,27887) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.00069403648376465 - SELECT contact_id, contact, mother_contact_id, 0 AS _level
, contacts.identifier, contacts.description
FROM contacts
WHERE contacts.identifier = "bonn-rhein-sieg-ev"
AND contact_category_id = 116

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

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

SQL query in 0.0004270076751709 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26439)

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

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

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

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

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

SQL query in 0.0010268688201904 - SHOW FIELDS FROM media

SQL query in 0.00048208236694336 - SHOW WARNINGS

SQL query in 0.0010421276092529 - 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.00097799301147461 - 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.00043487548828125 - SELECT mother_page_id FROM webpages WHERE page_id = 140

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