query-61fafe1c030dd9f6ab22cf72b56cd3bf

rq turtle/ttl

title: Invasion biology items with Scholia template on the English Wikipedia

SELECT DISTINCT ?item ?itemLabel WHERE { ?item wdt:P6104 wd:Q56241615.

{
SELECT ?item ?pageid ?ns WHERE { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "en.wikipedia.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "search" . bd:serviceParam mwapi:gsrsearch "hastemplate:Scholia" . bd:serviceParam mwapi:gsrlimit "max" . ?item wikibase:apiOutputItem mwapi:item . ?pageid wikibase:apiOutput "@pageid" . ?ns wikibase:apiOutput "@ns" . } } LIMIT 10000 } ?item ^wdt:P921 ?work . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }

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 bd: <http://www.bigdata.com/rdf#>
#title: Invasion biology items with Scholia template on the English Wikipedia

SELECT 
  DISTINCT ?item ?itemLabel
WHERE {
  ?item wdt:P6104 wd:Q56241615.

  {   
   SELECT ?item ?pageid 
                ?ns WHERE {
    SERVICE wikibase:mwapi {
      bd:serviceParam wikibase:endpoint "en.wikipedia.org" .
      bd:serviceParam wikibase:api "Generator" .
      bd:serviceParam mwapi:generator "search" .
      bd:serviceParam mwapi:gsrsearch "hastemplate:Scholia" .
      bd:serviceParam mwapi:gsrlimit "max" .
      ?item wikibase:apiOutputItem mwapi:item .
      ?pageid wikibase:apiOutput "@pageid" .
      ?ns wikibase:apiOutput "@ns" .
    }
  } LIMIT 10000
 }
  ?item ^wdt:P921 ?work .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?item"):::projected v3("?ns") v2("?pageid") v4("?work") c16(["mwapi:item"]):::iri c2(["wd:Q56241615"]):::iri c14(["max"]):::literal c19(["@ns"]):::literal c6(["en.wikipedia.org"]):::literal c10(["search"]):::literal c4(["bd:serviceParam"]):::iri c12(["hastemplate:Scholia"]):::literal c23(["#91;AUTO_LANGUAGE#93;,en"]):::literal c18(["@pageid"]):::literal c8(["Generator"]):::literal v1 --"wdt:P6104"--> c2 subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c4 --"mwapi:endpoint"--> c6 c4 --"mwapi:api"--> c8 c4 --"mwapi:generator"--> c10 c4 --"mwapi:gsrsearch"--> c12 c4 --"mwapi:gsrlimit"--> c14 v1 --"mwapi:apiOutputItem"--> c16 v2 --"mwapi:apiOutput"--> c18 v3 --"mwapi:apiOutput"--> c19 end v4 --"wdt:P921"--> v1 subgraph s2["http://wikiba.se/ontology#label"] style s2 stroke-width:4px; c4 --"mwapi:language"--> c23 end