query-031c73eed8464d0f6fe011cbb659e392
No software quality assurance
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?modified ?floss ?label WHERE {
{
?floss p:P31/ps:P31/wdt:P279* wd:Q506883.
} Union {
?floss p:P31/ps:P31/wdt:P279* wd:Q341.
} Union {
?floss p:P31/ps:P31/wdt:P279* wd:Q1130645.
} Union {
?floss p:P31/ps:P31/wdt:P279* wd:Q19652.
?floss p:P31/ps:P31/wdt:P279* wd:Q7397.
} Union {
?floss p:P31/ps:P31/wdt:P279* wd:Q7397.
?floss wdt:P275 ?licens.
?licens p:P31/ps:P31/(wdt:P31|wdt:P279)* ?kind.
VALUES ?kind { wd:Q196294 wd:Q1156659 }.
}
FILTER NOT EXISTS { ?floss p:P2992 ?qa }
?floss schema:dateModified ?modified
OPTIONAL { ?floss rdfs:label ?label filter (lang(?label) = "en") .}
} ORDER BY DESC(?modified)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?floss"):::projected
v7("?kind")
v4("?label"):::projected
v5("?licens")
v1("?modified"):::projected
v3("?qa")
a1((" "))
a2((" "))
a3((" "))
a4((" "))
a5((" "))
a6((" "))
a7((" "))
a8((" "))
a9((" "))
a10((" "))
a11((" "))
a12((" "))
a13((" "))
a14((" "))
c6(["wd:Q506883"]):::iri
c8(["wd:Q1130645"]):::iri
c10(["wd:Q7397"]):::iri
c9(["wd:Q19652"]):::iri
c7(["wd:Q341"]):::iri
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"p:P2992"--> e0v2
e0v1("?floss"):::projected
e0v2("?qa"):::projected
end
f0--EXISTS--> f0e0
f0 --> v2
f0 --> c1
f0 --> v3
v2 --"p:P2992"--> v3
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
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;
v2 --"p:P31"--> a11
a11 --"p:statement/P31"--> a12
a12 --"p:direct/P279"--> c10
v2 --"p:direct/P275"--> v5
v5 --"p:P31"--> a13
a13 --"p:statement/P31"--> a14
subgraph union4[" Union "]
subgraph union4l[" "]
style union4l fill:#abf,stroke-dasharray: 3 3;
a14 --"p:direct/P279"--> v7
end
subgraph union4r[" "]
style union4r fill:#abf,stroke-dasharray: 3 3;
a14 --"p:direct/P31"--> v7
end
union4r <== or ==> union4l
end
bind1[/VALUES ?kind/]
bind1-->v7
bind10(["wd:Q196294"])
bind10 --> bind1
bind11(["wd:Q1156659"])
bind11 --> bind1
end
subgraph union3r[" "]
style union3r fill:#abf,stroke-dasharray: 3 3;
v2 --"p:P31"--> a7
a7 --"p:statement/P31"--> a8
a8 --"p:direct/P279"--> c9
v2 --"p:P31"--> a9
a9 --"p:statement/P31"--> a10
a10 --"p:direct/P279"--> c10
end
union3r <== or ==> union3l
end
end
subgraph union2r[" "]
style union2r fill:#abf,stroke-dasharray: 3 3;
v2 --"p:P31"--> a5
a5 --"p:statement/P31"--> a6
a6 --"p:direct/P279"--> c8
end
union2r <== or ==> union2l
end
end
subgraph union1r[" "]
style union1r fill:#abf,stroke-dasharray: 3 3;
v2 --"p:P31"--> a3
a3 --"p:statement/P31"--> a4
a4 --"p:direct/P279"--> c7
end
union1r <== or ==> union1l
end
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v2 --"p:P31"--> a1
a1 --"p:statement/P31"--> a2
a2 --"p:direct/P279"--> c6
end
union0r <== or ==> union0l
end
v2 --"schema:dateModified"--> v1
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v2 -."rdfs:label".-> v4
end