Liste Schachverband Ostwestfalen-Lippe e. V.
| Verband | Vereine | Spielorte | Mitglieder | jugendlich U25 | weiblich | |||
|---|---|---|---|---|---|---|---|---|
| Schachverband Ostwestfalen-Lippe e. V. Karte | 66 | 66 | 100,0 % | 2 527 | 974 | 38,5 % | 194 | 7,7 % |
| Schachbezirk Bielefeld Karte · Liste | 18 | 18 | 100,0 % | 663 | 223 | 33,6 % | 37 | 5,6 % |
| Schachbezirk Hellweg Karte · Liste | 13 | 13 | 100,0 % | 592 | 253 | 42,7 % | 55 | 9,3 % |
| Schachbezirk Lippe Karte · Liste | 11 | 11 | 100,0 % | 339 | 117 | 34,5 % | 24 | 7,1 % |
| Schachbezirk Porta Karte · Liste | 17 | 17 | 100,0 % | 735 | 301 | 41,0 % | 64 | 8,7 % |
| Schachbezirk Teutoburger Wald-West Karte · Liste | 7 | 7 | 100,0 % | 198 | 80 | 40,4 % | 14 | 7,1 % |
Verband
SQL query in 0.00066208839416504 - 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-ostwestfalen-lippe"
SQL query in 0.00090384483337402 - 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 (26427)
ORDER BY categories.sequence, identification
SQL query in 0.0012140274047852 - 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 (26427) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier
SQL query in 0.0035679340362549 - 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 (26428,26429,26430,26431,26432) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier
SQL query in 0.0031099319458008 - 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 (27737,27738,27739,27740,27741,27742,27744,27745,27746,27747,27748,27749,27750,27752,27753,27754,27755,27751,29272,27756,27759,27760,27761,27762,27763,27766,27767,27768,29518,27764,27765,27770,27771,27772,27773,27774,27775,27776,27777,27781,27778,27780,27782,27783,27784,27785,29102,27786,27787,27788,27789,27790,27792,27793,27794,27795,27796,27797,27798,27799,27800,27801,27802,27803,27805,27806) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier
SQL query in 0.00060296058654785 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26427)
SQL query in 0.00052905082702637 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26405)
SQL query in 0.00049400329589844 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26345)
SQL query in 0.00055813789367676 - SELECT contact_id, contact, identifier
FROM contacts
WHERE contact_id IN (26345,26405)
SQL query in 0.0007319450378418 - SELECT setting_key, setting_value
FROM _settings
WHERE setting_key = "query_strings"
SQL query in 0.00099515914916992 - SHOW FIELDS FROM media
SQL query in 0.00037288665771484 - SHOW WARNINGS
SQL query in 0.00083422660827637 - 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.00091886520385742 - 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.00046300888061523 - SELECT mother_page_id FROM webpages WHERE page_id = 140
SQL query in 0.00058293342590332 - SELECT mother_page_id FROM webpages WHERE page_id = 136
SQL query in 0.0013861656188965 - 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