query-e81a8145546b2a3482fbd36fe1828e46
TODO
Use at
- https://query.wikidata.org/sparql
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 bd: <http://www.bigdata.com/rdf#>
#defaultView:Graph
select ?person ?linkedPerson ?linkedPersonLabel ?type ?personLabel (?type as ?edgeLabel) {
?person wdt:P937 wd:Q641;
wdt:P106 ?activity .
values ?activity {
wd:Q175151 wd:Q1229025 wd:Q998550 wd:Q2516866 wd:Q40881196
}
?person wdt:P2032|wdt:P570 ?datafine .
{ ?person wdt:P1327 ?linkedPerson . bind("business partner" as ?type) } union
{ ?person wdt:P22 ?linkedPerson . bind("father" as ?type) } union
{ ?person wdt:P23 ?linkedPerson . bind("mother" as ?type) } union
{ ?person wdt:P40 ?linkedPerson . bind("son" as ?type) } union
{ ?person wdt:P26 ?linkedPerson . bind("partner" as ?type) }
FILTER ("1850-01-01"^^xsd:date > ?datafine)
SERVICE wikibase:label { bd:serviceParam wikibase:language "it,en" . }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?activity")
v1("?datafine")
v6("?edgeLabel")
v4("?linkedPerson"):::projected
v2("?person"):::projected
v6("?type"):::projected
c3(["wd:Q641"]):::iri
c13(["bd:serviceParam"]):::iri
c15(["it,en"]):::literal
f0[["'1850-01-01^^xsd:date' > ?datafine"]]
f0 --> v1
v2 --"wdt:P937"--> c3
v2 --"wdt:P106"--> v4
bind1[/VALUES ?activity/]
bind1-->v4
bind10(["wd:Q175151"])
bind10 --> bind1
bind11(["wd:Q1229025"])
bind11 --> bind1
bind12(["wd:Q998550"])
bind12 --> bind1
bind13(["wd:Q2516866"])
bind13 --> bind1
bind14(["wd:Q40881196"])
bind14 --> bind1
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
v2 --"wdt:P570"--> v1
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v2 --"wdt:P2032"--> v1
end
union0r <== or ==> union0l
end
subgraph union1[" Union "]
subgraph union1l[" "]
style union1l fill:#abf,stroke-dasharray: 3 3;
subgraph union2[" Union "]
subgraph union2l[" "]
style union2l fill:#abf,stroke-dasharray: 3 3;
subgraph union3[" Union "]
subgraph union3l[" "]
style union3l fill:#abf,stroke-dasharray: 3 3;
subgraph union4[" Union "]
subgraph union4l[" "]
style union4l fill:#abf,stroke-dasharray: 3 3;
v2 --"wdt:P26"--> v4
bind2[/"'partner'"/]
bind2 --as--o v6
end
subgraph union4r[" "]
style union4r fill:#abf,stroke-dasharray: 3 3;
v2 --"wdt:P40"--> v4
bind3[/"'son'"/]
bind3 --as--o v6
end
union4r <== or ==> union4l
end
end
subgraph union3r[" "]
style union3r fill:#abf,stroke-dasharray: 3 3;
v2 --"wdt:P23"--> v4
bind4[/"'mother'"/]
bind4 --as--o v6
end
union3r <== or ==> union3l
end
end
subgraph union2r[" "]
style union2r fill:#abf,stroke-dasharray: 3 3;
v2 --"wdt:P22"--> v4
bind5[/"'father'"/]
bind5 --as--o v6
end
union2r <== or ==> union2l
end
end
subgraph union1r[" "]
style union1r fill:#abf,stroke-dasharray: 3 3;
v2 --"wdt:P1327"--> v4
bind6[/"'business partner'"/]
bind6 --as--o v6
end
union1r <== or ==> union1l
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c13 --"wikibase:language"--> c15
end
bind7[/"?type"/]
v6 --o bind7
bind7 --as--o v6