query-fd36cbd33c9db650571607e7e2289c50

rq turtle/ttl

author:Azertus

date:2021-09-07

title: Articles missing an item for their subject (CRAN R packages)

SELECT ?item ?itemLabel ?rPackage ?rPackageLabel WHERE { { SELECT * WHERE { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org"; wikibase:api "Search"; mwapi:srsearch 'haswbstatement:P31=Q13442814 inlabel:R@en inlabel:package@en'; mwapi:language "en". ?title wikibase:apiOutput mwapi:title. } BIND(URI(CONCAT('http://www.wikidata.org/entity/', ?title)) AS ?item) } LIMIT 5000 }

MINUS { ?item wdt:P921 ?rPackage . ?rPackage wdt:P31/wd:P279* wd:Q73539779 . }

SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?itemLabel . ?rPackage rdfs:label ?rPackageLabel . } } limit 10 author:Azertus

date:2021-09-07

title: Articles missing an item for their subject (CRAN R packages)

SELECT ?item ?itemLabel ?rPackage ?rPackageLabel WHERE { { SELECT * WHERE { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org"; wikibase:api "Search"; mwapi:srsearch 'haswbstatement:P31=Q13442814 inlabel:R@en inlabel:package@en'; mwapi:language "en". ?title wikibase:apiOutput mwapi:title. } BIND(URI(CONCAT('http://www.wikidata.org/entity/', ?title)) AS ?item) } LIMIT 5000 }

MINUS { ?item wdt:P921 ?rPackage . ?rPackage wdt:P31/wd:P279* wd:Q73539779 . }

SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?itemLabel . ?rPackage rdfs:label ?rPackageLabel . } } limit 10 author:Azertus

date:2021-09-07

title: Articles missing an item for their subject (CRAN R packages)

SELECT ?item ?itemLabel ?rPackage ?rPackageLabel WHERE { { SELECT * WHERE { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org"; wikibase:api "Search"; mwapi:srsearch 'haswbstatement:P31=Q13442814 inlabel:R@en inlabel:package@en'; mwapi:language "en". ?title wikibase:apiOutput mwapi:title. } BIND(URI(CONCAT('http://www.wikidata.org/entity/', ?title)) AS ?item) } LIMIT 5000 }

MINUS { ?item wdt:P921 ?rPackage . ?rPackage wdt:P31/wd:P279* wd:Q73539779 . }

SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?itemLabel . ?rPackage rdfs:label ?rPackageLabel . } } limit 10 author:Azertus

date:2021-09-07

title: Articles missing an item for their subject (CRAN R packages)

SELECT ?item ?itemLabel ?rPackage ?rPackageLabel WHERE { { SELECT * WHERE { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org"; wikibase:api "Search"; mwapi:srsearch 'haswbstatement:P31=Q13442814 inlabel:R@en inlabel:package@en'; mwapi:language "en". ?title wikibase:apiOutput mwapi:title. } BIND(URI(CONCAT('http://www.wikidata.org/entity/', ?title)) AS ?item) } LIMIT 5000 }

MINUS { ?item wdt:P921 ?rPackage . ?rPackage wdt:P31/wd:P279* wd:Q73539779 . }

SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?itemLabel . ?rPackage rdfs:label ?rPackageLabel . } } limit 10 author:Azertus

date:2021-09-07

title: Articles missing an item for their subject (CRAN R packages)

SELECT ?item ?itemLabel ?rPackage ?rPackageLabel WHERE { { SELECT * WHERE { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org"; wikibase:api "Search"; mwapi:srsearch 'haswbstatement:P31=Q13442814 inlabel:R@en inlabel:package@en'; mwapi:language "en". ?title wikibase:apiOutput mwapi:title. } BIND(URI(CONCAT('http://www.wikidata.org/entity/', ?title)) AS ?item) } LIMIT 5000 }

MINUS { ?item wdt:P921 ?rPackage . ?rPackage wdt:P31/wd:P279* wd:Q73539779 . }

SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?itemLabel . ?rPackage rdfs:label ?rPackageLabel . } } limit 10 author:Azertus

date:2021-09-07

title: Articles missing an item for their subject (CRAN R packages)

SELECT ?item ?itemLabel ?rPackage ?rPackageLabel WHERE { { SELECT * WHERE { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org"; wikibase:api "Search"; mwapi:srsearch 'haswbstatement:P31=Q13442814 inlabel:R@en inlabel:package@en'; mwapi:language "en". ?title wikibase:apiOutput mwapi:title. } BIND(URI(CONCAT('http://www.wikidata.org/entity/', ?title)) AS ?item) } LIMIT 5000 }

MINUS { ?item wdt:P921 ?rPackage . ?rPackage wdt:P31/wd:P279* wd:Q73539779 . }

SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?itemLabel . ?rPackage rdfs:label ?rPackageLabel . } } limit 10 author:Azertus

date:2021-09-07

title: Articles missing an item for their subject (CRAN R packages)

SELECT ?item ?itemLabel ?rPackage ?rPackageLabel WHERE { { SELECT * WHERE { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org"; wikibase:api "Search"; mwapi:srsearch 'haswbstatement:P31=Q13442814 inlabel:R@en inlabel:package@en'; mwapi:language "en". ?title wikibase:apiOutput mwapi:title. } BIND(URI(CONCAT('http://www.wikidata.org/entity/', ?title)) AS ?item) } LIMIT 5000 }

MINUS { ?item wdt:P921 ?rPackage . ?rPackage wdt:P31/wd:P279* wd:Q73539779 . }

SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?itemLabel . ?rPackage rdfs:label ?rPackageLabel . } } limit 10 author:Azertus

date:2021-09-07

title: Articles missing an item for their subject (CRAN R packages)

SELECT ?item ?itemLabel ?rPackage ?rPackageLabel WHERE { { SELECT * WHERE { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org"; wikibase:api "Search"; mwapi:srsearch 'haswbstatement:P31=Q13442814 inlabel:R@en inlabel:package@en'; mwapi:language "en". ?title wikibase:apiOutput mwapi:title. } BIND(URI(CONCAT('http://www.wikidata.org/entity/', ?title)) AS ?item) } LIMIT 5000 }

MINUS { ?item wdt:P921 ?rPackage . ?rPackage wdt:P31/wd:P279* wd:Q73539779 . }

SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?itemLabel . ?rPackage rdfs:label ?rPackageLabel . } } limit 10 author:Azertus

date:2021-09-07

title: Articles missing an item for their subject (CRAN R packages)

SELECT ?item ?itemLabel ?rPackage ?rPackageLabel WHERE { { SELECT * WHERE { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org"; wikibase:api "Search"; mwapi:srsearch 'haswbstatement:P31=Q13442814 inlabel:R@en inlabel:package@en'; mwapi:language "en". ?title wikibase:apiOutput mwapi:title. } BIND(URI(CONCAT('http://www.wikidata.org/entity/', ?title)) AS ?item) } LIMIT 5000 }

MINUS { ?item wdt:P921 ?rPackage . ?rPackage wdt:P31/wd:P279* wd:Q73539779 . }

SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?itemLabel . ?rPackage rdfs:label ?rPackageLabel . } } limit 10

Use at

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#author:Azertus
#date:2021-09-07
#title: Articles missing an item for their subject (CRAN R packages)
SELECT ?item ?itemLabel ?rPackage ?rPackageLabel WHERE {
    { SELECT * WHERE {
      SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:endpoint "www.wikidata.org";
                        wikibase:api "Search";
                        mwapi:srsearch 'haswbstatement:P31=Q13442814 inlabel:R@en inlabel:package@en';
                        mwapi:language "en".
        ?title wikibase:apiOutput mwapi:title. 
      }
      BIND(URI(CONCAT('http://www.wikidata.org/entity/', ?title)) AS ?item)
    } LIMIT 5000 }

  MINUS {
    ?item wdt:P921 ?rPackage .
    ?rPackage wdt:P31/wd:P279* wd:Q73539779 .
  }

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
    ?item rdfs:label ?itemLabel .
    ?rPackage rdfs:label ?rPackageLabel .
  }
}
limit 10

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item"):::projected v4("?itemLabel"):::projected v3("?rPackage"):::projected v5("?rPackageLabel"):::projected v1("?title") a1((" ")) c4(["www.wikidata.org"]):::literal c10(["en"]):::literal c8(["haswbstatement:P31=Q13442814 inlabel:R@en inlabel:package@en"]):::literal c2(["bd:serviceParam"]):::iri c16(["wd:Q73539779"]):::iri c6(["Search"]):::literal c12(["mwapi:title"]):::iri subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c2 --"mwapi:endpoint"--> c4 c2 --"mwapi:api"--> c6 c2 --"mwapi:srsearch"--> c8 c2 --"mwapi:language"--> c10 v1 --"mwapi:apiOutput"--> c12 end bind0[/"concat('http://www.wikidata.org/entity/',?title)"/] v1 --o bind0 bind0 --as--o v2 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v2 --"wdt:P921"--> v3 v3 --"wdt:P31"--> a1 a1 --"wd:P279"--> c16 end subgraph s2["http://wikiba.se/ontology#label"] style s2 stroke-width:4px; c2 --"mwapi:language"--> c10 v2 --"rdfs:label"--> v4 v3 --"rdfs:label"--> v5 end