query-d800dee029e3f701549f3cb8e38bd914

rq turtle/ttl

Rowing persons with notability issues

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
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 ?item ?itemLabel ?itemDescription ?statements WHERE {
   {
  SELECT DISTINCT ?item WHERE {
    ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 .
  }
}.
  ?item wikibase:sitelinks 0; wikibase:identifiers 0; wikibase:statements ?statements .
  MINUS { [] ?backlink ?item }
  OPTIONAL { ?item ?p [ prov:wasDerivedFrom [ ?pr [] ] ] . FILTER(?pr NOT IN (pr:P143, pr:P3452)) }
  FILTER(!BOUND(?p)) .
  MINUS { ?item wdt:P973|wdt:P1343 [] }
  SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?backlink") v3("?item"):::projected v1("?p") v2("?pr") v4("?statements"):::projected a3((" ")) a5((" ")) a1((" ")) a2((" ")) a6((" ")) a4((" ")) a7((" ")) c17(["en"]):::literal c8(["0^^xsd:integer"]):::literal c15(["bd:serviceParam"]):::iri c6(["wd:Q26270618"]):::iri f0[["not bound(?p)"]] f0 --> v1 v3 --"p:P106"--> a1 a1 --"p:statement/P106"--> a2 a2 --"p:direct/P279"--> c6 v3 --"wikibase:sitelinks"--> c8 v3 --"wikibase:identifiers"--> c8 v3 --"wikibase:statements"--> v4 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; a3 -->v5--> v3 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; a4 -->v2--> a5 a6 -."prov:wasDerivedFrom".-> a4 v3 -->v1--> a6 end subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v3 --"p:direct/P1343"--> a7 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v3 --"p:direct/P973"--> a7 end union0r <== or ==> union0l end end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c15 --"wikibase:language"--> c17 end