query-2768306a98b02926bd7b34e60570b781

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?label ?count
WHERE { 
  {
   {
   SELECT DISTINCT (COUNT(?item) AS ?count) WHERE { 
    ?item (wdt:P31/(wdt:P279*)) wd:Q31728;
      wdt:P17 wd:Q142.
   } 
}  BIND("Aministrations publiques en France" as ?label) 
  }
  UNION 
  {
   {
  SELECT DISTINCT (COUNT(?item) as ?count) WHERE {
  ?item (wdt:P31/(wdt:P279*)) wd:Q2824642.
  }
}   
  BIND("Aministrations publiques françaises" as ?label) 
  }
  UNION 
  {
   {
  SELECT (COUNT(?item) as ?count) WHERE {
    wd:Q1450662 ((wdt:P355*)/(wdt:P527*)) ?item.
  }
}   
  BIND("Administrations d'Etat" as ?label) 
  }
}
ORDER BY DESC(?count)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?count"):::projected v2("?item") v4("?label"):::projected a1((" ")) a2((" ")) a3((" ")) c6(["wd:Q2824642"]):::iri c3(["wd:Q31728"]):::iri c7(["wd:Q1450662"]):::iri c5(["wd:Q142"]):::iri subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; c7 --"wdt:P355"--> a3 a3 --"wdt:P527"--> v2 bind1[/"count(?item)"/] v2 --o bind1 bind1 --as--o v4 bind2[/"'Administrations d'Etat'"/] bind2 --as--o v4 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P31"--> a2 a2 --"wdt:P279"--> c6 bind4[/"count(?item)"/] v2 --o bind4 bind4 --as--o v4 bind5[/"'Aministrations publiques françaises'"/] bind5 --as--o v4 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c3 v2 --"wdt:P17"--> c5 bind7[/"count(?item)"/] v2 --o bind7 bind7 --as--o v4 bind8[/"'Aministrations publiques en France'"/] bind8 --as--o v4 end union0r <== or ==> union0l end