query-d891f7c19710b18d6aad43cadeafa731

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?label ?date (year(?date) as ?annee) WHERE {
  ?item wdt:P31 wd:Q47018478.
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "fr,en".
    ?item rdfs:label ?label.
  }
MINUS { ?item (wdt:P576|wdt:P582|wdt:P3999) ?dispar. }#on ne veut pas les item disparues
  MINUS {
    ?item wdt:P5817|wdt:P5816 ?interdit.
    VALUES ?interdit {    wd:Q811683    wd:Q63065035    wd:Q12377751   wd:Q97317113   wd:Q55653430   wd:Q30108381   wd:Q55570340   wd:Q11639308 wd:Q104664889
    }
  }#on ne veut pas les cas particuliers, en construction etc

   FILTER(NOT EXISTS {
   ?item rdfs:label ?lang_label.
   FILTER(LANG(?lang_label) = "fr")
 })
}

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?annee") v4("?dispar") v6("?interdit") v2("?item"):::projected v3("?label"):::projected v1("?lang_label") c4(["wd:Q47018478"]):::iri c6(["bd:serviceParam"]):::iri c8(["fr,en"]):::literal f0[["not "]] subgraph f0e0["Exists Clause"] e0f0[["?lang_label = 'fr'"]] e0f0 --> e0v1 e0v2 --"rdfs:label"--> e0v1 e0v2("?item"):::projected e0v1("?lang_label"):::projected end f0--EXISTS--> f0e0 f0 --> v1 f0 --> v2 f0 --> c2 f1[["?lang_label = 'fr'"]] f1 --> v1 v2 --"rdfs:label"--> v1 v2 --"wdt:P31"--> c4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 v2 --"rdfs:label"--> v3 end subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; 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; v2 --"wdt:P3999"--> v4 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P582"--> v4 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P576"--> v4 end union0r <== or ==> union0l end end subgraph minus3["MINUS"] style minus3 stroke-width:6px,fill:pink,stroke:red; subgraph union2[" Union "] subgraph union2l[" "] style union2l fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P5816"--> v6 end subgraph union2r[" "] style union2r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P5817"--> v6 end union2r <== or ==> union2l end bind4[/VALUES ?interdit/] bind4-->v6 bind40(["wd:Q811683"]) bind40 --> bind4 bind41(["wd:Q63065035"]) bind41 --> bind4 bind42(["wd:Q12377751"]) bind42 --> bind4 bind43(["wd:Q97317113"]) bind43 --> bind4 bind44(["wd:Q55653430"]) bind44 --> bind4 bind45(["wd:Q30108381"]) bind45 --> bind4 bind46(["wd:Q55570340"]) bind46 --> bind4 bind47(["wd:Q11639308"]) bind47 --> bind4 bind48(["wd:Q104664889"]) bind48 --> bind4 end bind5[/"year-from-dateTime(?date)"/] null --o bind5 bind5 --as--o v6