query-342c722ebf00fc8534120bdca1a411ba

PREFIX mwapi: <http://wikiba.se/ontology#>
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 bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?item_number
WHERE
{
  SERVICE wikibase:mwapi
  {
    bd:serviceParam wikibase:api "Generator" .
    bd:serviceParam wikibase:endpoint "www.wikidata.org" .
    bd:serviceParam mwapi:generator "recentchanges" .
    bd:serviceParam mwapi:grctype "new" .
    bd:serviceParam mwapi:grcnamespace "0" .
    bd:serviceParam mwapi:grclimit "max" .
    ?item wikibase:apiOutputItem mwapi:title . 
  }
  ?item wdt:P31 wd:Q5 .
  BIND (xsd:integer(SUBSTR(STR(?item), 33)) AS ?item_number)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } 
}
ORDER BY DESC(?item_number)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item"):::projected v3("?item_number"):::projected c6(["www.wikidata.org"]):::literal c10(["new"]):::literal c14(["max"]):::literal c12(["0"]):::literal c2(["bd:serviceParam"]):::iri c18(["wd:Q5"]):::iri c21(["#91;AUTO_LANGUAGE#93;,en"]):::literal c16(["mwapi:title"]):::iri c8(["recentchanges"]):::literal c4(["Generator"]):::literal subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c2 --"mwapi:api"--> c4 c2 --"mwapi:endpoint"--> c6 c2 --"mwapi:generator"--> c8 c2 --"mwapi:grctype"--> c10 c2 --"mwapi:grcnamespace"--> c12 c2 --"mwapi:grclimit"--> c14 v2 --"mwapi:apiOutputItem"--> c16 end v2 --"wdt:P31"--> c18 bind0[/"http://www.w3.org/2001/XMLSchema#integer(substring(str(?item),'33^^xsd:integer'))"/] v2 --o bind0 bind0 --as--o v3 subgraph s2["http://wikiba.se/ontology#label"] style s2 stroke-width:4px; c2 --"mwapi:language"--> c21 end