query-a6b73e017059219f36162ff610cc4d2e
title: Properties to identify online accounts by their use of "has quality"->"inactive" SELECT ?prop ?propLabel (COUNT(?statement) AS ?inactive_count) WHERE { ?prop wdt:P31 wd:Q105388954 ; wikibase:claim ?wdtClaimPredicate .
?item ?wdtClaimPredicate ?statement . ?statement pq:P1552 wd:Q29415492 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?prop ?propLabel ORDER BY DESC(?inactive_count)
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 pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Properties to identify online accounts by their use of "has quality"->"inactive"
SELECT ?prop ?propLabel (COUNT(?statement) AS ?inactive_count) WHERE {
?prop wdt:P31 wd:Q105388954 ;
wikibase:claim ?wdtClaimPredicate .
?item ?wdtClaimPredicate ?statement .
?statement pq:P1552 wd:Q29415492 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?prop ?propLabel
ORDER BY DESC(?inactive_count)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?inactive_count")
v4("?item")
v2("?prop"):::projected
v5("?statement"):::projected
v3("?wdtClaimPredicate")
c2(["wd:Q105388954"]):::iri
c7(["bd:serviceParam"]):::iri
c5(["wd:Q29415492"]):::iri
c9(["#91;AUTO_LANGUAGE#93;,en"]):::literal
v2 --"wdt:P31"--> c2
v2 --"wikibase:claim"--> v3
v4 -->v3--> v5
v5 --"pq:P1552"--> c5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end
bind1[/"count(?statement)"/]
v5 --o bind1
bind1 --as--o v6