query-895849e3ee84cb6f8282c293bb3b5389
Unique qualifier combinations for public domain items pair combinations for public domain items. Unusual combinations might indicate errors. (P459)determination method or standard and (P1001)applies to jurisdiction 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 ?num ?sampleitem where
{
{
SELECT distinct ?j ?d (count(*) as ?num) (SAMPLE(?item) as ?sampleitem) where
{
?item p:P6216 ?statement .
?statement ps:P6216 ?pd . # copyright status = public domain
?statement pq:P1001 ?j .
?statement pq:P459 ?d .
VALUES ?pd { wd:Q19652 wd:Q15687061 }
} group by ?j ?d } 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;
v6("?d")
v2("?item")
v5("?j")
v7("?num"):::projected
v7("?pd")
v7("?sampleitem"):::projected
v3("?statement")
c6(["bd:serviceParam"]):::iri
c8(["en"]):::literal
v2 --"p:P6216"--> v3
v3 --"p:statement/P6216"--> v7
v3 --"p:qualifier/P1001"--> v5
v3 --"p:qualifier/P459"--> v6
bind0[/VALUES ?pd/]
bind0-->v7
bind00(["wd:Q19652"])
bind00 --> bind0
bind01(["wd:Q15687061"])
bind01 --> bind0
bind3[/"count(*)"/]
bind3 --as--o v7
bind4[/"sample(?item)"/]
v2 --o bind4
bind4 --as--o v7
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c6 --"wikibase:language"--> c8
end