query-1cc0808f6fa2b6772a222fb387cbdbb1
PropertiesInvasive Species Compendium Datasheet ID (P5698)Global Invasive Species Database ID (P5626)instance of (P31)author (P50)title (P1476)main subject (P921)sex or gender (P21)ORCID iD (P496)cites work (P2860)stated in (P248)
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
SELECT DISTINCT ?item ?title (COUNT(DISTINCT ?statement) AS ?count)
WHERE {
{?topic wdt:P5698 [].} UNION {?topic wdt:P5626 [].}
?topic wdt:P31 wd:Q16521 .
?item wdt:P50 ?author;
wdt:P1476 ?title ;
wdt:P921 ?topic .
?statement prov:wasDerivedFrom/pr:P248 ?item .
?author wdt:P21 wd:Q6581072 ;
wdt:P496 ?orcid .
[] wdt:P2860 ?item .
}
GROUP BY ?item ?title
ORDER BY DESC(?count)
LIMIT 200
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?author")
v8("?count")
v3("?item"):::projected
v7("?orcid")
v6("?statement"):::projected
v5("?title"):::projected
v2("?topic")
a1((" "))
a2((" "))
a4((" "))
a3((" "))
c11(["wd:Q6581072"]):::iri
c4(["wd:Q16521"]):::iri
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
v2 --"wdt:P5626"--> a2
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v2 --"wdt:P5698"--> a1
end
union0r <== or ==> union0l
end
v2 --"wdt:P31"--> c4
v3 --"wdt:P50"--> v4
v3 --"wdt:P1476"--> v5
v3 --"wdt:P921"--> v2
v6 --"prov:wasDerivedFrom"--> a3
a3 --"pr:P248"--> v3
v4 --"wdt:P21"--> c11
v4 --"wdt:P496"--> v7
a4 --"wdt:P2860"--> v3
bind1[/"count(?statement)"/]
v6 --o bind1
bind1 --as--o v8