query-1ff8c0f0231892b9ac1844ec1f2ec472

rq turtle/ttl

TODO

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 ?item ?itemLabel ?sportLabel ?twitter_username ?subscribers WHERE
{
   {
  SELECT ?item ?twitter_username ?subscribers ?sport
WHERE 
{

  ?item p:P2002 ?stat .                 # they have a twitter username property
  ?stat ps:P2002 ?twitter_username.     # with this value
  ?stat pq:P3744 ?subscribers.          # and this number of subscribers
  ?item wdt:P106 ?sport .               # they have an occuption
  ?sport wdt:P279 wd:Q2066131.          # the occupation is a subclass of athlete
  ?item wdt:P21 wd:Q6581097.            # they're male
  } 
  }  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
                                        # get labels only of qualifying items to save time.
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2020/10