query-093218cfa4eee140ab19488fd390378e
People on Twitter SELECT DISTINCT ?item ?handle { ?item wdt:P31 wd:Q5. ?item p:P2002 ?handleStatement. ?handleStatement ps:P2002 ?handle. # But not those which ended already MINUS { ?handleStatement pq:P582 ?endtime } . ?item wdt:P8687 ?followers. } ORDER BY DESC(?followers) LIMIT 1000
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
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/>
# People on Twitter
SELECT DISTINCT ?item ?handle
{
?item wdt:P31 wd:Q5.
?item p:P2002 ?handleStatement.
?handleStatement ps:P2002 ?handle.
# But not those which ended already
MINUS { ?handleStatement pq:P582 ?endtime } .
?item wdt:P8687 ?followers.
}
ORDER BY DESC(?followers)
LIMIT 1000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?endtime")
v1("?followers")
v4("?handle"):::projected
v3("?handleStatement")
v2("?item"):::projected
c2(["wd:Q5"]):::iri
v2 --"p:direct/P31"--> c2
v2 --"p:P2002"--> v3
v3 --"p:statement/P2002"--> v4
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v3 --"p:qualifier/P582"--> v5
end
v2 --"p:direct/P8687"--> v1