User:Difool/viaf queries

RERO ID (legacy) (P3065)

Pages with VIAF and P3065

SELECT DISTINCT ?item ?local_auth_id ?viaf ?link WHERE {
  ?item wdt:P3065 ?local_auth_id.
  ?item wdt:P31 wd:Q5.
  ?item wdt:P214 ?viaf.
  OPTIONAL {
    ?item p:P3065 ?statement0.
    ?statement0 ps:P3065 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/RERO%7C", REPLACE(REPLACE(STR(?local_auth_id), "02-", ""), "02_", ""))) AS ?link)
} LIMIT 10

Try it!

All pages about humans with P3065 and without VIAF

SELECT DISTINCT ?item ?local_auth_id ?link WHERE {
  ?item wdt:P3065 ?local_auth_id.
  FILTER(EXISTS { ?item wdt:P31 wd:Q5. })
  MINUS { ?item p:P214 ?viaf. }
  OPTIONAL {
    ?item p:P3065 ?statement0.
    ?statement0 ps:P3065 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/RERO%7C", REPLACE(REPLACE(STR(?local_auth_id), "02-", ""), "02_", ""))) AS ?link)
}

Try it!

National Library Board Singapore ID (former scheme) (P3988)

• Not working, VIAF uses an unknown numeric code

Pages with VIAF and P3988

SELECT DISTINCT ?item ?local_auth_id ?viaf_link ?search_link WHERE {
  ?item wdt:P3988 ?local_auth_id.
  ?item wdt:P31 wd:Q5.
  ?item wdt:P214 ?viaf.
  OPTIONAL {
    ?item p:P3988 ?statement0.
    ?statement0 ps:P3988 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/", STR(?viaf))) AS ?viaf_link)
  BIND(IRI(CONCAT("https://viaf.org/viaf/NLB%7C", STR(?local_auth_id))) AS ?search_link)
} LIMIT 10

Try it!

NACSIS-CAT author ID (P271)

Pages with VIAF and P271

SELECT DISTINCT ?item ?local_auth_id ?viaf_link ?search_link WHERE {
  ?item wdt:P271 ?local_auth_id.
  ?item wdt:P31 wd:Q5.
  ?item wdt:P214 ?viaf.
  OPTIONAL {
    ?item p:P271 ?statement0.
    ?statement0 ps:P271 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/", STR(?viaf))) AS ?viaf_link)
  BIND(IRI(CONCAT("https://viaf.org/viaf/NII%7C", STR(?local_auth_id))) AS ?search_link)
} LIMIT 10

Try it!

CONOR.SI ID (P1280)

• Almost all search links return 'not found'.

Pages with VIAF and P271

SELECT DISTINCT ?item ?local_auth_id ?viaf_link ?search_link WHERE {
  ?item wdt:P1280 ?local_auth_id.
  ?item wdt:P31 wd:Q5.
  ?item wdt:P214 ?viaf.
  OPTIONAL {
    ?item p:P1280 ?statement0.
    ?statement0 ps:P1280 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/", STR(?viaf))) AS ?viaf_link)
  BIND(IRI(CONCAT("https://viaf.org/viaf/SIMACOB%7C", STR(?local_auth_id))) AS ?search_link)
} LIMIT 10

Try it!

Vatican Library VcBA ID (P8034)

Pages with VIAF and P8034

SELECT DISTINCT ?item ?local_auth_id ?viaf_link ?search_link WHERE {
  ?item wdt:P8034 ?local_auth_id.
  ?item wdt:P31 wd:Q5.
  ?item wdt:P214 ?viaf.
  OPTIONAL {
    ?item p:P8034 ?statement0.
    ?statement0 ps:P8034 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/", STR(?viaf))) AS ?viaf_link)
  BIND(IRI(CONCAT("https://viaf.org/viaf/BAV%7C", REPLACE(STR(?local_auth_id), "/", "_"))) AS ?search_link)
} LIMIT 10

Try it!

RISM ID (P5504)

Pages with VIAF and P5504

SELECT DISTINCT ?item ?local_auth_id ?viaf_link ?search_link WHERE {
  ?item wdt:P5504 ?local_auth_id.
  ?item wdt:P31 wd:Q5.
  ?item wdt:P214 ?viaf.
  OPTIONAL {
    ?item p:P5504 ?statement0.
    ?statement0 ps:P5504 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/", STR(?viaf))) AS ?viaf_link)
  BIND(IRI(CONCAT("https://viaf.org/viaf/DE633%7C", REPLACE(STR(?local_auth_id), "people/", "pe"))) AS ?search_link)
} LIMIT 10

Try it!

SBN author ID (P396)

Pages with VIAF and P396

SELECT DISTINCT ?item ?local_auth_id ?viaf_link ?search_link WHERE {
  # values ?item {wd:Q123}  # search for specific Q item
  ?item wdt:P396 ?local_auth_id.
  ?item wdt:P31 wd:Q5.
  ?item wdt:P214 ?viaf.
  OPTIONAL {
    ?item p:P396 ?statement0.
    ?statement0 ps:P396 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/", STR(?viaf))) AS ?viaf_link)
  BIND(IRI(CONCAT("https://viaf.org/viaf/ICCU%7C",STR(?local_auth_id))) AS ?search_link)
} LIMIT 10

Try it!

All pages about humans with P396 and without VIAF

SELECT DISTINCT ?item ?local_auth_id ?search_link WHERE {
  ?item wdt:P396 ?local_auth_id.
  FILTER(EXISTS { ?item wdt:P31 wd:Q5. })
  MINUS { ?item p:P214 ?viaf. }
  OPTIONAL {
    ?item p:P396 ?statement0.
    ?statement0 ps:P396 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/ICCU%7C",STR(?local_auth_id))) AS ?search_link)
}

Try it!

CYT/CCS (P10307)

Pages with VIAF and P10307

SELECT DISTINCT ?item ?local_auth_id ?viaf_link ?search_link WHERE {
  # values ?item {wd:Q123}  # search for specific Q item
  ?item wdt:P10307 ?local_auth_id.
  ?item wdt:P31 wd:Q5.
  ?item wdt:P214 ?viaf.
  OPTIONAL {
    ?item p:P10307 ?statement0.
    ?statement0 ps:P10307 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/", STR(?viaf))) AS ?viaf_link)
  BIND(IRI(CONCAT("https://viaf.org/viaf/CYT%7C",STR(?local_auth_id))) AS ?search_link)
} LIMIT 10

Try it!

RILM ID (P9171)

Pages with VIAF and P9171

SELECT DISTINCT ?item ?local_auth_id ?viaf_link ?search_link WHERE {
  # values ?item {wd:Q123}  # search for specific Q item
  ?item wdt:P9171 ?local_auth_id.
  ?item wdt:P31 wd:Q5.
  ?item wdt:P214 ?viaf.
  OPTIONAL {
    ?item p:P9171 ?statement0.
    ?statement0 ps:P9171 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/", STR(?viaf))) AS ?viaf_link)
  BIND(IRI(CONCAT("https://viaf.org/viaf/NYNYRILM%7C",STR(?local_auth_id))) AS ?search_link)
} LIMIT 10

Try it!

Perseus author ID (P7041)

Pages with VIAF and P7041

SELECT DISTINCT ?item ?local_auth_id ?viaf_link ?search_link WHERE {
  # values ?item {wd:Q123}  # search for specific Q item
  ?item wdt:P7041 ?local_auth_id.
  ?item wdt:P31 wd:Q5.
  ?item wdt:P214 ?viaf.
  OPTIONAL {
    ?item p:P7041 ?statement0.
    ?statement0 ps:P7041 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/", STR(?viaf))) AS ?viaf_link)
  BIND(IRI(CONCAT("https://viaf.org/viaf/PERSEUS%7Curn:cite:perseus:author.",STR(?local_auth_id),'.1')) AS ?search_link)
} order by ?local_auth_id LIMIT 20

Try it!

Syriac Biographical Dictionary ID (P6934)

Pages with VIAF and P6934

SELECT DISTINCT ?item ?local_auth_id ?viaf_link ?search_link WHERE {
  # values ?item {wd:Q123}  # search for specific Q item
  ?item wdt:P6934 ?local_auth_id.
  ?item wdt:P31 wd:Q5.
  ?item wdt:P214 ?viaf.
  OPTIONAL {
    ?item p:P6934 ?statement0.
    ?statement0 ps:P6934 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/", STR(?viaf))) AS ?viaf_link)
  BIND(IRI(CONCAT("https://viaf.org/viaf/SRP%7Cperson_",STR(?local_auth_id))) AS ?search_link)
} order by ?local_auth_id LIMIT 20

Try it!

BNMM authority ID (P3788)

Pages with VIAF and P3788

SELECT DISTINCT ?item ?local_auth_id ?viaf_link ?search_link WHERE {
  # values ?item {wd:Q123}  # search for specific Q item
  ?item wdt:P3788 ?local_auth_id.
  ?item wdt:P31 wd:Q5.
  ?item wdt:P214 ?viaf.
  OPTIONAL {
    ?item p:P3788 ?statement0.
    ?statement0 ps:P3788 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/", STR(?viaf))) AS ?viaf_link)
  BIND(IRI(CONCAT("https://viaf.org/viaf/ARBABN%7C",STR(?local_auth_id))) AS ?search_link)
} LIMIT 10

Try it!

NDL Authority ID (P349)

Pages with VIAF and P349

SELECT DISTINCT ?item ?local_auth_id ?viaf_link ?search_link WHERE {
  # values ?item {wd:Q123}  # search for specific Q item
  ?item wdt:P349 ?local_auth_id.
  ?item wdt:P31 wd:Q5.
  ?item wdt:P214 ?viaf.
  OPTIONAL {
    ?item p:P349 ?statement0.
    ?statement0 ps:P349 _:anyValueP245;
      wikibase:rank ?rank.
  }
  FILTER(?rank != wikibase:DeprecatedRank)
  BIND(IRI(CONCAT("https://viaf.org/viaf/", STR(?viaf))) AS ?viaf_link)
  BIND(IRI(CONCAT("https://viaf.org/viaf/NDL%7C",STR(?local_auth_id))) AS ?search_link)
} LIMIT 10

Try it!