query-87194d263ef7a0bb622165996ee39c0d
:title: Properties used on properties maintained by the WikiProject SELECT DISTINCT ?property ?propertyLabel ?count WITH { SELECT DISTINCT ?entity WHERE { ?entity wdt:P6104 wd:Q56241615 . } LIMIT 200000 } AS %items WITH { SELECT DISTINCT ?property (COUNT(*) AS ?count) WHERE { INCLUDE %items. ?entity ?p [ ] . ?property a wikibase:Property; wikibase:claim ?p. } GROUP BY ?property LIMIT 100 } AS %results WHERE { INCLUDE %results. SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?count) LIMIT 100
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 bd: <http://www.bigdata.com/rdf#>
#:title: Properties used on properties maintained by the WikiProject
SELECT DISTINCT ?property ?propertyLabel ?count
WHERE {
{
SELECT DISTINCT ?property (COUNT(*) AS ?count) WHERE {
{
SELECT DISTINCT ?entity WHERE {
?entity wdt:P6104 wd:Q56241615 .
}
LIMIT 200000
}
?entity ?p [ ] .
?property a wikibase:Property;
wikibase:claim ?p.
}
GROUP BY ?property
LIMIT 100
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?count)
LIMIT 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?count"):::projected
v2("?entity")
v3("?p")
v4("?property"):::projected
a1((" "))
c7(["bd:serviceParam"]):::iri
c2(["wd:Q56241615"]):::iri
c4(["wikibase:Property"]):::iri
c9(["en"]):::literal
v2 --"wdt:P6104"--> c2
v2 -->v3--> a1
v4 --"a"--> c4
v4 --"wikibase:claim"--> v3
bind1[/"count(*)"/]
bind1 --as--o v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end