query-8a3e465e235f6a2c6d58d86f6ff9234e

rq turtle/ttl

TODO

Use at

PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?date1 ?date2 ?inter ?evol WHERE {
  wd:Q11728960 p:P1087 [ ps:P1087 ?point1 ; pq:P585 ?date1 ] .
  wd:Q11728960 p:P1087 [ ps:P1087 ?point2 ; pq:P585 ?date2 ] .
  BIND ( (?date2 - ?date1 ) AS ?inter )
  FILTER ( ?inter < 32 && ?inter > 27 ) #consecutive month are 28, 29, 30 or 31 days appart
  BIND ( (?point2 - ?point1) AS ?evol )
}
ORDER BY DESC(?evol)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?date1"):::projected v6("?date2"):::projected v7("?evol"):::projected v7("?inter"):::projected v3("?point1") v5("?point2") a1((" ")) a2((" ")) c5(["wd:Q11728960"]):::iri f0[["?inter < '32^^xsd:integer'?inter > '27^^xsd:integer'"]] f0 --> v7 a1 --"p:statement/P1087"--> v3 a1 --"p:qualifier/P585"--> v4 c5 --"p:P1087"--> a1 a2 --"p:statement/P1087"--> v5 a2 --"p:qualifier/P585"--> v6 c5 --"p:P1087"--> a2 bind1[/"?date2 - ?date1"/] v6 --o bind1 v4 --o bind1 bind1 --as--o v7 bind2[/"?point2 - ?point1"/] v5 --o bind2 v3 --o bind2 bind2 --as--o v7