query-924f03c0e542bf42a43655622987c776
could be a date (if known) or a novalue. (P2669)discontinued date The Operating systems developed by Microsoft
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?os
(SAMPLE(COALESCE(?en_label, ?any_label)) as ?label)
(SAMPLE(?based_on_label) as ?based_on)
(SAMPLE(?logo) as ?logo)
(SAMPLE(?image) as ?image)
(GROUP_CONCAT(DISTINCT ?packaging_system_label ; separator=", ") as ?packaging_system)
(GROUP_CONCAT(DISTINCT ?developer_label ; separator=", ") as ?developer)
(GROUP_CONCAT(DISTINCT ?license_label ; separator=", ") as ?license)
(SAMPLE(?inception) as ?inception)
(GROUP_CONCAT(DISTINCT ?origin_label ; separator=", ") as ?origin)
#(SAMPLE(?website) as ?website)
WHERE {
?os wdt:P31 wd:Q9135.
OPTIONAL{?os rdfs:label ?en_label. FILTER(LANG(?en_label) = "en")} OPTIONAL {?os rdfs:label ?any_label}
OPTIONAL{?os wdt:P144 ?based_on. ?based_on rdfs:label ?based_on_label. FILTER(LANG(?based_on_label) = "en")}
OPTIONAL{?os wdt:P154 ?logo}
OPTIONAL{?os wdt:P18 ?image}
OPTIONAL{?os wdt:P3033 ?packaging_system. ?packaging_system rdfs:label ?packaging_system_label. FILTER(LANG(?packaging_system_label) = "en")}
OPTIONAL{?os wdt:P275 ?license. ?license rdfs:label ?license_label. FILTER(LANG(?license_label) = "en")}
OPTIONAL{?os wdt:P178 ?developer.
?developer rdfs:label ?developer_label.
FILTER(LANG(?developer_label) = "en").
}
OPTIONAL{?os wdt:P571 ?inception}
OPTIONAL{?os wdt:P495 ?origin. ?origin rdfs:label ?origin_label. FILTER(LANG(?origin_label) = "en")}
OPTIONAL{?os wdt:P856 ?website}
FILTER(SUBSTR(str(?developer_label), 1, 9) = "Microsoft").
}
GROUP BY ?os ORDER BY ?label
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v9("?any_label"):::projected
v19("?based_on")
v6("?based_on_label"):::projected
v19("?developer")
v2("?developer_label"):::projected
v7("?en_label"):::projected
v19("?image"):::projected
v19("?inception"):::projected
v19("?label")
v19("?license")
v4("?license_label"):::projected
v19("?logo"):::projected
v19("?origin")
v3("?origin_label"):::projected
v8("?os"):::projected
v19("?packaging_system")
v5("?packaging_system_label"):::projected
v18("?website")
c6(["wd:Q9135"]):::iri
f0[["substring(str(?developer_label),'1^^xsd:integer','9^^xsd:integer') = 'Microsoft'"]]
f0 --> v2
v8 --"wdt:P31"--> c6
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v8 -."rdfs:label".-> v7
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v8 -."rdfs:label".-> v9
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P144".-> v19
v19 --"rdfs:label"--> v6
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P154".-> v19
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P18".-> v19
end
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P3033".-> v19
v19 --"rdfs:label"--> v5
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P275".-> v19
v19 --"rdfs:label"--> v4
end
subgraph optional7["(optional)"]
style optional7 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P178".-> v19
v19 --"rdfs:label"--> v2
end
subgraph optional8["(optional)"]
style optional8 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P571".-> v19
end
subgraph optional9["(optional)"]
style optional9 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P495".-> v19
v19 --"rdfs:label"--> v3
end
subgraph optional10["(optional)"]
style optional10 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wdt:P856".-> v18
end
bind10[/"sample(?en_label?any_label)"/]
v7 --o bind10
v9 --o bind10
bind10 --as--o v19
bind11[/"sample(?based_on_label)"/]
v6 --o bind11
bind11 --as--o v19
bind12[/"sample(?logo)"/]
v19 --o bind12
bind12 --as--o v19
bind13[/"sample(?image)"/]
v19 --o bind13
bind13 --as--o v19
bind14[/"?packaging_system_label"/]
v5 --o bind14
bind14 --as--o v19
bind15[/"?developer_label"/]
v2 --o bind15
bind15 --as--o v19
bind16[/"?license_label"/]
v4 --o bind16
bind16 --as--o v19
bind17[/"sample(?inception)"/]
v19 --o bind17
bind17 --as--o v19
bind18[/"?origin_label"/]
v3 --o bind18
bind18 --as--o v19