query-b61e030b2b6382287d953a8dddfb96f1

rq turtle/ttl

Propertiesmaintained by WikiProject (P6104)title (P1476)main subject (P921)taxon name (P225)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT DISTINCT 
?item ?title ?taxon ?taxon_name
  (REPLACE(STR(?item), ".*Q", "Q") AS ?qid) 
  ("P921" AS ?property)
  ("Q183368" AS ?ReplaceWithYourTargetID)
  ("S887" AS ?heuristic)
  ("Q69652283" AS ?deduced)
WHERE { 
  ?item wdt:P6104 wd:Q56241615 ;
        wdt:P1476 ?title ;
        wdt:P921 ?taxon . 
  FILTER NOT EXISTS { ?item wdt:P921 wd:Q183368 }
  ?taxon wdt:P225 ?taxon_name .
  FILTER REGEX(LCASE(?title), "\\b(invasive|non-native|invasion|exotic|alien\\b|introduced)").
}
GROUP BY ?item ?title ?taxon ?taxon_name
LIMIT 200

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?ReplaceWithYourTargetID") v9("?deduced") v8("?heuristic") v2("?item"):::projected v6("?property") v5("?qid") v3("?taxon"):::projected v4("?taxon_name"):::projected v1("?title"):::projected c5(["wd:Q56241615"]):::iri c3(["wd:Q183368"]):::iri f0[["regex(lower-case(?title),'\b(invasive|non-native|invasion|exotic|alien\b|introduced)')"]] f0 --> v1 f1[["not "]] subgraph f1e0["Exists Clause"] e0v1 --"wdt:P921"--> e0c2 e0v1("?item"):::projected e0c2(["wd:Q183368"]):::iri end f1--EXISTS--> f1e0 f1 --> v2 f1 --> c2 f1 --> c3 v2 --"wdt:P921"--> c3 v2 --"wdt:P6104"--> c5 v2 --"wdt:P1476"--> v1 v2 --"wdt:P921"--> v3 v3 --"wdt:P225"--> v4 bind2[/"replace(str(?item),'.*Q','Q')"/] v2 --o bind2 bind2 --as--o v5 bind3[/"'P921'"/] bind3 --as--o v6 bind4[/"'Q183368'"/] bind4 --as--o v7 bind5[/"'S887'"/] bind5 --as--o v8 bind6[/"'Q69652283'"/] bind6 --as--o v9