query-b643f91a4a0bce852bf0156bdd8acb44
TODO
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 bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?Android ?Linux ?MS_Windows ?PS3 ?MacOS ?Xbox360 ?Xbox WHERE
{
{
SELECT ?item WHERE
{
?item wdt:P31 wd:Q7889 .
} LIMIT 10 } optional {?item wdt:P400 ?Q94 . filter (?Q94=wd:Q94) }
optional {?item wdt:P400 ?Q388 . filter (?Q388=wd:Q388) }
optional {?item wdt:P400 ?Q1406 . filter (?Q1406=wd:Q1406) }
optional {?item wdt:P400 ?Q10683 . filter (?Q10683=wd:Q10683) }
optional {?item wdt:P400 ?Q14116 . filter (?Q14116=wd:Q14116) }
optional {?item wdt:P400 ?Q48263 . filter (?Q48263=wd:Q48263) }
optional {?item wdt:P400 ?Q132020 . filter (?Q132020=wd:Q132020) }
bind(if(bound(?Q94),1,"") as ?Android)
bind(if(bound(?Q388),1,"") as ?Linux)
bind(if(bound(?Q1406),1,"") as ?MS_Windows)
bind(if(bound(?Q10683),1,"") as ?PS3)
bind(if(bound(?Q14116),1,"") as ?MacOS)
bind(if(bound(?Q48263),1,"") as ?Xbox360)
bind(if(bound(?Q132020),1,"") as ?Xbox)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,en". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v9("?Android"):::projected
v10("?Linux"):::projected
v11("?MS_Windows"):::projected
v13("?MacOS"):::projected
v12("?PS3"):::projected
v4("?Q10683")
v1("?Q132020")
v5("?Q1406")
v3("?Q14116")
v6("?Q388")
v2("?Q48263")
v7("?Q94")
v15("?Xbox"):::projected
v14("?Xbox360"):::projected
v8("?item"):::projected
c14(["en,en"]):::literal
c12(["bd:serviceParam"]):::iri
c9(["wd:Q7889"]):::iri
v8 --"wdt:P31"--> c9
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P400".-> v7
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P400".-> v6
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P400".-> v5
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P400".-> v4
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P400".-> v3
end
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P400".-> v2
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P400".-> v1
end
bind0[/"if(bound(?Q94),'1^^xsd:integer','')"/]
v7 --o bind0
bind0 --as--o v9
bind1[/"if(bound(?Q388),'1^^xsd:integer','')"/]
v6 --o bind1
bind1 --as--o v10
bind2[/"if(bound(?Q1406),'1^^xsd:integer','')"/]
v5 --o bind2
bind2 --as--o v11
bind3[/"if(bound(?Q10683),'1^^xsd:integer','')"/]
v4 --o bind3
bind3 --as--o v12
bind4[/"if(bound(?Q14116),'1^^xsd:integer','')"/]
v3 --o bind4
bind4 --as--o v13
bind5[/"if(bound(?Q48263),'1^^xsd:integer','')"/]
v2 --o bind5
bind5 --as--o v14
bind6[/"if(bound(?Q132020),'1^^xsd:integer','')"/]
v1 --o bind6
bind6 --as--o v15
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c12 --"wikibase:language"--> c14
end