query-1ec8c969205302638f9d5119a60b84db

rq turtle/ttl

14:25, 22 November 2021 (UTC)) talk (Nthep all the entries get duplicated. ?club wdt:P625 ?coord.If I add in any lines like : I think this is what you're after...Nthep@

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT  ?clubLabel ?stadiumLabel ?coord  (year(?inuse) as ?startyear)  (year(?oou) as ?endyear) WHERE {
  ?club wdt:P463 wd:Q1127622. #find clubs that are members (P463) of the RFL (Q1127622)
# using the p prefix to access qualifiers
  ?club p:P115 ?stadium_statement . #items that have stadium(s)...
# note we use ps to get the actual value and pq for the qualifiers
  ?stadium_statement ps:P115 ?stadium . # ?stadium now holds the actual Q value
  OPTIONAL {?stadium_statement pq:P580 ?inuse.} #... with start date qualifier
  OPTIONAL {?stadium_statement pq:P582 ?oou.} #... with end date qualifier
  OPTIONAL {?stadium wdt:P625 ?coord } # assuming you want the stadium coordinates
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}ORDER BY ASC(?clubLabel) DESC(?startyear)

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2021/11