query-e8b9092f2f46ff57d080bbe793d7572f
Pmt
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
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/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?count ?property ?propertyLabel ?value ?valueLabel
WHERE {
{
SELECT * WHERE {
{
SELECT ?reference (COUNT(*) AS ?count) WHERE {
?entity p:P569 ?statement.
?statement prov:wasDerivedFrom ?reference.
}
GROUP BY ?reference
ORDER BY DESC(?count)
LIMIT 100
}
MINUS { ?reference pr:P143/wdt:P31 wd:Q10876391. }
}
ORDER BY DESC(?count)
LIMIT 10
}
?reference ?pr ?value.
?property wikibase:reference ?pr.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?count) ASC(?propertyLabel)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?count"):::projected
v3("?entity")
v6("?pr")
v8("?property"):::projected
v2("?propertyLabel"):::projected
v5("?reference")
v4("?statement")
v7("?value"):::projected
a1((" "))
c8(["bd:serviceParam"]):::iri
c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c5(["wd:Q10876391"]):::iri
v3 --"p:P569"--> v4
v4 --"prov:wasDerivedFrom"--> v5
bind1[/"count(*)"/]
bind1 --as--o v6
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v5 --"p:reference/P143"--> a1
a1 --"p:direct/P31"--> c5
end
v5 -->v6--> v7
v8 --"wikibase:reference"--> v6
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end