Translations:Limburg/7/en: Difference between revisions
(Importing a new version from external source) |
(Importing a new version from external source) |
||
| Line 1: | Line 1: | ||
<div class="table-container"> | <div class="table-container"> | ||
{{#sparql: | {{#sparql: | ||
SELECT DISTINCT ? | SELECT DISTINCT ?ResidenceLabel ?LastName ?FirstName | ||
(CONCAT("<a href='", STR(? | (CONCAT("<a href='", STR(?person), "' target='_blank'>", REPLACE(STR(?person), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonID) | ||
(CONCAT(SUBSTR(STR(? | (CONCAT(SUBSTR(STR(?birthDate), 1, 4), "-", SUBSTR(STR(?birthDate), 6, 2), "-", SUBSTR(STR(?birthDate), 9, 2)) AS ?BirthDate) | ||
? | ?ArchiveCollectionLabel ?InventoryNumber | ||
WHERE { | WHERE { | ||
? | ?person wdt:P7 ?Residence . | ||
? | ?Residence wdt:P14* wd:Q51 . # Province of Limburg | ||
OPTIONAL { ? | OPTIONAL { ?person wdt:P2 ?FirstName } | ||
OPTIONAL { ? | OPTIONAL { ?person wdt:P3 ?LastName } | ||
OPTIONAL { ? | OPTIONAL { ?person wdt:P67 ?birthDate } | ||
# | # Link to collections and inventory number | ||
? | ?person p:P34 ?ArchiveDeclaration . | ||
? | ?ArchiveDeclaration ps:P34 ?ArchiveCollection . | ||
? | ?ArchiveDeclaration pq:P35 ?InventoryNumber . | ||
Latest revision as of 18:56, 20 October 2024
{{#sparql: SELECT DISTINCT ?ResidenceLabel ?LastName ?FirstName (CONCAT("<a href='", STR(?person), "' target='_blank'>", REPLACE(STR(?person), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonID)
(CONCAT(SUBSTR(STR(?birthDate), 1, 4), "-", SUBSTR(STR(?birthDate), 6, 2), "-", SUBSTR(STR(?birthDate), 9, 2)) AS ?BirthDate)
?ArchiveCollectionLabel ?InventoryNumber
WHERE {
?person wdt:P7 ?Residence .
?Residence wdt:P14* wd:Q51 . # Province of Limburg
OPTIONAL { ?person wdt:P2 ?FirstName }
OPTIONAL { ?person wdt:P3 ?LastName }
OPTIONAL { ?person wdt:P67 ?birthDate }
# Link to collections and inventory number
?person p:P34 ?ArchiveDeclaration .
?ArchiveDeclaration ps:P34 ?ArchiveCollection .
?ArchiveDeclaration pq:P35 ?InventoryNumber .