KHW:SPARQL examples: Różnice pomiędzy wersjami

Wersja z 12:22, 9 wrz 2026

Przykłady

Wszystkie osoby w wiki

PREFIX wd:  <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt: <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?person ?label
WHERE {
  ?person wdt:P1 wd:Q2 .

  OPTIONAL {
    ?person rdfs:label ?label .
    FILTER(LANG(?label) = "mul")
  }
}
ORDER BY ?label

Wypróbuj!

Wszyscy politycy

PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?person ?label
WHERE {
  ?person wdt:P1 wd:Q2 .
  ?person wdt:P20 wd:Q35911 .

  OPTIONAL {
    ?person rdfs:label ?label .
    FILTER(LANG(?label) = "mul")
  }
}
ORDER BY ?label

Wypróbuj!

Ciała zbiorowe które były aktywne w XIX wieku

PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?institution ?label ?activityStart ?activityEnd
WHERE {
  ?institution wdt:P1 wd:Q13168 .

  OPTIONAL {
    ?institution wdt:P22 ?activityStart .
  }

  OPTIONAL {
    ?institution wdt:P23 ?activityEnd .
  }

  OPTIONAL {
    ?institution rdfs:label ?label .
    FILTER(LANG(?label) = "mul")
  }

  FILTER(
    (BOUND(?activityStart) || BOUND(?activityEnd)) &&
    (!BOUND(?activityStart) || YEAR(?activityStart) <= 1900) &&
    (!BOUND(?activityEnd)   || YEAR(?activityEnd) >= 1801)
  )
}
ORDER BY ?label

Wypróbuj!

Obiekty dLibry w których autorem jest kobieta

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>

PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT ?dlibraLink ?title ?creator ?creatorLabel
WHERE {
  ?dlibraObject dp:creator ?creator .

  ?creator wdt:P15 wd:Q6 .

  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  OPTIONAL {
    ?creator rdfs:label ?creatorLabel .
    FILTER(LANG(?creatorLabel) = "mul")
  }

  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?creatorLabel ?title

Wypróbuj!

Karty ze sztambucha autorstwa mężczyzn

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>

PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT ?dlibraLink ?title ?creator ?creatorLabel
WHERE {
  ?dlibraObject dp:creator ?creator .
  ?dlibraObject dp:documenttype "karta ze sztambucha" .

  ?creator wdt:P15 wd:Q5 .

  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  OPTIONAL {
    ?creator rdfs:label ?creatorLabel .
    FILTER(LANG(?creatorLabel) = "mul")
  }

  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?creatorLabel ?title

Wypróbuj!

Publikacje z miejscem powiązanym z Arcarium Index

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>

PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT ?dlibraLink ?title ?place ?placeLabel
WHERE {
  ?dlibraObject dp:location ?place .

  ?place wdt:P1 wd:Q10 .

  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  OPTIONAL {
    ?place rdfs:label ?placeLabel .
    FILTER(LANG(?placeLabel) = "mul")
  }

  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(STR(?place), STR(wd:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?placeLabel ?title

Wypróbuj!

Dokumenty autorstwa polityków napisane w Berlinie w XIX wieku

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?authorLabel
  ?authorLink
  ?date
WHERE {
  # Berlin
  ?dlibraObject dp:location wd:Q29180 .

  # Creator is a person
  ?dlibraObject dp:creator ?author .
  ?author wdt:P1 wd:Q2 .

  # Creator is a politician
  ?author wdt:P20 ?politicianType .

  VALUES ?politicianType {
    wd:Q35911
    wd:Q38276
  }

  # Author label
  OPTIONAL {
    ?author rdfs:label ?authorLabel .
    FILTER(LANG(?authorLabel) = "mul")
  }

  # Normal Wikibase page URL for author
  BIND(
    IRI(
      REPLACE(
        STR(?author),
        "https://arcarium.index.bj.uj.edu.pl/entity/",
        "https://arcarium.index.bj.uj.edu.pl/wiki/Item:"
      )
    )
    AS ?authorLink
  )

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # XIX century
  ?dlibraObject dp:date ?date .

  FILTER(
    REGEX(STR(?date), "(18(0[1-9]|[1-9][0-9])|1900)")
  )

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(STR(?author), STR(wd:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?date ?title

Wypróbuj!

Dokumenty ikonograficzne wszystkich poetek

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?authorLabel
  ?authorLink
WHERE {
  # Iconographic document
  ?dlibraObject dp:documenttype "dokument ikonograficzny" .

  # Creator is a person
  ?dlibraObject dp:creator ?author .
  ?author wdt:P1 wd:Q2 .

  # Creator is a poetess
  ?author wdt:P20 wd:Q37031 .

  # Author label
  OPTIONAL {
    ?author rdfs:label ?authorLabel .
    FILTER(LANG(?authorLabel) = "mul")
  }

  # Normal Wikibase page URL for author
  BIND(
    IRI(
      REPLACE(
        STR(?author),
        "https://arcarium.index.bj.uj.edu.pl/entity/",
        "https://arcarium.index.bj.uj.edu.pl/wiki/Item:"
      )
    )
    AS ?authorLink
  )

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(STR(?author), STR(wd:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?authorLabel ?title

Wypróbuj!

Dokumenty wszystkich kobiet pisane z Berlina w XVIII wieku

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?authorLabel
  ?authorLink
  ?date
WHERE {
  # Berlin
  ?dlibraObject dp:location wd:Q29180 .

  # Creator is a person
  ?dlibraObject dp:creator ?author .
  ?author wdt:P1 wd:Q2 .

  # Creator is a woman
  ?author wdt:P15 wd:Q6 .

  # Author label
  OPTIONAL {
    ?author rdfs:label ?authorLabel .
    FILTER(LANG(?authorLabel) = "mul")
  }

  # Normal Wikibase page URL for author
  BIND(
    IRI(
      REPLACE(
        STR(?author),
        "https://arcarium.index.bj.uj.edu.pl/entity/",
        "https://arcarium.index.bj.uj.edu.pl/wiki/Item:"
      )
    )
    AS ?authorLink
  )

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # XVIII century
  ?dlibraObject dp:date ?date .

  FILTER(
    REGEX(STR(?date), "(17(0[1-9]|[1-9][0-9])|1800)")
  )

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(STR(?author), STR(wd:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?date ?authorLabel ?title

Wypróbuj!

Utwory wszystkich kobiet

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?authorLabel
  ?authorLink
WHERE {
  # Work
  ?dlibraObject dp:documenttype "utwór" .

  # Creator is a person
  ?dlibraObject dp:creator ?author .
  ?author wdt:P1 wd:Q2 .

  # Creator is a woman
  ?author wdt:P15 wd:Q6 .

  # Author label
  OPTIONAL {
    ?author rdfs:label ?authorLabel .
    FILTER(LANG(?authorLabel) = "mul")
  }

  # Normal Wikibase page URL for author
  BIND(
    IRI(
      REPLACE(
        STR(?author),
        "https://arcarium.index.bj.uj.edu.pl/entity/",
        "https://arcarium.index.bj.uj.edu.pl/wiki/Item:"
      )
    )
    AS ?authorLink
  )

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(STR(?author), STR(wd:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?authorLabel ?title

Wypróbuj!

Listy w języku hiszpański nieodnalezione w edycji

PREFIX ds: <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp: <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?language
  ?edition
WHERE {
  # Letter
  ?dlibraObject dp:documenttype "list" .

  # Spanish language
  ?dlibraObject dp:language ?language .
  FILTER(LCASE(STR(?language)) = "hiszpański")

  # Edition not found
  ?dlibraObject dp:edition ?edition .
  FILTER(LCASE(STR(?edition)) = "nieodnalezione")

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?title

Wypróbuj!

Listy do kobiet pisane w XVIII wieku

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?recipientLabel
  ?recipientLink
  ?date
WHERE {
  # Letter
  ?dlibraObject dp:documenttype "list" .

  # Recipient is a person
  ?dlibraObject dp:addressed ?recipient .
  ?recipient wdt:P1 wd:Q2 .

  # Recipient is a woman
  ?recipient wdt:P15 wd:Q6 .

  # Recipient label
  OPTIONAL {
    ?recipient rdfs:label ?recipientLabel .
    FILTER(LANG(?recipientLabel) = "mul")
  }

  # Normal Wikibase page URL for recipient
  BIND(
    IRI(
      REPLACE(
        STR(?recipient),
        "https://arcarium.index.bj.uj.edu.pl/entity/",
        "https://arcarium.index.bj.uj.edu.pl/wiki/Item:"
      )
    )
    AS ?recipientLink
  )

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # XVIII century
  ?dlibraObject dp:date ?date .

  FILTER(
    REGEX(STR(?date), "(17(0[1-9]|[1-9][0-9])|1800)")
  )

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(STR(?recipient), STR(wd:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?date ?recipientLabel ?title

Wypróbuj!

Dokumenty po francusku z XVII wieku

PREFIX ds: <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp: <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?date
WHERE {
  # French
  ?dlibraObject dp:language ?language .
  FILTER(LCASE(STR(?language)) = "francuski")

  # XVII century
  ?dlibraObject dp:date ?date .

  FILTER(
    REGEX(STR(?date), "(16(0[1-9]|[1-9][0-9])|1700)")
  )

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?date ?title

Wypróbuj!

Dokumenty o proweniencji Radowitz, w których w polach: nadawca, adresat, autor, osoba pojawia się Humboldt, Alexander von

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT
  ?dlibraLink
  ?title
WHERE {
  # Provenance contains "Radowitz"
  ?dlibraObject dp:provenance ?provenance .

  FILTER(
    CONTAINS(
      LCASE(STR(?provenance)),
      "radowitz"
    )
  )

  # Humboldt, Alexander von may occur in any of these fields
  VALUES ?field {
    dp:sender
    dp:addressed
    dp:creator
    dp:person
  }

  ?dlibraObject ?field wd:Q39574 .

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?title

Wypróbuj!

Faksymilia autografów o proweniencji Parthey

PREFIX ds: <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp: <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT
  ?dlibraLink
  ?title
WHERE {
  # Provenance contains "Parthey"
  ?dlibraObject dp:provenance ?provenance .

  FILTER(
    CONTAINS(
      LCASE(STR(?provenance)),
      "parthey"
    )
  )

  # Title contains both "faksymil..." and "autograf..."
  ?dlibraObject dp:title ?title .

  FILTER(
    CONTAINS(LCASE(STR(?title)), "faksymil") &&
    CONTAINS(LCASE(STR(?title)), "autograf")
  )

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?title

Wypróbuj!

Dokumenty o proweniencji Rocca powstałe we Florencji

PREFIX ds: <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp: <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX wd: <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT
  ?dlibraLink
  ?title
WHERE {
  # Provenance contains "Rocca"
  ?dlibraObject dp:provenance ?provenance .

  FILTER(
    CONTAINS(
      LCASE(STR(?provenance)),
      "rocca"
    )
  )

  # Florence
  ?dlibraObject dp:location wd:Q28644 .

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?title

Wypróbuj!

Karty ze sztambucha z XVI w. z wpisami po łacinie

PREFIX ds: <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp: <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?date
WHERE {
  # Album amicorum card
  ?dlibraObject dp:documenttype "karta ze sztambucha" .

  # Latin
  ?dlibraObject dp:language ?language .
  FILTER(LCASE(STR(?language)) = "łacina")

  # XVI century
  ?dlibraObject dp:date ?date .

  FILTER(
    REGEX(STR(?date), "(15(0[1-9]|[1-9][0-9])|1600)")
  )

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?date ?title

Wypróbuj!

Własnoręczne podpisy margrabiów księstwa Badenii i Brunszwiku

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT
  ?dlibraLink
  ?objectTitle
  ?personLabel
  ?personLink
WHERE {
  # Creator is a person
  ?dlibraObject dp:creator ?person .
  ?person wdt:P1 wd:Q2 .

  # Person has the title "margrabia"
  ?person wdt:P19 ?margraveTitle .

  VALUES ?margraveTitle {
    wd:Q36119
    wd:Q39726
  }

  # Baden or Brunswick
  OPTIONAL {
    ?person rdfs:label ?personLabel .
    FILTER(LANG(?personLabel) = "mul")
  }

  FILTER(
    CONTAINS(LCASE(STR(?personLabel)), "baden") ||
    CONTAINS(LCASE(STR(?personLabel)), "braunsch") ||
    CONTAINS(LCASE(STR(?personLabel)), "brunszw")
  )

  # Document type contains both "własnoręcz..." and "podpis"
  ?dlibraObject dp:documenttype ?documentType .

  FILTER(
    CONTAINS(LCASE(STR(?documentType)), "własnoręcz") &&
    CONTAINS(LCASE(STR(?documentType)), "podpis")
  )

  # Normal Wikibase page URL for person
  BIND(
    IRI(
      REPLACE(
        STR(?person),
        "https://arcarium.index.bj.uj.edu.pl/entity/",
        "https://arcarium.index.bj.uj.edu.pl/wiki/Item:"
      )
    )
    AS ?personLink
  )

  OPTIONAL {
    ?dlibraObject dp:title ?objectTitle .
  }

  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(STR(?person), STR(wd:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?personLabel ?objectTitle

Wypróbuj!