Translations:Brabant wallon/7/en

From Resistance in Belgium
Revision as of 08:08, 8 October 2024 by FuzzyBot (talk | contribs) (Importing a new version from external source)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

{{#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:Q57 .  # Province of Walloon Brabant
 
 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 .