Querying: Difference between revisions

Querying (view source)

Revision as of 13:47, 18 January 2023

243 bytes removed , 1 year ago

→‎How many kazas between 1800 and 1900

Will

Bureaucrats, Administrators

80,516

edits

@@ Line 78: / Line 78: @@
   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 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.
   OPTIONAL{?statement ogpq:P8 ?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(COALESCE(?endtime, NOW())) AS ?year2)
- FILTER (?number >= 1800  && ?number <= 1900)
   FILTER (?number >= ?year1 && ?number <= ?year2)
   }