80,516
edits
Querying: Difference between revisions
Jump to navigation
Jump to search
→Status count
No edit summary |
|||
| Line 144: | Line 144: | ||
ORDER BY desc(?statementCount) | ORDER BY desc(?statementCount) | ||
LIMIT 100 | LIMIT 100 | ||
=== Sancak seats by vilayet and year === | |||
This shows a tree map with the Ottoman language names of sancak seats within each vilayet in the year 1700. Seat names direct to items. Change the year in line 23. [https://tinyurl.com/2bu4bomk run] | |||
#defaultView:TreeMap | |||
SELECT ?vilayetLabel ?sancakSeat_ota ?sancakSeat | |||
WHERE | |||
{ | |||
?sancak ogp:P15 ?statement. | |||
?statement ogps:P15 og:Q4. | |||
?statement ogpq:P7 ?starttime. | |||
?statement ogpq:P9 ?vilayet. | |||
?sancak ogt:P14 ?sancakSeat. | |||
OPTIONAL{?statement ogpq:P8 ?endtime.} | |||
OPTIONAL{?statement ogpq:P22 ?endtime.} | |||
?sancakSeat rdfs:label ?sancakSeat_ota filter (lang(?sancakSeat_ota) = "ota") | |||
#enter same year twice | |||
FILTER(YEAR(?starttime) <= 1700 && YEAR(?endtime) > 1700) | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | |||
} | |||
== Federated query with Wikidata == | == Federated query with Wikidata == | ||