query-489a2a9cb967820ba3dc75e095bac2b1

rq turtle/ttl

الشعراء والملوك(P18)image (P570)date of death (P569)date of birth (P582)end time (P748)appointed by (P580)start time (P39)position held الخصائص المستخدمة: (Q877838)Poet Laureate of the United Kingdom العناصر المستخدمة: Poets and monarchs Poets and monarchs Básníci a panovníci(P18)image (P570)date of death (P569)date of birth (P582)end time (P748)appointed by (P580)start time (P39)position held Použité vlastnosti: (Q877838)Poet Laureate of the United Kingdom Použité položky: Poets and monarchs Poets and monarchs Poets and monarchs Poets and monarchs Poets and monarchs Poets and monarchs(P18)image (P570)date of death (P569)date of birth (P582)end time (P748)appointed by (P580)start time (P39)position held Propiedades utilizadas: (Q877838)Poet Laureate of the United Kingdom Elementos utilizados: Poets and monarchs Poètes lauréats du Royaume-Uni, avec les monarques qui les ont nommés(P18)image (P570)date of death (P569)date of birth (P582)end time (P748)appointed by (P580)start time (P39)position held Propriétés utilisées : (Q877838)Poet Laureate of the United Kingdom Éléments utilisés : Poets and monarchs(P18)image (P570)date of death (P569)date of birth (P582)end time (P748)appointed by (P580)start time (P39)position held מאפיינים משמשים: (Q877838)Poet Laureate of the United Kingdom פריטים משמשים: Poets and monarchs Poets and monarchs Poeti e regnanti(P18)image (P570)date of death (P569)date of birth (P582)end time (P748)appointed by (P580)start time (P39)position held Proprietà utilizzate: (Q877838)Poet Laureate of the United Kingdom Elementi utilizzati: Poets and monarchs(P18)image (P570)date of death (P569)date of birth (P582)end time (P748)appointed by (P580)start time (P39)position held 使用するプロパティ： (Q877838)Poet Laureate of the United Kingdom 使用する項目： Poets and monarchs(P18)image (P570)date of death (P569)date of birth (P582)end time (P748)appointed by (P580)start time (P39)position held 다음 속성이 사용됨 (Q877838)Poet Laureate of the United Kingdom 다음 항목이 사용됨 Poets and monarchs Poets and monarchs Poets and monarchs Dichters en vorsten(P18)image (P570)date of death (P569)date of birth (P582)end time (P748)appointed by (P580)start time (P39)position held Gebruikte eigenschappen: (Q877838)Poet Laureate of the United Kingdom Gebruikte items: Poets and monarchs(P18)image (P570)date of death (P569)date of birth (P582)end time (P748)appointed by (P580)start time (P39)position held Wykorzystujące właściwości: (Q877838)Poet Laureate of the United Kingdom Wykorzystujące elementy: Poets and monarchs Poets and monarchs Поэты и монархи Poets and monarchs Poeter och monarker(P18)image (P570)date of death (P569)date of birth (P582)end time (P748)appointed by (P580)start time (P39)position held Använda egenskaper: (Q877838)Poet Laureate of the United Kingdom Använda objekt: Poets and monarchs Poets and monarchs Poets and monarchs(P18)image (P570)date of death (P569)date of birth (P582)end time (P748)appointed by (P580)start time (P39)position held Використані властивості: (Q877838)Poet Laureate of the United Kingdom Використані елементи: Poets and monarchs 诗人且君主(P18)image (P570)date of death (P569)date of birth (P582)end time (P748)appointed by (P580)start time (P39)position held 使用属性： (Q877838)Poet Laureate of the United Kingdom 使用项：

Use at

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 ?poetLabel ?image ?yob ?yod ?start ?end ?monarchLabel
WHERE
{
  ?poet p:P39 ?positionStat.
  ?positionStat ps:P39 wd:Q877838;
                pq:P580 ?start;
                pq:P748 ?monarch.
  OPTIONAL {
    ?positionStat pq:P582 ?end.
  }
  OPTIONAL {
    ?poet wdt:P18 ?image;
          wdt:P569 ?dob;
          wdt:P570 ?dod.
  }
  BIND(YEAR(?dob) AS ?yob).
  BIND(YEAR(?dod) AS ?yod).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?start DESC(?monarchLabel)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?dob") v9("?dod") v6("?end"):::projected v7("?image"):::projected v5("?monarch") v2("?monarchLabel"):::projected v3("?poet") v4("?positionStat") v1("?start"):::projected v10("?yob"):::projected v11("?yod"):::projected c13(["en"]):::literal c3(["wd:Q877838"]):::iri c11(["bd:serviceParam"]):::iri v3 --"p:P39"--> v4 v4 --"p:statement/P39"--> c3 v4 --"p:qualifier/P580"--> v1 v4 --"p:qualifier/P748"--> v5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:qualifier/P582".-> v6 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P18".-> v7 v3 --"p:direct/P569"--> v8 v3 --"p:direct/P570"--> v9 end bind0[/"year-from-dateTime(?dob)"/] v8 --o bind0 bind0 --as--o v10 bind1[/"year-from-dateTime(?dod)"/] v9 --o bind1 bind1 --as--o v11 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end