query-0ec9d6e23920406ca0de696e01637812
Imported from target no longer available should only be used for Wikimedia imports; still some hits. (P143)imported from Wikimedia project Needs cleanup;
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
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/>
SELECT ?item ?property ?value ?wikipedia ?wikiurl WHERE {
{
SELECT DISTINCT ?item WHERE {
?item p:P106/ps:P106/wdt:P279* wd:Q26270618 .
}
}.
?property wikibase:claim ?claim; wikibase:statementProperty ?ps .
?item ?claim [ ?ps ?value; prov:wasDerivedFrom [ pr:P143 ?wikipedia ] ] .
OPTIONAL {
?wikipedia wdt:P856 ?wikiurl .
}
OPTIONAL {
?sitelink schema:about ?item; schema:isPartOf ?wikiurl .
}
FILTER(!BOUND(?sitelink)) .
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?claim")
v2("?item"):::projected
v3("?property"):::projected
v5("?ps")
v1("?sitelink")
v6("?value"):::projected
v7("?wikipedia"):::projected
v8("?wikiurl"):::projected
a1((" "))
a2((" "))
a3((" "))
a4((" "))
c4(["wd:Q26270618"]):::iri
f0[["not bound(?sitelink)"]]
f0 --> v1
v2 --"p:P106"--> a1
a1 --"p:statement/P106"--> a2
a2 --"p:direct/P279"--> c4
v3 --"wikibase:claim"--> v4
v3 --"wikibase:statementProperty"--> v5
a3 -->v5--> v6
a4 --"p:reference/P143"--> v7
a3 --"prov:wasDerivedFrom"--> a4
v2 -->v4--> a3
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v7 -."p:direct/P856".-> v8
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v1 -."schema:about".-> v2
v1 --"schema:isPartOf"--> v8
end