query-2204237100e5fdc8cef8c020dcf8517a

rq turtle/ttl

رؤساء الحكومات الفرنسية حسب طول الخدمة(P582)end time (P580)start time (P18)image (P39)position held (P31)instance of الخصائص المستخدمة: (Q15135541)head of government of France (Q5)human العناصر المستخدمة: French heads of government by length of service French heads of government by length of service Francouzští předsedové vlád podle délky funkčního období(P582)end time (P580)start time (P18)image (P39)position held (P31)instance of Použité vlastnosti: (Q15135541)head of government of France (Q5)human Použité položky: French heads of government by length of service French heads of government by length of service French heads of government by length of service French heads of government by length of service French heads of government by length of service French heads of government by length of service(P582)end time (P580)start time (P18)image (P39)position held (P31)instance of Propiedades utilizadas: (Q15135541)head of government of France (Q5)human Elementos utilizados: French heads of government by length of service Chefs de gouvernement français classés par durée de fonction(P582)end time (P580)start time (P18)image (P39)position held (P31)instance of Propriétés utilisées : (Q15135541)head of government of France (Q5)human Éléments utilisés : French heads of government by length of service(P582)end time (P580)start time (P18)image (P39)position held (P31)instance of מאפיינים משמשים: (Q15135541)head of government of France (Q5)human פריטים משמשים: French heads of government by length of service French heads of government by length of service Leader governativi francesi per durata del mandato(P582)end time (P580)start time (P18)image (P39)position held (P31)instance of Proprietà utilizzate: (Q15135541)head of government of France (Q5)human Elementi utilizzati: French heads of government by length of service(P582)end time (P580)start time (P18)image (P39)position held (P31)instance of 使用するプロパティ： (Q15135541)head of government of France (Q5)human 使用する項目： French heads of government by length of service French heads of government by length of service French heads of government by length of service French heads of government by length of service Franse regeringsleiders naar anciënniteit(P582)end time (P580)start time (P18)image (P39)position held (P31)instance of Gebruikte eigenschappen: (Q15135541)head of government of France (Q5)human Gebruikte items: French heads of government by length of service(P582)end time (P580)start time (P18)image (P39)position held (P31)instance of Wykorzystujące właściwości: (Q15135541)head of government of France (Q5)human Wykorzystujące elementy: French heads of government by length of service French heads of government by length of service French heads of government by length of service French heads of government by length of service Franska regeringsöverhuvuden efter längd på tjänsteperiod(P582)end time (P580)start time (P18)image (P39)position held (P31)instance of Använda egenskaper: (Q15135541)head of government of France (Q5)human Använda objekt: French heads of government by length of service Görev süresine göre Fransa devlet başkanları French heads of government by length of service(P582)end time (P580)start time (P18)image (P39)position held (P31)instance of Використані властивості: (Q15135541)head of government of France (Q5)human Використані елементи: French heads of government by length of service 法國政府首腦按任職年限排序(P582)end time (P580)start time (P18)image (P39)position held (P31)instance of 使用属性： (Q15135541)head of government of France (Q5)human 使用项：

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
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 DISTINCT ?item ?itemLabel ?positionLabel ?picture ?start ?end ?days WHERE
{
  ?item wdt:P31 wd:Q5 ;
        p:P39 ?position_statement .
  ?position_statement ps:P39 ?position ;
                      pq:P580 ?start FILTER (?start >= "1815-01-01T00:00:00Z"^^xsd:dateTime) .
  ?position wdt:P31|wdt:P279* wd:Q15135541 .
  OPTIONAL { ?position_statement pq:P582 ?x }
  OPTIONAL { ?item wdt:P18 ?picture }
  bind(if(bound(?x), ?x, NOW()) as ?end )
  bind(floor(?end - ?start) as ?days)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . }
}
ORDER BY DESC(?days) ?itemLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v10("?days"):::projected v9("?end"):::projected v4("?item"):::projected v2("?itemLabel"):::projected v8("?picture"):::projected v6("?position") v5("?position_statement") v3("?start"):::projected v7("?x") c7(["wd:Q15135541"]):::iri c14(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal c12(["bd:serviceParam"]):::iri c3(["wd:Q5"]):::iri f0[["?start >= '1815-01-01T00:00:00Z^^xsd:dateTime'"]] f0 --> v3 v4 --"p:direct/P31"--> c3 v4 --"p:P39"--> v5 v5 --"p:statement/P39"--> v6 v5 --"p:qualifier/P580"--> v3 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v6 --"p:direct/P279"--> c7 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v6 --"p:direct/P31"--> c7 end union0r <== or ==> union0l end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:qualifier/P582".-> v7 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P18".-> v8 end bind1[/"if(bound(?x),?x,NOW())"/] v7 --o bind1 bind1 --as--o v9 bind2[/"numeric-floor(?end - ?start)"/] v9 --o bind2 v3 --o bind2 bind2 --as--o v10 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end