query-ef8b2c4f1998f601bfdab1a9d0020709

rq turtle/ttl

Propertiesposition held (P39)occupation (P106)subclass of (P279)

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 bd: <http://www.bigdata.com/rdf#>
select ?parliament ?parliamentLabel ?job ?jobLabel ?s

WHERE{
  {
    SELECT ?parliament (MAX(?sens) AS ?s) WHERE{
       {
     SELECT (COUNT(?sen) AS ?sens) ?job ?parliament  WHERE { 
      ?sen wdt:P39 ?parliament;
          wdt:P106 ?job.
      ?parliament wdt:P279* wd:Q486839  
      FILTER (?job != wd:Q82955)
    } GROUP BY ?job ?parliament HAVING (?sens > 1)
  }    } GROUP BY ?parliament
  } 
   {
     SELECT (COUNT(?sen) AS ?sens) ?job ?parliament  WHERE { 
      ?sen wdt:P39 ?parliament;
          wdt:P106 ?job.
      ?parliament wdt:P279* wd:Q486839  
      FILTER (?job != wd:Q82955)
    } GROUP BY ?job ?parliament HAVING (?sens > 1)
  }  FILTER(?s = ?sens)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }  
} ORDER BY DESC(?s)

Query found at

• https://www.wikidata.org/wiki/User:MartinPoulter/queries