Liste SV Ruhrgebiet e. V.

Verband Vereine Spielorte Mitglieder jugendlich U25 weiblich
SV Ruhrgebiet e. V.   Karte 87 87 100,0 % 3 929 1 174 29,9 % 270 6,9 %
Schachbezirk Bochum   Karte · Liste 15 15 100,0 % 584 125 21,4 % 22 3,8 %
Schachgemeinschaft Dortmund   Karte · Liste 17 17 100,0 % 810 277 34,2 % 61 7,5 %
Essener Schachverband e. V.   Karte · Liste 12 12 100,0 % 571 166 29,1 % 47 8,2 %
Schachbezirk Emscher-Lippe   Karte · Liste 13 13 100,0 % 572 140 24,5 % 42 7,3 %
Schachbezirk Hamm   Karte · Liste 12 12 100,0 % 540 206 38,1 % 33 6,1 %
Mülheim an der Ruhr 1922 e. V.   Karte · Liste 3 3 100,0 % 206 66 32,0 % 22 10,7 %
Schachbezirk Herne – Vest   Karte · Liste 15 15 100,0 % 646 194 30,0 % 43 6,7 %

Verband

Anzeige auf der Karte

SQL query in 0.00075197219848633 - 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 = "sv-ruhrgebiet-ev"

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

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

SQL query in 0.0046191215515137 - 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 (26407,26408,26409,26410,26411,26412,26413) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.0040099620819092 - 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 (27476,27477,27479,27481,27482,27483,27484,27485,27486,27487,27488,27489,27492,27480,27478,27495,27497,27498,27499,27502,27503,27504,27505,27507,27508,27509,27510,27511,27512,29273,27500,27501,27513,27514,27516,27517,27518,27519,27520,27522,27523,27524,27515,27521,27526,27527,27528,27529,27530,27531,27532,27533,27534,27535,27536,27538,27537,27540,27541,27542,27543,27544,27545,27546,27547,27548,27549,27550,30039,27551,27552,27553,27554,27555,27556,27557,27558,27559,27560,27561,27562,27563,27564,27566,27567,27569,27570) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.00081896781921387 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26406)

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

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

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

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

SQL query in 0.0010130405426025 - SHOW FIELDS FROM media

SQL query in 0.00047802925109863 - SHOW WARNINGS

SQL query in 0.00097298622131348 - 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.0010409355163574 - 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.00067687034606934 - SELECT mother_page_id FROM webpages WHERE page_id = 140

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

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