query-eff5e32a64a3870494a639ddc8834215

rq turtle/ttl

title: Taxa not tagged as being within scope of this WikiProject but that co-occur with invasion biology in papers

SELECT DISTINCT ?topic ?taxonname (COUNT(?paper) AS ?count)

(REPLACE(STR(?topic), ".*Q", "Q") AS ?qid) ("P6104" AS ?property) ("Q56241615" AS ?ReplaceWithYourTargetID)

WHERE { ?paper wdt:P6104 wd:Q56241615 ; wdt:P921 ?topic . ?topic wdt:P225 ?taxonname ; wdt:P105 wd:Q7432 .

MINUS {?topic wdt:P6104 wd:Q56241615 .}

} GROUP BY ?topic ?taxonname ?count ?qid ?property ?ReplaceWithYourTargetID ORDER BY DESC(?count)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#title: Taxa not tagged as being within scope of this WikiProject but that co-occur with invasion biology in papers

SELECT 
  DISTINCT 
  ?topic ?taxonname (COUNT(?paper) AS ?count)

  (REPLACE(STR(?topic), ".*Q", "Q") AS ?qid) 
  ("P6104" AS ?property)
  ("Q56241615" AS ?ReplaceWithYourTargetID)

WHERE {
  ?paper wdt:P6104 wd:Q56241615 ;
         wdt:P921 ?topic .
  ?topic wdt:P225 ?taxonname ;
         wdt:P105 wd:Q7432 .

  MINUS {?topic wdt:P6104 wd:Q56241615 .}

}
GROUP BY ?topic ?taxonname ?count ?qid ?property ?ReplaceWithYourTargetID
ORDER BY DESC(?count)

Query found at