Translations:Limburg/7/en: Difference between revisions

From Resistance in Belgium
(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 ?DomicileLabel ?Nom ?Prenom
SELECT DISTINCT ?ResidenceLabel ?LastName ?FirstName
(CONCAT("<a href='", STR(?personne), "' target='_blank'>", REPLACE(STR(?personne), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonneID)
(CONCAT("<a href='", STR(?person), "' target='_blank'>", REPLACE(STR(?person), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonID)
       (CONCAT(SUBSTR(STR(?dateNaissance), 1, 4), "-", SUBSTR(STR(?dateNaissance), 6, 2), "-", SUBSTR(STR(?dateNaissance), 9, 2)) AS ?DateNaissance)
       (CONCAT(SUBSTR(STR(?birthDate), 1, 4), "-", SUBSTR(STR(?birthDate), 6, 2), "-", SUBSTR(STR(?birthDate), 9, 2)) AS ?BirthDate)
       ?FondsArchivesLabel ?NoInventaire
       ?ArchiveCollectionLabel ?InventoryNumber
WHERE {
WHERE {
   ?personne wdt:P7 ?Domicile .  
   ?person wdt:P7 ?Residence .  
   ?Domicile wdt:P14* wd:Q51 .  # Province de Limbourg
   ?Residence wdt:P14* wd:Q51 .  # Province of Limburg
    
    
   OPTIONAL { ?personne wdt:P2 ?Prenom }   
   OPTIONAL { ?person wdt:P2 ?FirstName }   
   OPTIONAL { ?personne wdt:P3 ?Nom }   
   OPTIONAL { ?person wdt:P3 ?LastName }   
   OPTIONAL { ?personne wdt:P67 ?dateNaissance }   
   OPTIONAL { ?person wdt:P67 ?birthDate }   
   
   
   # Lien vers les collections et numéro d'inventaire
   # Link to collections and inventory number
   ?personne p:P34 ?DeclarationArchives .  
   ?person p:P34 ?ArchiveDeclaration .  
   ?DeclarationArchives ps:P34 ?FondsArchives .  
   ?ArchiveDeclaration ps:P34 ?ArchiveCollection .  
   ?DeclarationArchives pq:P35 ?NoInventaire .
   ?ArchiveDeclaration pq:P35 ?InventoryNumber .

Latest revision as of 18:56, 20 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 ?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 .