Translations:Limburg/7/en: Difference between revisions

Revision as of 08:03, 8 October 2024

Message definition (Limburg)

<div class="table-container">
{{#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 .

{{#sparql: SELECT DISTINCT ?DomicileLabel ?Nom ?Prenom (CONCAT("<a href='", STR(?personne), "' target='_blank'>", REPLACE(STR(?personne), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonneID)

     (CONCAT(SUBSTR(STR(?dateNaissance), 1, 4), "-", SUBSTR(STR(?dateNaissance), 6, 2), "-", SUBSTR(STR(?dateNaissance), 9, 2)) AS ?DateNaissance)
      ?FondsArchivesLabel ?NoInventaire

WHERE {

 ?personne wdt:P7 ?Domicile . 
 ?Domicile wdt:P14* wd:Q51 .  # Province de Limbourg
 
 OPTIONAL { ?personne wdt:P2 ?Prenom }  
 OPTIONAL { ?personne wdt:P3 ?Nom }  
 OPTIONAL { ?personne wdt:P67 ?dateNaissance }  

 # Lien vers les collections et numéro d'inventaire
 ?personne p:P34 ?DeclarationArchives . 
 ?DeclarationArchives ps:P34 ?FondsArchives . 
 ?DeclarationArchives pq:P35 ?NoInventaire .