SB Rheinhessen e.V.
| Verein | Karte? | Mitglieder | jugendlich U25 | weiblich | DWZ-Liste | ||
|---|---|---|---|---|---|---|---|
| SB Rheinhessen e.V. · Karte | 677 | 248 248 | 68 36,6 % | 68 | 10,0 % | ||
| SV Alzey | ja | 18 | 0 – | 0 – | 82001 – | – | 82001 |
| SV Pfeddersheim | ja | 24 | 1 1 | 3 4,2 % | 82003 3 | 12,5 % | 82003 |
| SC Landskrone | ja | 82 | 40 40 | 14 48,8 % | 82006 14 | 17,1 % | 82006 |
| Osthofener SV | ja | – | – | 8200A – | – | 8200A | |
| SK Bingen | ja | 37 | 11 11 | 0 29,7 % | 82010 – | – | 82010 |
| SV Bodenheim | ja | 26 | 12 12 | 0 46,2 % | 82011 – | – | 82011 |
| SK Gau-Algesheim | ja | 56 | 20 20 | 6 35,7 % | 82015 6 | 10,7 % | 82015 |
| Sfr. Heidesheim | ja | 81 | 37 37 | 11 45,7 % | 82018 11 | 13,6 % | 82018 |
| Sfr. Heimersheim | ja | 36 | 15 15 | 2 41,7 % | 82019 2 | 5,6 % | 82019 |
| Sfr. Mainz 1928 | ja | 80 | 24 24 | 5 30,0 % | 82023 5 | 6,3 % | 82023 |
| TSV Schott Mainz | ja | 62 | 11 11 | 8 17,7 % | 82024 8 | 12,9 % | 82024 |
| SV Mainz-Mombach | ja | 22 | 0 – | 0 – | 82025 – | – | 82025 |
| SV Multatuli Ingelheim e.V. | ja | 67 | 43 43 | 16 64,2 % | 82027 16 | 23,9 % | 82027 |
| TSG 1846 Bretzenheim/ZMO | ja | 15 | 4 4 | 0 26,7 % | 82028 – | – | 82028 |
| Vorwärts Orient Mainz | ja | 71 | 30 30 | 3 42,3 % | 82029 3 | 4,2 % | 82029 |
Verband
SQL query in 0.0014240741729736 - 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 = "sb-rheinhessen"
SQL query in 0.0010159015655518 - 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 (26456)
ORDER BY categories.sequence, identification
SQL query in 0.0029330253601074 - 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 (26456) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier
SQL query in 0.0017650127410889 - 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 (28195,28196,28197,29857,28199,28200,28202,28203,28204,28205,28207,28208,28209,28206,28210) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier
SQL query in 0.0042579174041748 - SELECT contact_id, contact, mother_contact_id, 0 AS _level
, contacts.identifier, contacts.description
FROM contacts
WHERE contacts.identifier = "sb-rheinhessen"
AND contact_category_id = 116
SQL query in 0.0024268627166748 - 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 = 26456
AND contact_category_id IN (117, 578)
AND ISNULL(aufloesung)
ORDER BY contacts_identifiers.identifier, contacts.identifier
SQL query in 0.0034370422363281 - 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 (26456)
ORDER BY categories.sequence, identification
SQL query in 0.00076794624328613 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26456)
SQL query in 0.0006101131439209 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26450)
SQL query in 0.00056600570678711 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26345)
SQL query in 0.00048613548278809 - SELECT contact_id, contact, identifier
FROM contacts
WHERE contact_id IN (26345,26450)
SQL query in 0.0021750926971436 - SELECT setting_key, setting_value
FROM _settings
WHERE setting_key = "query_strings"
SQL query in 0.0013830661773682 - SHOW FIELDS FROM media
SQL query in 0.00065493583679199 - SHOW WARNINGS
SQL query in 0.0012261867523193 - 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.0014088153839111 - 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.00054597854614258 - SELECT mother_page_id FROM webpages WHERE page_id = 140
SQL query in 0.00062894821166992 - SELECT mother_page_id FROM webpages WHERE page_id = 136
SQL query in 0.00097417831420898 - 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