query-c12fd9a3c7b7ec4566d319c4c3529f40

rq turtle/ttl

Propertiescopyright status (P6216)applies to jurisdiction (P1001)determination method or standard (P459)

Use at

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 100

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