query-dace113b700a302ab98c18b147c2edb4
Values used by property P3279 SELECT ?value ?unity ?unityLabel ?ct ?sampleitem ?sampleitemLabel WHERE { { SELECT ?value ?unity (count() as ?ct) (SAMPLE(?item) as ?sampleitem) WHERE { ?item wdt:P31/wdt:P279 wd:Q16510064. ?item (p:P2257/psv:P2257) :b5. :b5 wikibase:quantityAmount ?value; wikibase:quantityUnit ?unity. } GROUP BY ?value ?unity ORDER BY DESC(?ct) LIMIT 1000 } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } } ORDER BY DESC(?ct) ASC(?value)
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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Values used by property P3279
SELECT ?value ?unity ?unityLabel ?ct ?sampleitem ?sampleitemLabel
WHERE
{
{
SELECT ?value ?unity (count(*) as ?ct) (SAMPLE(?item) as ?sampleitem)
WHERE
{
?item wdt:P31/wdt:P279* wd:Q16510064.
?item (p:P2257/psv:P2257) _:b5.
_:b5 wikibase:quantityAmount ?value;
wikibase:quantityUnit ?unity.
}
GROUP BY ?value ?unity
ORDER BY DESC(?ct)
LIMIT 1000
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
ORDER BY DESC(?ct) ASC(?value)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?ct"):::projected
v3("?item")
v5("?sampleitem"):::projected
v4("?unity"):::projected
v2("?value"):::projected
a3((" "))
a1((" "))
a2((" "))
c9(["bd:serviceParam"]):::iri
c11(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c3(["wd:Q16510064"]):::iri
v3 --"p:direct/P31"--> a1
a1 --"p:direct/P279"--> c3
v3 --"p:P2257"--> a2
a2 --"p:statement/value/P2257"--> a3
a3 --"wikibase:quantityAmount"--> v2
a3 --"wikibase:quantityUnit"--> v4
bind2[/"count(*)"/]
bind2 --as--o v5
bind3[/"sample(?item)"/]
v3 --o bind3
bind3 --as--o v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
end