query-c99c513f7f3e480a1c098bad984eeefe

rq turtle/ttl

check for missing values (Q106007110)Upplands runinskrifter to the page they are mentioned on in some scanned books and would like now to check if I have connected all runeinscriptions ... All the runeinscriptions has a number see sort column and all the books are part of Swedish runeinscriptionsI have connected how to check with SPARQL if all runeinscriptions are connected U 1 - U 1181 and number is missing Question all books are part of this serie(Q106007110)Upplands runinskrifter contains the number(P1261)Scandinavian Runic-text Database ID

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT distinct ?signum ?sort ?item ?itemLabel ?citationLabel ?Litteraturbanken WHERE {
  ?item wdt:P1261 ?signum.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  FILTER(STRSTARTS(?signum, "U "))
  BIND(STRAFTER(?signum, "U ") AS ?sort)
  ?item p:P1343 ?LitteraturbankenP;
    ?Litt ?Litt_value.
  ?Litt_value prov:wasDerivedFrom ?reference.
  ?reference pr:P248 ?citation;
    pr:P5123 ?litturl.
  ?reference pr:P248 ?partof.
  ?partof wdt:P361 wd:Q106007110  # Books in serie Q106007110
  BIND(URI(CONCAT("https://litteraturbanken.se/forfattare/", ?litturl)) AS ?Litteraturbanken)
#  FILTER(xsd:integer(?sort) > 921)
}
ORDER BY (xsd:integer(?sort))

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?Litt") v6("?Litt_value") v11("?Litteraturbanken"):::projected v4("?LitteraturbankenP") v8("?citation") v3("?item"):::projected v9("?litturl") v10("?partof") v7("?reference") v2("?signum"):::projected v4("?sort"):::projected c4(["bd:serviceParam"]):::iri c6(["en"]):::literal c12(["wd:Q106007110"]):::iri f0[["starts-with(?signum,'U ')"]] f0 --> v2 v3 --"p:direct/P1261"--> v2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c4 --"wikibase:language"--> c6 end bind1[/"substring-after(?signum,'U ')"/] v2 --o bind1 bind1 --as--o v4 v3 --"p:P1343"--> v4 v3 -->v5--> v6 v6 --"prov:wasDerivedFrom"--> v7 v7 --"p:reference/P248"--> v8 v7 --"p:reference/P5123"--> v9 v7 --"p:reference/P248"--> v10 v10 --"p:direct/P361"--> c12 bind2[/"concat('https://litteraturbanken.se/forfattare/',?litturl)"/] v9 --o bind2 bind2 --as--o v11