query-8ff00acc161d62a26d8891129c9586ec
title: Works that have (a) been published in invasion biology venues but (b) not been tagged as being in scope of WikiProject Invasion Biology SELECT DISTINCT ?item ?title (REPLACE(STR(?item), ".*Q", "Q") AS ?qid) ("P6104" AS ?property) ("Q56241615" AS ?ReplaceWithYourTargetID) ("S887" AS ?heuristic) ("Q124004081" AS ?deduced)
WHERE { hint:Query hint:optimizer "None".
?venue wdt:P6104 wd:Q56241615. ?venue wdt:P236 []. ?item wdt:P1433 ?venue.
FILTER NOT EXISTS { ?item wdt:P6104 wd:Q56241615. }
?item wdt:P1476 ?title_. ?venue wdt:P1476 ?venue_title. ?venue wdt:P6104 wd:Q56241615. BIND(CONCAT(?title_ , " | " , ?venue_title) AS ?title)
}
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#title: Works that have (a) been published in invasion biology venues but (b) not been tagged as being in scope of WikiProject Invasion Biology
SELECT
DISTINCT
?item ?title
(REPLACE(STR(?item), ".*Q", "Q") AS ?qid)
("P6104" AS ?property)
("Q56241615" AS ?ReplaceWithYourTargetID)
("S887" AS ?heuristic)
("Q124004081" AS ?deduced)
WHERE {
?venue wdt:P6104 wd:Q56241615.
?venue wdt:P236 [].
?item wdt:P1433 ?venue.
FILTER NOT EXISTS { ?item wdt:P6104 wd:Q56241615. }
?item wdt:P1476 ?title_.
?venue wdt:P1476 ?venue_title.
?venue wdt:P6104 wd:Q56241615.
BIND(CONCAT(?title_ , " | " , ?venue_title) AS ?title)
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v8("?ReplaceWithYourTargetID")
v10("?deduced")
v9("?heuristic")
v1("?item"):::projected
v7("?property")
v6("?qid")
v5("?title"):::projected
v3("?title_")
v2("?venue")
v4("?venue_title")
a1((" "))
c2(["wd:Q56241615"]):::iri
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"wdt:P6104"--> e0c2
e0v1("?item"):::projected
e0c2(["wd:Q56241615"]):::iri
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> c1
f0 --> c2
v1 --"wdt:P6104"--> c2
v2 --"wdt:P6104"--> c2
v2 --"wdt:P236"--> a1
v1 --"wdt:P1433"--> v2
v1 --"wdt:P1476"--> v3
v2 --"wdt:P1476"--> v4
v2 --"wdt:P6104"--> c2
bind1[/"concat(?title_,' | ',?venue_title)"/]
v3 --o bind1
v4 --o bind1
bind1 --as--o v5
bind2[/"replace(str(?item),'.*Q','Q')"/]
v1 --o bind2
bind2 --as--o v6
bind3[/"'P6104'"/]
bind3 --as--o v7
bind4[/"'Q56241615'"/]
bind4 --as--o v8
bind5[/"'S887'"/]
bind5 --as--o v9
bind6[/"'Q124004081'"/]
bind6 --as--o v10