query-6d8a0733451c435c2937cd2b9436b684

rq turtle/ttl

. I think the top results can all be fairly called politicians, at least.(P39)position held . For a very loose interpretation of “politician”: anybody with a on Mastodon and on TwitterOriginally posted

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 ?actor ?actorLabel ?characterLabel ?count WHERE {
   {
  SELECT ?actor ?character (COUNT(DISTINCT ?film) AS ?count) WHERE {
    ?film wdt:P31/wdt:P279* wd:Q11424;
          p:P161 [
            ps:P161 ?actor;
            pq:P453 ?character
          ].
    FILTER(?actor != ?character)
    ?character wdt:P31 wd:Q5;
               wdt:P39 ?position.
  }
  GROUP BY ?actor ?character
  HAVING(?count > 1)
  ORDER BY DESC(?count)
  LIMIT 100
}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?count)
LIMIT 100

Query found at

• https://www.wikidata.org/wiki/User:TweetsFactsAndQueries/Queries/actors_who_played_the_same_real_politician_the_most_times