query-7a77258f7b8f67f96b22baa95816afa6

rq turtle/ttl

TODO

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?date ?coords ?article (GROUP_CONCAT(?P31Label;separator="; ") as ?type)
WHERE 
{
  ?item wdt:P571 ?date . 
  ?article schema:about ?item ;
  schema:isPartOf <https://en.wikipedia.org/>.
  ?item wdt:P17 wd:Q30 .
  ?item wdt:P625 ?coords .
  filter(?date  > "2022-12-31"^^xsd:date && ?date  < "2024-00-00"^^xsd:dat)  
  OPTIONAL {?item wdt:P31/rdfs:label ?P31Label. filter(lang(?P31Label)="en")}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} group by ?item ?itemLabel ?date ?coords ?article order by ?itemLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?P31Label"):::projected v5("?article"):::projected v6("?coords"):::projected v2("?date"):::projected v4("?item"):::projected v1("?itemLabel"):::projected v7("?type") a1((" ")) c9(["wd:Q30"]):::iri c7([https://en.wikipedia.org/]):::iri c14(["bd:serviceParam"]):::iri c16(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["?date > '2022-12-31^^xsd:date'?date < s2024-00-00^^<http://www.w3.org/2001/XMLSchema#dat>'"]] f0 --> v2 v4 --"wdt:P571"--> v2 v5 --"schema:about"--> v4 v5 --"schema:isPartOf"--> c7 v4 --"wdt:P17"--> c9 v4 --"wdt:P625"--> v6 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P31".-> a1 a1 --"rdfs:label"--> v3 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c14 --"wikibase:language"--> c16 end bind2[/"?P31Label"/] v3 --o bind2 bind2 --as--o v7