Liste BV Oberbayern e.V.

Verband Vereine Spielorte Mitglieder jugendlich U25 weiblich
BV Oberbayern e.V.   Karte 71 70 98,6 % 3 036 1 170 38,5 % 275 9,1 %
Schachkreis IN-FS   Karte · Liste 18 18 100,0 % 887 375 42,3 % 93 10,5 %
Schachkreis Inn-Chiemgau   Karte · Liste 27 27 100,0 % 1 000 311 31,1 % 63 6,3 %
Schachkreis Zugspitze   Karte · Liste 26 25 96,2 % 1 149 484 42,1 % 119 10,4 %

Verband

Anzeige auf der Karte

SQL query in 0.0012681484222412 - 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 = "bv-oberbayern"

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

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

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

SQL query in 0.0039389133453369 - 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 (26875,26876,26877,26879,26880,26881,26882,26883,26890,26891,26893,26894,26895,26878,26885,26887,26889,26897,26899,26901,26902,26903,26905,26906,26907,26908,26909,26910,26911,26912,26913,26914,26917,26918,26919,26920,26921,26923,29730,30029,26900,26904,26915,26916,26922,26924,26926,26927,26929,26930,26933,26934,26937,26938,26939,26941,26942,26943,26945,26946,26947,26948,26950,26951,26952,29847,26925,26928,26931,26940,26949) 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 (26370)

SQL query in 0.00079107284545898 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26361)

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

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

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

SQL query in 0.001230001449585 - SHOW FIELDS FROM media

SQL query in 0.00053095817565918 - SHOW WARNINGS

SQL query in 0.0010590553283691 - 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.0010478496551514 - 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.00066614151000977 - SELECT mother_page_id FROM webpages WHERE page_id = 140

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

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