Schachverband Oberpfalz e.V.

Verein Karte? Mitglieder jugendlich U25 weiblich DWZ-Liste
Schachverband Oberpfalz e.V. · Karte 1 395 600 600 149 43,0 % 149 10,7 %
SK Kelheim 1920 ja 128 79 79 22 61,7 % 26001 22 17,2 % 26001
Schachklub Weiden 1907 ja 36 8 8 3 22,2 % 26003 3 8,3 % 26003
DJK-Regensburg Nord e.V. ja 31 3 3 3 9,7 % 26004 3 9,7 % 26004
Regensburger Turnerschaft ja 51 14 14 1 27,5 % 26007 1 2,0 % 26007
Schachfreunde Roding ja 37 20 20 5 54,1 % 26008 5 13,5 % 26008
SC Sulzbach-Rosenberg ja 42 19 19 2 45,2 % 26011 2 4,8 % 26011
SC Cham ja 29 13 13 2 44,8 % 26012 2 6,9 % 26012
SK Schwandorf ja 72 50 50 12 69,4 % 26014 12 16,7 % 26014
Schachclub Hirschau ja 32 13 13 1 40,6 % 26015 1 3,1 % 26015
TV 1899 Parsberg e.V. ja 34 14 14 6 41,2 % 26017 6 17,7 % 26017
FC Mintraching ja 15 0 0 26020 26020
TSV Dietfurt/Altm. e.V. ja 22 12 12 5 54,6 % 26021 5 22,7 % 26021
Schachfreunde Haselmühl/Amberg ja 92 50 50 9 54,4 % 26024 9 9,8 % 26024
SC Tirschenreuth v. 1922 ja 17 4 4 1 23,5 % 26026 1 5,9 % 26026
SV Saal/Donau e.V. ja 17 6 6 2 35,3 % 26027 2 11,8 % 26027
Turn- und Sportgemeinschaft Laaber e.V. ja 18 10 10 1 55,6 % 26030 1 5,6 % 26030
SC Furth im W./Waldmünchen ja 27 11 11 2 40,7 % 26031 2 7,4 % 26031
TSV Kareth-Lappersdorf ja 71 32 32 6 45,1 % 26032 6 8,5 % 26032
SC Bad Kötzting e.V. ja 43 13 13 2 30,2 % 26033 2 4,7 % 26033
Sportclub Sinzing e.V. ja 9 1 1 0 11,1 % 26035 26035
SC Erbendorf 1946 e.V. ja 35 11 11 2 31,4 % 26037 2 5,7 % 26037
SC Eulenspiegel Regensburg ja 12 0 1 26038 1 8,3 % 26038
1. FC Schwarzenfeld e.V. ja 15 4 4 0 26,7 % 26040 26040
SV Neustadt/Altenstadt ja 24 6 6 0 25,0 % 26042 26042
SC Windischeschenbach ja 70 37 37 11 52,9 % 26044 11 15,7 % 26044
Spvgg Hainsacker ja 16 3 3 0 18,8 % 26046 26046
SG Post/Süd Regensburg ja 40 21 21 5 52,5 % 26047 5 12,5 % 26047
SC Bavaria Regensburg von 1881 e.V. ja 115 60 60 18 52,2 % 26048 18 15,7 % 26048
SF Luhe-Wildenau e.V. ja 18 2 2 0 11,1 % 26049 26049
TSV Nittenau ja 23 7 7 2 30,4 % 26052 2 8,7 % 26052
TSV 1880 Schwandorf ja 12 0 0 26055 26055
ASV Burglengenfeld ja 26 6 6 0 23,1 % 26063 26063
Schachfreunde Tegernheim ja 84 45 45 17 53,6 % 26064 17 20,2 % 26064
TV Riedenburg Schach ja 44 19 19 6 43,2 % 26066 6 13,6 % 26066
SV Oberviechtach ja 38 7 7 2 18,4 % 26067 2 5,3 % 26067

Verband

Anzeige auf der Karte

SQL query in 0.00081610679626465 - 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-oberpfalz"

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

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

SQL query in 0.0023980140686035 - 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 (27016,27017,27018,27021,27022,27023,27025,27026,27027,27029,27030,27031,27032,27035,27036,27037,27038,27039,27040,27041,27042,27043,27044,27046,27047,27053,29536,27034,27020,27033,27045,27048,27049,27052,29535) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.00062680244445801 - SELECT contact_id, contact, mother_contact_id, 0 AS _level
, contacts.identifier, contacts.description
FROM contacts
WHERE contacts.identifier = "schachverband-oberpfalz"
AND contact_category_id = 116

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

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

SQL query in 0.00051498413085938 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26381)

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

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

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

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

SQL query in 0.0012228488922119 - SHOW FIELDS FROM media

SQL query in 0.0004119873046875 - SHOW WARNINGS

SQL query in 0.00090789794921875 - 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.0012791156768799 - 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.0038950443267822 - SELECT mother_page_id FROM webpages WHERE page_id = 140

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

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