Liste Schachverband Mittelrhein e. V.

Verband Vereine Spielorte Mitglieder jugendlich U25 weiblich
Schachverband Mittelrhein e. V.   Karte 88 88 100,0 % 3 781 1 284 34,0 % 278 7,4 %
Aachener Schachverband 1928 e. V.   Karte · Liste 22 22 100,0 % 806 246 30,5 % 54 6,7 %
Bonn/Rhein-Sieg e. V.   Karte · Liste 15 15 100,0 % 780 286 36,7 % 60 7,7 %
Kölner Schachverband von 1920 e. V.   Karte · Liste 29 29 100,0 % 1 496 490 32,8 % 104 7,0 %
Schachbezirk Rur-Erft   Karte · Liste 12 12 100,0 % 278 87 31,3 % 23 8,3 %
Schachbezirk Rhein-Wupper   Karte · Liste 10 10 100,0 % 421 175 41,6 % 37 8,8 %

Verband

Anzeige auf der Karte

SQL query in 0.00097298622131348 - 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 = "schachverband-mittelrhein-ev"

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

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

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

SQL query in 0.0044019222259521 - 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,27876,27877,27878,27879,27880,27881,27882,27883,27884,27885,27886,27888,27889,27890,27887,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,27924,27925,29122,27926,27929,27930,27932,27933,27936,27931,27934,27935,27939,27940,27941,27942,27943,27944,27945,27946,27947,27948) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

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

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

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

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

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

SQL query in 0.0010240077972412 - SHOW FIELDS FROM media

SQL query in 0.0004429817199707 - SHOW WARNINGS

SQL query in 0.00087118148803711 - 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.0012550354003906 - 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.00049495697021484 - SELECT mother_page_id FROM webpages WHERE page_id = 140

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

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