Querying: Difference between revisions

Line 78: Line 78:
  ORDER BY desc(?count)
  ORDER BY desc(?count)


===How many kazas between 1800 and 1900===
===Number of kazas between 1800 and 1900===
Not working yet. Thanks to [https://stackoverflow.com/users/7879193/stanislav-kralin Stanislav Kralin] for [https://stackoverflow.com/questions/75137894/counting-items-over-time-using-sparql help]. [ run]
*This query is not working yet.* The query below returns the number of vilayets between 1750 and 1760. Thanks to [https://stackoverflow.com/users/7879193/stanislav-kralin Stanislav Kralin] for [https://stackoverflow.com/questions/75137894/counting-items-over-time-using-sparql help]. [ run]


PREFIX og: <https://ottgaz.org/entity/>
PREFIX ogs: <https://ottgaz.org/entity/statement/>
PREFIX ogv: <https://ottgaz.org/value/>
PREFIX ogt: <https://ottgaz.org/prop/direct/>
PREFIX ogp: <https://ottgaz.org/prop/>
PREFIX ogps: <https://ottgaz.org/prop/statement/>
PREFIX ogpq: <https://ottgaz.org/prop/qualifier/>
  PREFIX wd: <http://www.wikidata.org/entity/>
  PREFIX wd: <http://www.wikidata.org/entity/>
  PREFIX wdt: <http://www.wikidata.org/prop/direct/>
  PREFIX wdt: <http://www.wikidata.org/prop/direct/>
  SELECT ?number (count(*) as ?count) WHERE
  SELECT ?number (count(*) as ?count) {
  {
  SERVICE <https://query.wikidata.org/sparql> {
  ?kaza ogt:P15 og:Q3.
?year wdt:P31 wd:Q21199 ; wdt:P1181 ?number
  ?kaza ogp:P15 ?statement.
FILTER (?number >= 1750  && ?number <= 1760)
  ?statement ogps:P15 og:Q3.
  }
  ?vilayet ogt:P15 og:Q5.
  ?vilayet ogp:P15 ?statement.
  ?statement ogps:P15 og:Q5.
  ?statement ogpq:P7 ?starttime.
  ?statement ogpq:P7 ?starttime.
  OPTIONAL{?statement ogpq:P8 ?endtime.}
  OPTIONAL{?statement ogpq:P8 ?endtime.}
  OPTIONAL{?statement ogpq:P22 ?endtime.}
  OPTIONAL{?statement ogpq:P22 ?endtime.}
    SERVICE <https://query.wikidata.org/sparql> {
?year wdt:P6 wd:Q15677 ; wdt:P24 ?number .
  }
  BIND (YEAR(?starttime) AS ?year1)
  BIND (YEAR(?starttime) AS ?year1)
  BIND (YEAR(COALESCE(?endtime, NOW())) AS ?year2)
  BIND (YEAR(COALESCE(?endtime, NOW())) AS ?year2)
FILTER (?number >= 1800  && ?number <= 1900)
  FILTER (?number >= ?year1 && ?number <= ?year2)
  FILTER (?number >= ?year1 && ?number <= ?year2)
  }
  }