Schachvereine und Schulschachgruppen

In Deutschland gibt es 2316 Schachvereine. Finde hier den richtigen für Dich!

Suche: Görlitz

Anzahl der angezeigten Spielorte: 1

SQL query in 0.00054001808166504 - SELECT contact_id, contact
FROM contacts
LEFT JOIN categories
ON contacts.contact_category_id = categories.category_id
WHERE identifier = "G%C3%B6rlitz"
AND categories.parameters LIKE "%&organisation=1%"

SQL query in 0.00078892707824707 - SELECT category_id, category, description
, SUBSTRING_INDEX(path, "/", -1) AS path
FROM categories
WHERE SUBSTRING_INDEX(path, "/", -1) = "G%C3%B6rlitz"

SQL query in 0.12452697753906 - SELECT cc_id AS id
, organisationen.contact AS title, places.contact AS veranstaltungsort
, latitude AS x_latitude, longitude AS y_longitude
, SUBSTRING_INDEX(categories.path, "/", -1) AS category
, members, members_female AS female, members_u25 AS u25, (YEAR(CURDATE()) - avg_byear) AS avg_age, avg_rating
, organisationen.identifier
, (SELECT IFNULL(COUNT(auszeichnung_id), NULL) FROM auszeichnungen
WHERE auszeichnungen.contact_id = organisationen.contact_id) AS auszeichnungen
, organisationen.contact_id
, 6371 * (ACOS(SIN(51.1563185*Pi()/180)*SIN(latitude*Pi()/180)+COS(51.1563185*Pi()/180)*COS(latitude*Pi()/180)*COS((14.991018-longitude)*Pi()/180))) AS distance
FROM contacts organisationen
LEFT JOIN vereinsdb_stats USING (contact_id)
JOIN contacts_contacts
ON contacts_contacts.main_contact_id = organisationen.contact_id
JOIN contacts places
ON contacts_contacts.contact_id = places.contact_id
JOIN addresses
ON places.contact_id = addresses.contact_id
JOIN categories
ON organisationen.contact_category_id = categories.category_id
WHERE ISNULL(organisationen.aufloesung)
AND NOT ISNULL(latitude) AND NOT ISNULL(longitude)
AND contacts_contacts.published = "yes"
AND categories.parameters LIKE "%&organisation=1%"
HAVING distance <= 5 ORDER BY distance

SQL query in 0.027388095855713 - SELECT o.contact_id, o.identifier, o.contact
, h.contact AS main_contact
, o.contact_category_id
, (SELECT COUNT(*) FROM contacts WHERE mother_contact_id = o.contact_id) AS rang
FROM contacts o
LEFT JOIN categories
ON o.contact_category_id = categories.category_id
LEFT JOIN contacts h
ON o.mother_contact_id = h.contact_id
WHERE o.contact LIKE "%Görlitz%"
AND categories.parameters LIKE "%&organisation=1%"
AND ISNULL(o.aufloesung)
ORDER BY rang DESC, o.identifier

SQL query in 0.008030891418457 - SELECT COUNT(*) FROM contacts
WHERE contact_category_id IN (117, 578) AND ISNULL(aufloesung)

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

SQL query in 0.0011730194091797 - SHOW FIELDS FROM media

SQL query in 0.0005500316619873 - SHOW WARNINGS

SQL query in 0.00098085403442383 - 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.00083613395690918 - 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.00052714347839355 - SELECT mother_page_id FROM webpages WHERE page_id = 140

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

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