query-3035ff80c87d2d79348f31ffba350b0d

rq turtle/ttl

TODO

Use at

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 bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?count ?report
{

{
  SELECT ?item (SAMPLE(?p) AS ?paper) (count(?p) as ?count)
  {

{ 
  SELECT ?item
  {
    ?item wdt:P31 wd:Q5633421
    FILTER STRENDS(STR(?item), "0")
  }
}    ?p wdt:P1433 ?item
  }
  GROUP BY ?item
}  FILTER NOT EXISTS {?paper schema:description ?d filter(lang(?d)="en") }
  BIND(IRI(CONCAT("https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3FpubInLabel%20%3Fmonth%20%3Fyear%20%3Fvolume%20%3Fnumber%20%3Fprecision%20WHERE%20%7B%0A%20%20values%20%3FpubIn%20%7Bwd%3A",STRAFTER(str(?item),"entity/"),"%7D%0A%20%20%3Fitem%20wdt%3AP1433%20%3FpubIn.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%7D%0A%20%20filter%20not%20exists%20%7B%3Fitem%20schema%3Adescription%20%3Ft%20.%20filter%28lang%28%3Ft%29%3D%22en%22%29%7D%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP478%20%3Fvolume.%7D%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP433%20%3Fnumber.%7D%0A%20%20%3Fitem%20p%3AP577%20%3Fstat%20.%20%0A%20%20%0A%20%20%0A%20%20%3Fstat%20psv%3AP577%2Fwikibase%3AtimePrecision%20%3Fprecision%20.%0A%20%20%3Fstat%20ps%3AP577%20%3Fpub.%0A%20%20BIND%28YEAR%28%3Fpub%29%20as%20%3Fyear%29%0A%20%20BIND%28MONTH%28%3Fpub%29%20as%20%3Fmonth_%29%0A%20%20BIND%28IF%28%3Fmonth_%3D1%2C%22January%22%2C%0A%20%20IF%28%3Fmonth_%3D2%2C%22February%22%2C%0A%20%20IF%28%3Fmonth_%3D3%2C%22March%22%2C%0A%20%20IF%28%3Fmonth_%3D4%2C%22April%22%2C%0A%20%20IF%28%3Fmonth_%3D5%2C%22May%22%2C%0A%20%20IF%28%3Fmonth_%3D6%2C%22June%22%2C%0A%20%20IF%28%3Fmonth_%3D7%2C%22July%22%2C%20%20%20%20%20%0A%20%20IF%28%3Fmonth_%3D8%2C%22August%22%2C%0A%20%20IF%28%3Fmonth_%3D9%2C%22September%22%2C%0A%20%20IF%28%3Fmonth_%3D10%2C%22October%22%2C%0A%20%20IF%28%3Fmonth_%3D11%2C%22November%22%2C%22December%22%29%29%29%29%29%29%29%29%29%29%29%20as%20%3Fmonth%29%0A%20%0A%7D")) as ?report)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } 
} ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?count"):::projected v2("?d") v4("?item"):::projected v5("?p") v6("?paper") v6("?report"):::projected c8(["bd:serviceParam"]):::iri c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal c5(["wd:Q5633421"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0f0[["?d = 'en'"]] e0f0 --> e0v1 e0v2 --"schema:description"--> e0v1 e0v1("?d"):::projected e0v2("?paper"):::projected end f0--EXISTS--> f0e0 f0 --> v2 f0 --> v6 f0 --> c2 f1[["?d = 'en'"]] f1 --> v2 v6 --"schema:description"--> v2 f2[["ends-with(str(?item),'0')"]] f2 --> v4 v4 --"wdt:P31"--> c5 v5 --"wdt:P1433"--> v4 bind5[/"sample(?p)"/] v5 --o bind5 bind5 --as--o v6 bind6[/"count(?p)"/] v5 --o bind6 bind6 --as--o v6 bind7[/"concat('https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3FpubInLabel%20%3Fmonth%20%3Fyear%20%3Fvolume%20%3Fnumber%20%3Fprecision%20WHERE%20%7B%0A%20%20values%20%3FpubIn%20%7Bwd%3A',substring-after(str(?item),'entity/'),'%7D%0A%20%20%3Fitem%20wdt%3AP1433%20%3FpubIn.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%7D%0A%20%20filter%20not%20exists%20%7B%3Fitem%20schema%3Adescription%20%3Ft%20.%20filter%28lang%28%3Ft%29%3D%22en%22%29%7D%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP478%20%3Fvolume.%7D%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP433%20%3Fnumber.%7D%0A%20%20%3Fitem%20p%3AP577%20%3Fstat%20.%20%0A%20%20%0A%20%20%0A%20%20%3Fstat%20psv%3AP577%2Fwikibase%3AtimePrecision%20%3Fprecision%20.%0A%20%20%3Fstat%20ps%3AP577%20%3Fpub.%0A%20%20BIND%28YEAR%28%3Fpub%29%20as%20%3Fyear%29%0A%20%20BIND%28MONTH%28%3Fpub%29%20as%20%3Fmonth_%29%0A%20%20BIND%28IF%28%3Fmonth_%3D1%2C%22January%22%2C%0A%20%20IF%28%3Fmonth_%3D2%2C%22February%22%2C%0A%20%20IF%28%3Fmonth_%3D3%2C%22March%22%2C%0A%20%20IF%28%3Fmonth_%3D4%2C%22April%22%2C%0A%20%20IF%28%3Fmonth_%3D5%2C%22May%22%2C%0A%20%20IF%28%3Fmonth_%3D6%2C%22June%22%2C%0A%20%20IF%28%3Fmonth_%3D7%2C%22July%22%2C%20%20%20%20%20%0A%20%20IF%28%3Fmonth_%3D8%2C%22August%22%2C%0A%20%20IF%28%3Fmonth_%3D9%2C%22September%22%2C%0A%20%20IF%28%3Fmonth_%3D10%2C%22October%22%2C%0A%20%20IF%28%3Fmonth_%3D11%2C%22November%22%2C%22December%22%29%29%29%29%29%29%29%29%29%29%29%20as%20%3Fmonth%29%0A%20%0A%7D')"/] v4 --o bind7 bind7 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end