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#>
#afficher le nombre d'éléments disposant de la propriété "archivé par" (P485) par institution française
#introduire un correctif en déduisant le nombre trouvé le 11.03.2019 pour remettre tous les compteurs à zéro.
#afficher le lieu où est située l'institution.
#classer les institution par ordre de nombre d'éléments décroissant.
SELECT ?institution ?institutionLabel ?lieuLabel (COUNT(?item) - COALESCE(?subtrahend, 0) AS ?total) 
WHERE 
{
  ?item wdt:P485 ?institution . #les éléments doivent disposé de la propriété "archivé par" qui renvoie à une institution.
  ?institution wdt:P17 wd:Q142; #l'institution doit être localisée en France
               wdt:P131 ?lieu. #localisation administrative de l'institution

  OPTIONAL {
    VALUES (?institution ?subtrahend) {
      (wd:Q182542 593)(wd:Q2860505 113)(wd:Q193563 3)(wd:Q16303821 3)(wd:Q3152115 3)(wd:Q2860516 2)(wd:Q838691 2)(wd:Q273461 2)(wd:Q20670712 1)(wd:Q3075420 1)(wd:Q19833040 1)
      (wd:Q2901309 1)(wd:Q2948151 1)(wd:Q19606447 1)(wd:Q19606436 1)(wd:Q16010742 1)(wd:Q19606442 94)(wd:Q19606454 1)(wd:Q30218775 1)(wd:Q19606460 1)(wd:Q47524704 1)
      (wd:Q1492436 1)(wd:Q2717848 1)(wd:Q18785452 1)(wd:Q2860474 1)(wd:Q2860557 1)(wd:Q2860461 1)(wd:Q1328440 1)(wd:Q2860498 1)(wd:Q202660 1)(wd:Q18213967 1)
    }
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr,en". }
}
GROUP BY ?institution ?institutionLabel ?lieuLabel ?subtrahend
ORDER BY DESC (?total) ?institutionLabel

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?institution"):::projected v2("?institutionLabel"):::projected v3("?item") v5("?lieu") v6("?subtrahend"):::projected v7("?total") c6(["bd:serviceParam"]):::iri c8(["#91;AUTO_LANGUAGE#93;,fr,en"]):::literal c3(["wd:Q142"]):::iri v3 --"wdt:P485"--> v6 v6 --"wdt:P17"--> c3 v6 --"wdt:P131"--> v5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; bind0[/VALUES ?institution ?subtrahend/] bind0-->v6 bind0-->v6 bind00(["wd:Q182542"]) bind00 --> bind0 bind01(["593^^xsd:integer"]) bind01 --> bind0 bind02(["wd:Q2860505"]) bind02 --> bind0 bind03(["113^^xsd:integer"]) bind03 --> bind0 bind04(["wd:Q193563"]) bind04 --> bind0 bind05(["3^^xsd:integer"]) bind05 --> bind0 bind06(["wd:Q16303821"]) bind06 --> bind0 bind07(["3^^xsd:integer"]) bind07 --> bind0 bind08(["wd:Q3152115"]) bind08 --> bind0 bind09(["3^^xsd:integer"]) bind09 --> bind0 bind010(["wd:Q2860516"]) bind010 --> bind0 bind011(["2^^xsd:integer"]) bind011 --> bind0 bind012(["wd:Q838691"]) bind012 --> bind0 bind013(["2^^xsd:integer"]) bind013 --> bind0 bind014(["wd:Q273461"]) bind014 --> bind0 bind015(["2^^xsd:integer"]) bind015 --> bind0 bind016(["wd:Q20670712"]) bind016 --> bind0 bind017(["1^^xsd:integer"]) bind017 --> bind0 bind018(["wd:Q3075420"]) bind018 --> bind0 bind019(["1^^xsd:integer"]) bind019 --> bind0 bind020(["wd:Q19833040"]) bind020 --> bind0 bind021(["1^^xsd:integer"]) bind021 --> bind0 bind022(["wd:Q2901309"]) bind022 --> bind0 bind023(["1^^xsd:integer"]) bind023 --> bind0 bind024(["wd:Q2948151"]) bind024 --> bind0 bind025(["1^^xsd:integer"]) bind025 --> bind0 bind026(["wd:Q19606447"]) bind026 --> bind0 bind027(["1^^xsd:integer"]) bind027 --> bind0 bind028(["wd:Q19606436"]) bind028 --> bind0 bind029(["1^^xsd:integer"]) bind029 --> bind0 bind030(["wd:Q16010742"]) bind030 --> bind0 bind031(["1^^xsd:integer"]) bind031 --> bind0 bind032(["wd:Q19606442"]) bind032 --> bind0 bind033(["94^^xsd:integer"]) bind033 --> bind0 bind034(["wd:Q19606454"]) bind034 --> bind0 bind035(["1^^xsd:integer"]) bind035 --> bind0 bind036(["wd:Q30218775"]) bind036 --> bind0 bind037(["1^^xsd:integer"]) bind037 --> bind0 bind038(["wd:Q19606460"]) bind038 --> bind0 bind039(["1^^xsd:integer"]) bind039 --> bind0 bind040(["wd:Q47524704"]) bind040 --> bind0 bind041(["1^^xsd:integer"]) bind041 --> bind0 bind042(["wd:Q1492436"]) bind042 --> bind0 bind043(["1^^xsd:integer"]) bind043 --> bind0 bind044(["wd:Q2717848"]) bind044 --> bind0 bind045(["1^^xsd:integer"]) bind045 --> bind0 bind046(["wd:Q18785452"]) bind046 --> bind0 bind047(["1^^xsd:integer"]) bind047 --> bind0 bind048(["wd:Q2860474"]) bind048 --> bind0 bind049(["1^^xsd:integer"]) bind049 --> bind0 bind050(["wd:Q2860557"]) bind050 --> bind0 bind051(["1^^xsd:integer"]) bind051 --> bind0 bind052(["wd:Q2860461"]) bind052 --> bind0 bind053(["1^^xsd:integer"]) bind053 --> bind0 bind054(["wd:Q1328440"]) bind054 --> bind0 bind055(["1^^xsd:integer"]) bind055 --> bind0 bind056(["wd:Q2860498"]) bind056 --> bind0 bind057(["1^^xsd:integer"]) bind057 --> bind0 bind058(["wd:Q202660"]) bind058 --> bind0 bind059(["1^^xsd:integer"]) bind059 --> bind0 bind060(["wd:Q18213967"]) bind060 --> bind0 bind061(["1^^xsd:integer"]) bind061 --> bind0 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 -."wikibase:language".-> c8 end bind2[/" - ?subtrahend'0^^xsd:integer'"/] null --o bind2 v6 --o bind2 bind2 --as--o v7