query-d2d5999e034ddbc3607e27a9fe3bae2a

rq turtle/ttl

Users with more than 5 million followers in 2024

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT
  ?value ?user (URI(REPLACE(?f,"\\$1",?user)) as ?url) ?d 
  ?item ?itemLabel ?itemDescription
WHERE
{

{
    SELECT ?st ?value ?d 
    WHERE
    {
        ?st ps:P8687 ?value .
        FILTER ( ?value > 5000000 )   
        ?st pq:P585 ?d .
        FILTER ( YEAR(?d) = 2021 )   
     }
}  ?st pq:P6552 ?id .  
  ?item p:P8687 ?st .   
  ?item p:P2002 [ ps:P2002 ?user ; pq:P6552 ?id ] .  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  wd:P2002 wdt:P1630 ?f . 
}
ORDER BY DESC(?value)

Query found at

• https://www.wikidata.org/wiki/Property_talk:P2002