Querying: Difference between revisions

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 ==