Schachbezirk 5 Frankfurt e. V.

Verein Karte? Mitglieder jugendlich U25 weiblich DWZ-Liste
Schachbezirk 5 Frankfurt e. V. · Karte 1 080 395 395 85 36,6 % 85 7,9 %
SK Bad Homburg 1927 ja 133 64 64 15 48,1 % 55001 15 11,3 % 55001
SC Bergen-Enkheim 1922 ja 30 5 5 0 16,7 % 55002 55002
SC Eschbach im Usinger Land ja 34 2 2 1 5,9 % 55003 1 2,9 % 55003
SV 1926 Fechenheim ja 25 7 7 1 28,0 % 55004 1 4,0 % 55004
SF Frankfurt 1921 ja 75 21 21 2 28,0 % 55005 2 2,7 % 55005
SF 1891 Friedberg ja 39 19 19 1 48,7 % 55006 1 2,6 % 55006
FV Berkersheim ja 20 1 1 1 5,0 % 55009 1 5,0 % 55009
SV 1926 Neu-Isenburg ja 39 14 14 0 35,9 % 55010 55010
SC Bad Nauheim ja 91 40 40 2 44,0 % 55023 2 2,2 % 55023
SV Oberursel ja 94 47 47 18 50,0 % 55024 18 19,2 % 55024
SC Brett vorm Kopp Ffm ja 36 0 1 55026 1 2,8 % 55026
Bad Vilbeler Sfr. 1985 ja 40 11 11 1 27,5 % 55027 1 2,5 % 55027
TuS Makkabi Ffm ja 53 28 28 5 52,8 % 55032 5 9,4 % 55032
Blindenschachklub Frankfurt ja 16 0 2 55033 2 12,5 % 55033
SC Matt im Park Ffm ja 35 1 1 2 2,9 % 55034 2 5,7 % 55034
Frankfurter TV 1860 ja 70 32 32 5 45,7 % 55036 5 7,1 % 55036
Niederräder TG ja 14 1 1 2 7,1 % 55038 2 14,3 % 55038
Chess Tigers Schach-Förderverein 1999 ja 49 18 18 4 36,7 % 55039 4 8,2 % 55039
SV Frankfurt Nord 1926 ja 56 28 28 4 50,0 % 55040 4 7,1 % 55040
SG 2001 Griesheim nein 2 0 0 55041 55041
SK 1858 Gießen ja 92 37 37 10 40,2 % 55042 10 10,9 % 55042
SK Königsjäger Hungen ja 37 19 19 8 51,4 % 55043 8 21,6 % 55043

Verband

Anzeige auf der Karte

SQL query in 0.00095105171203613 - 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 = "schachbezirk-5-frankfurt-ev"

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

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

SQL query in 0.0014688968658447 - 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 (27369,27370,27371,27372,27373,27374,29539,27375,27377,27378,27380,27381,27383,27384,27387,27388,27389,27390,27391,27382,27385,27386) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.00067496299743652 - SELECT contact_id, contact, mother_contact_id, 0 AS _level
, contacts.identifier, contacts.description
FROM contacts
WHERE contacts.identifier = "schachbezirk-5-frankfurt-ev"
AND contact_category_id = 116

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

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

SQL query in 0.00059294700622559 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26399)

SQL query in 0.00055480003356934 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26394)

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

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

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

SQL query in 0.0013461112976074 - SHOW FIELDS FROM media

SQL query in 0.00046706199645996 - SHOW WARNINGS

SQL query in 0.00095605850219727 - 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.0010190010070801 - 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.00056600570678711 - SELECT mother_page_id FROM webpages WHERE page_id = 140

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

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