Liste Pfälzischer Schachbund e.V.

Verband Vereine Spielorte Mitglieder jugendlich U25 weiblich
Pfälzischer Schachbund e.V.   Karte 63 62 98,4 % 2 076 718 34,6 % 180 8,7 %
Bezirk I Kaiserslautern   Karte · Liste 12 12 100,0 % 291 98 33,7 % 22 7,6 %
Bezirk II Ludwigshafen   Karte · Liste 11 10 90,9 % 418 154 36,8 % 39 9,3 %
Bezirk III Neustadt   Karte · Liste 7 7 100,0 % 235 76 32,3 % 22 9,4 %
Bezirk IV Landau   Karte · Liste 13 13 100,0 % 505 195 38,6 % 42 8,3 %
Bezirk V Pirmasens   Karte · Liste 8 8 100,0 % 191 50 26,2 % 20 10,5 %
Bezirk VI Ramstein   Karte · Liste 12 12 100,0 % 436 145 33,3 % 35 8,0 %

Verband

Anzeige auf der Karte

SQL query in 0.0010130405426025 - 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 = "pfaelzischer-schachbund"

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

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

SQL query in 0.0037028789520264 - 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 (26458,26459,26460,26461,26462,26463) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.0030300617218018 - 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 (28211,28212,28214,28215,28216,28217,28218,28219,28221,28222,28213,28220,28223,28224,28226,28228,28229,28230,28231,28232,28233,28225,30033,28234,28236,28237,28239,28240,28238,28241,28242,28243,28244,28245,28246,28247,28248,28249,28250,28251,28252,28253,28254,28255,28256,28257,28258,28259,28262,28263,28264,28265,28266,28267,28150,28269,28270,28271,28272,28273,28274,28275,28276) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.00056099891662598 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26457)

SQL query in 0.00044417381286621 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26450)

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

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

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

SQL query in 0.0010130405426025 - SHOW FIELDS FROM media

SQL query in 0.00037097930908203 - SHOW WARNINGS

SQL query in 0.0009009838104248 - 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.00096392631530762 - 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.00048685073852539 - SELECT mother_page_id FROM webpages WHERE page_id = 140

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

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