query-efe82a1c425992987bc6695b09fbeca6

rq turtle/ttl

Bean49Bot 4) logs • contribs • talk (Bean49 Operator: )xtools • User rights • User rights log • Block log • SUL • new lexemes • new items • contribs • talk (Bean49Bot Add Springer Nature person ID and Springer Nature article ID by moving from exact match property. Task/s: WD:RBOT#Request move P2888 to P10861/P10863 .. (2023-01-19) Discussion: Function details:

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT * WHERE {
  {
    SELECT ?item ?id WHERE {
      ?item wdt:P2888 ?value.
      BIND(STR(?value) AS ?urlstr)
      BIND(SUBSTR(?urlstr, 44 ) AS ?id)
      FILTER(STRSTARTS(?urlstr, "https://scigraph.springernature.com/person."))
    }
    LIMIT 100
  }
  FILTER(NOT EXISTS { ?item wdt:P10861 _:b2. })
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?id"):::projected v1("?item"):::projected v4("?urlstr") v3("?value") a1((" ")) f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P10861"--> e0a1 e0v1("?item"):::projected e0a1((" ")):::projected end f0--EXISTS--> f0e0 f0 --> v1 f0 --> c1 f0 --> a1 v1 --"wdt:P10861"--> a1 f1[["starts-with(?urlstr,'https://scigraph.springernature.com/person.')"]] f1 --> v4 v1 --"wdt:P2888"--> v3 bind2[/"str(?value)"/] v3 --o bind2 bind2 --as--o v4 bind3[/"substring(?urlstr,'44^^xsd:integer')"/] v4 --o bind3 bind3 --as--o v4