query-57da19db0e2a5e5991cc62515209f0ac

rq turtle/ttl

Persons with ULAN, and a reference to RKD in ULAN, but no RKDArtistID

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdtn: <http://www.wikidata.org/prop/direct-normalized/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX dcterms: <http://purl.org/dc/terms/>
      PREFIX bibo: <http://purl.org/ontology/bibo/>

      SELECT ?item ?ulanuri ?rkdartistsid
                  WHERE {
         {
        SELECT ?item ?ulanuri ?rkdartistsid WHERE {
        ?item wdtn:P245 ?ulanuri .
       ?item p:P245 ?statement0.
                                          ?statement0 ps:P245 _:anyValueP245;
                                              wikibase:rank ?rank.
         FILTER(?rank != wikibase:DeprecatedRank)
        MINUS { ?item wdtn:P650 ?rkdartistsid } .
        MINUS { ?item p:P650 ?statement1. ?statement1 (ps:P650) _:anyValueP650. }
        }
      }
         {
        SELECT * {
        SERVICE <http://vocab.getty.edu/sparql.json> {

       SELECT ?ulanuri ?rkdartistsid WHERE {
            ?ulanuri rdf:type <http://vocab.getty.edu/ontology#PersonConcept> .
            ?ulanuri dcterms:source ?source .
            ?source dcterms:isPartOf <http://vocab.getty.edu/ulan/source/2100183444> .
            ?source bibo:locator ?rkdartistsid
            }

        }
      }
      }
      } LIMIT 500

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item"):::projected v1("?rank") v5("?rkdartistsid"):::projected v7("?source") v4("?statement0") v6("?statement1") v3("?ulanuri"):::projected a1((" ")) a2((" ")) c14([http://vocab.getty.edu/ulan/source/2100183444]):::iri c11([http://vocab.getty.edu/ontology#PersonConcept]):::iri f0[["?rank != 'wikibase:DeprecatedRank'"]] f0 --> v1 v2 --"p:direct-normalized/P245"--> v3 v2 --"p:P245"--> v4 v4 --"p:statement/P245"--> a1 v4 --"wikibase:rank"--> v1 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v2 --"p:direct-normalized/P650"--> v5 end subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v2 --"p:P650"--> v6 v6 --"p:statement/P650"--> a2 end subgraph s1["http://vocab.getty.edu/sparql.json"] style s1 stroke-width:4px; v3 --"a"--> c11 v3 --http://purl.org/dc/terms/source--> v7 v7 --http://purl.org/dc/terms/isPartOf--> c14 v7 --http://purl.org/ontology/bibo/locator--> v5 end