query-4780afa87919ce0fec1df77ab8735663
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?occ ?occLabel (URI(CONCAT("https://www.wikidata.org/wiki/Special:Search/haswbstatement:P106=",?itemId)) AS ?fix)
WHERE {
?item wdt:P8034 ?id .
?item wdt:P106 ?occ .
MINUS { ?occ wdt:P279 ?sub . }
BIND(REPLACE(STR(?occ), "http://www.wikidata.org/entity/","") AS ?itemId)
SERVICE wikibase:label { bd:serviceParam wikibase:language "it,en,de,es,fr". }
}
ORDER BY ?occLabel
Query found at
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/Queries
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/sandbox
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v7("?fix")
v3("?id")
v2("?item")
v6("?itemId"):::projected
v4("?occ"):::projected
v1("?occLabel"):::projected
v5("?sub")
c5(["bd:serviceParam"]):::iri
c7(["it,en,de,es,fr"]):::literal
v2 --"wdt:P8034"--> v3
v2 --"wdt:P106"--> v4
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v4 --"wdt:P279"--> v5
end
bind1[/"replace(str(?occ),'http://www.wikidata.org/entity/','')"/]
v4 --o bind1
bind1 --as--o v6
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c5 --"wikibase:language"--> c7
end
bind2[/"concat('https://www.wikidata.org/wiki/Special:Search/haswbstatement:P106=',?itemId)"/]
v6 --o bind2
bind2 --as--o v7