query-0197f0993f14df5da7a3712e0988d5a6
Newest words
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 pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX target: <http://www.wikidata.org/entity/Q9035>
SELECT
(xsd:date(MIN(?publication_datetime)) AS ?publication_date)
?lexeme
(SAMPLE(?lemma) AS ?lexemeLabel)
(CONCAT("#lexeme/", SUBSTR(STR(?lexeme), 32)) AS ?lexemeUrl)
WHERE {
?lexeme dct:language target: ;
wikibase:lemma ?lemma ;
(wdt:P5323 / wdt:P577)| (p:P5323 / pq:P577) ?publication_datetime .
}
GROUP BY ?lexeme
ORDER BY DESC(?publication_date)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?lemma"):::projected
v2("?lexeme"):::projected
v5("?lexemeLabel")
v6("?lexemeUrl")
v5("?publication_date")
v4("?publication_datetime")
a1((" "))
a2((" "))
c2([http://www.wikidata.org/entity/Q9035]):::iri
v2 --"dct:language"--> c2
v2 --"wikibase:lemma"--> v3
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
v2 --"p:P5323"--> a2
a2 --"p:qualifier/P577"--> v4
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v2 --"p:direct/P5323"--> a1
a1 --"p:direct/P577"--> v4
end
union0r <== or ==> union0l
end
bind2[/"http://www.w3.org/2001/XMLSchema#date()"/]
null --o bind2
bind2 --as--o v5
bind3[/"sample(?lemma)"/]
v3 --o bind3
bind3 --as--o v5
bind4[/"concat('#lexeme/',substring(str(?lexeme),'32^^xsd:integer'))"/]
v2 --o bind4
bind4 --as--o v6