Difference between revisions of "S230.A1 fr"
S230.A1 fr
Jump to navigation
Jump to search
Line 7: | Line 7: | ||
PREFIX ps: <http://external-wikibase-statbel-wikibase/prop/statement/> | PREFIX ps: <http://external-wikibase-statbel-wikibase/prop/statement/> | ||
PREFIX pq: <http://external-wikibase-statbel-wikibase/prop/qualifier/> | PREFIX pq: <http://external-wikibase-statbel-wikibase/prop/qualifier/> | ||
− | SELECT ?DatasetLabel ?TaalLabel ?JaarLabel ?NummerLabel ?GrootteLabel ? | + | SELECT ?DatasetLabel ?TaalLabel ?JaarLabel ?NummerLabel ?GrootteLabel ?Link ?OpmerkingLabel |
WHERE | WHERE | ||
{ | { | ||
Line 17: | Line 17: | ||
OPTIONAL {?Dataset wdt:P56 ?Opmerking .} | OPTIONAL {?Dataset wdt:P56 ?Opmerking .} | ||
OPTIONAL {?Dist wdt:P310 ?LinkNL . } | OPTIONAL {?Dist wdt:P310 ?LinkNL . } | ||
− | BIND(IRI(REPLACE(? | + | BIND(STRLEN(str(?LinkNL)) as ?Iets) . |
+ | BIND( SUBSTR(str( ?LinkNL), 1,?Iets-4 ) as ?IetsAnders) . | ||
+ | BIND( CONCAT( "<a target=", '"', "_blank ",'"', "href=",'"',?IetsAnders,".pdf",'"',">",?IetsAnders,".pdf </a>" ) as ?Samen) . | ||
+ | BIND(IRI(REPLACE(?Samen, '^(.+)$', ?Samen)) AS ?Link) . | ||
?Dist wdt:P308 ?Code . | ?Dist wdt:P308 ?Code . | ||
?Dist wdt:P307 ?Grootte . | ?Dist wdt:P307 ?Grootte . |
Revision as of 12:24, 13 April 2023