query-7bc314bce56e665996e34ae5bbd54ed0
Unique qualifier combinations for copyrighted items combinations for public domain items. Unusual combinations might indicate errors. (P459)determination method or standard and (P1001)applies to jurisdiction , (P275)copyright license Inspect unique
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?jLabel ?dLabel ?lLabel ?num ?sampleitem where
{
{
SELECT distinct ?j ?d ?l (count(*) as ?num) (SAMPLE(?item) as ?sampleitem) where
{
?item p:P6216 ?statement .
?statement ps:P6216 wd:Q50423863 . # copyright status = copyrighted
optional { ?statement pq:P1001 ?j . }
optional { ?statement pq:P459 ?d . }
optional { ?statement pq:P275 ?l . }
} group by ?j ?d ?l} SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
order by desc(?num)
Limit 1000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?d")
v2("?item")
v4("?j")
v6("?l")
v7("?num"):::projected
v7("?sampleitem"):::projected
v3("?statement")
c8(["bd:serviceParam"]):::iri
c10(["en"]):::literal
c3(["wd:Q50423863"]):::iri
v2 --"p:P6216"--> v3
v3 --"p:statement/P6216"--> c3
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."p:qualifier/P1001".-> v4
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v3 -."p:qualifier/P459".-> v5
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v3 -."p:qualifier/P275".-> v6
end
bind2[/"count(*)"/]
bind2 --as--o v7
bind3[/"sample(?item)"/]
v2 --o bind3
bind3 --as--o v7
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end