query-cee6120733a9d8b32b867240fd09acb1

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 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 ?item ?itemLabel WHERE 
{
   { 
SELECT (MIN(?date_) as ?date) (MIN(?number_) AS ?number) WHERE
  { wd:Q38074555 p:P1114 ?stat . 
    ?stat ps:P1114 ?number_ .
    ?stat pq:P585 ?date_ .
    filter(?date_ >  "2021-09-31"^^xsd:dat)
  }
}  ?item wdt:P31 wd:Q7889.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } 
  filter(xsd:integer(strafter(str(?item),"Q")) > ?number ) 
} order by ?item

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?date") v3("?date_") v1("?item"):::projected v7("?number") v5("?number_") v4("?stat") c10(["bd:serviceParam"]):::iri c3(["wd:Q38074555"]):::iri c8(["wd:Q7889"]):::iri c12(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["http://www.w3.org/2001/XMLSchema#integer(substring-after(str(?item),'Q')) > ?number"]] f0 --> v1 f0 --> v7 f1[["?date_ > s2021-09-31^^<http://www.w3.org/2001/XMLSchema#dat>'"]] f1 --> v3 c3 --"p:P1114"--> v4 v4 --"p:statement/P1114"--> v5 v4 --"p:qualifier/P585"--> v3 bind4[/"min(?date_)"/] v3 --o bind4 bind4 --as--o v6 bind5[/"min(?number_)"/] v5 --o bind5 bind5 --as--o v7 v1 --"p:direct/P31"--> c8 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c10 --"wikibase:language"--> c12 end