Przejdź do zawartości

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

Dodaj linki
Z Arcarium Index
← poprzednia edycjanastępna edycja →
Nie podano opisu zmian
Nie podano opisu zmian
Linia 719: Linia 719:
</syntaxhighlight>
</syntaxhighlight>
[https://arcarium.index.bj.uj.edu.pl/sparql/#PREFIX%20ds%3A%20%3Chttps%3A%2F%2Farcarium.manuscripta.bj.uj.edu.pl%2Fsubject%2F%3E%0APREFIX%20dp%3A%20%3Chttps%3A%2F%2Farcarium.manuscripta.bj.uj.edu.pl%2Fpredicate%2F%3E%0APREFIX%20dc%3A%20%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Felements%2F1.1%2F%3E%0A%0ASELECT%20DISTINCT%0A%20%20%3FdlibraLink%0A%20%20%3Ftitle%0AWHERE%20%7B%0A%20%20%23%20Provenance%20contains%20%22Parthey%22%0A%20%20%3FdlibraObject%20dp%3Aprovenance%20%3Fprovenance%20.%0A%0A%20%20FILTER%28%0A%20%20%20%20CONTAINS%28%0A%20%20%20%20%20%20LCASE%28STR%28%3Fprovenance%29%29%2C%0A%20%20%20%20%20%20%22parthey%22%0A%20%20%20%20%29%0A%20%20%29%0A%0A%20%20%23%20Title%20contains%20both%20%22faksymil...%22%20and%20%22autograf...%22%0A%20%20%3FdlibraObject%20dp%3Atitle%20%3Ftitle%20.%0A%0A%20%20FILTER%28%0A%20%20%20%20CONTAINS%28LCASE%28STR%28%3Ftitle%29%29%2C%20%22faksymil%22%29%20%26%26%0A%20%20%20%20CONTAINS%28LCASE%28STR%28%3Ftitle%29%29%2C%20%22autograf%22%29%0A%20%20%29%0A%0A%20%20%23%20Actual%20dLibra%20URL%0A%20%20%3FdlibraObject%20dc%3Aidentifier%20%3FdlibraLink%20.%0A%0A%20%20FILTER%28%0A%20%20%20%20STRSTARTS%28STR%28%3FdlibraObject%29%2C%20STR%28ds%3A%29%29%20%26%26%0A%20%20%20%20STRSTARTS%28%0A%20%20%20%20%20%20STR%28%3FdlibraLink%29%2C%0A%20%20%20%20%20%20%22https%3A%2F%2Farcarium.manuscripta.bj.uj.edu.pl%2Fdlibra%2F%22%0A%20%20%20%20%29%0A%20%20%29%0A%7D%0AORDER%20BY%20%3Ftitle Wypróbuj!]
[https://arcarium.index.bj.uj.edu.pl/sparql/#PREFIX%20ds%3A%20%3Chttps%3A%2F%2Farcarium.manuscripta.bj.uj.edu.pl%2Fsubject%2F%3E%0APREFIX%20dp%3A%20%3Chttps%3A%2F%2Farcarium.manuscripta.bj.uj.edu.pl%2Fpredicate%2F%3E%0APREFIX%20dc%3A%20%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Felements%2F1.1%2F%3E%0A%0ASELECT%20DISTINCT%0A%20%20%3FdlibraLink%0A%20%20%3Ftitle%0AWHERE%20%7B%0A%20%20%23%20Provenance%20contains%20%22Parthey%22%0A%20%20%3FdlibraObject%20dp%3Aprovenance%20%3Fprovenance%20.%0A%0A%20%20FILTER%28%0A%20%20%20%20CONTAINS%28%0A%20%20%20%20%20%20LCASE%28STR%28%3Fprovenance%29%29%2C%0A%20%20%20%20%20%20%22parthey%22%0A%20%20%20%20%29%0A%20%20%29%0A%0A%20%20%23%20Title%20contains%20both%20%22faksymil...%22%20and%20%22autograf...%22%0A%20%20%3FdlibraObject%20dp%3Atitle%20%3Ftitle%20.%0A%0A%20%20FILTER%28%0A%20%20%20%20CONTAINS%28LCASE%28STR%28%3Ftitle%29%29%2C%20%22faksymil%22%29%20%26%26%0A%20%20%20%20CONTAINS%28LCASE%28STR%28%3Ftitle%29%29%2C%20%22autograf%22%29%0A%20%20%29%0A%0A%20%20%23%20Actual%20dLibra%20URL%0A%20%20%3FdlibraObject%20dc%3Aidentifier%20%3FdlibraLink%20.%0A%0A%20%20FILTER%28%0A%20%20%20%20STRSTARTS%28STR%28%3FdlibraObject%29%2C%20STR%28ds%3A%29%29%20%26%26%0A%20%20%20%20STRSTARTS%28%0A%20%20%20%20%20%20STR%28%3FdlibraLink%29%2C%0A%20%20%20%20%20%20%22https%3A%2F%2Farcarium.manuscripta.bj.uj.edu.pl%2Fdlibra%2F%22%0A%20%20%20%20%29%0A%20%20%29%0A%7D%0AORDER%20BY%20%3Ftitle Wypróbuj!]
=== Dokumenty o proweniencji Rocca powstałe we Florencji ===
<syntaxhighlight lang="SPARQL" class="mw-highlight-lang-sparql">
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
</syntaxhighlight>
[https://arcarium.index.bj.uj.edu.pl/sparql/#PREFIX%20ds%3A%20%3Chttps%3A%2F%2Farcarium.manuscripta.bj.uj.edu.pl%2Fsubject%2F%3E%0APREFIX%20dp%3A%20%3Chttps%3A%2F%2Farcarium.manuscripta.bj.uj.edu.pl%2Fpredicate%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Farcarium.index.bj.uj.edu.pl%2Fentity%2F%3E%0APREFIX%20dc%3A%20%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Felements%2F1.1%2F%3E%0A%0ASELECT%20DISTINCT%0A%20%20%3FdlibraLink%0A%20%20%3Ftitle%0AWHERE%20%7B%0A%20%20%23%20Provenance%20contains%20%22Rocca%22%0A%20%20%3FdlibraObject%20dp%3Aprovenance%20%3Fprovenance%20.%0A%0A%20%20FILTER%28%0A%20%20%20%20CONTAINS%28%0A%20%20%20%20%20%20LCASE%28STR%28%3Fprovenance%29%29%2C%0A%20%20%20%20%20%20%22rocca%22%0A%20%20%20%20%29%0A%20%20%29%0A%0A%20%20%23%20Florence%0A%20%20%3FdlibraObject%20dp%3Alocation%20wd%3AQ28644%20.%0A%0A%20%20%23%20Object%20title%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3FdlibraObject%20dp%3Atitle%20%3Ftitle%20.%0A%20%20%7D%0A%0A%20%20%23%20Actual%20dLibra%20URL%0A%20%20%3FdlibraObject%20dc%3Aidentifier%20%3FdlibraLink%20.%0A%0A%20%20FILTER%28%0A%20%20%20%20STRSTARTS%28STR%28%3FdlibraObject%29%2C%20STR%28ds%3A%29%29%20%26%26%0A%20%20%20%20STRSTARTS%28%0A%20%20%20%20%20%20STR%28%3FdlibraLink%29%2C%0A%20%20%20%20%20%20%22https%3A%2F%2Farcarium.manuscripta.bj.uj.edu.pl%2Fdlibra%2F%22%0A%20%20%20%20%29%0A%20%20%29%0A%7D%0AORDER%20BY%20%3Ftitle Wypróbuj!]

Wersja z 12:07, 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!

Źródło: „https://arcarium.index.bj.uj.edu.pl/index.php?title=KHW:SPARQL_examples&oldid=50081”