User:Daniel Mietchen/TAU people/Query

The following query uses these:
# Stats for people from Tel Aviv University, as per 
# https://www.wikidata.org/wiki/User:Daniel_Mietchen/TAU_people
# which is updated about once a day by ListeriaBot

#defaultView:LineChart
SELECT ?day ?count 
{
  BIND (CONCAT(" items") AS ?p)
#  BIND (CONCAT("&sum; ") AS ?r)
  SERVICE wikibase:mwapi {
      bd:serviceParam wikibase:api "Generator" ; 
                      wikibase:endpoint "www.wikidata.org" ; 
                      mwapi:generator "allpages" ; 
                      mwapi:gapfrom "Daniel_Mietchen/TAU_people" ; 
                      mwapi:gapto "Daniel_Mietchen/TAU_people" ; 
                      mwapi:gapnamespace "2" ; 
                      mwapi:prop "revisions" ; 
                      mwapi:rvprop "content|timestamp" ; 
                      mwapi:rvlimit "1" ; 
                      mwapi:rvuser "ListeriaBot" .
      ?t1 wikibase:apiOutput "revisions/rev[1]/@timestamp" . ?r1 wikibase:apiOutput "revisions/rev[1]/text()" .
  }
  BIND (xsd:dateTime(?t1) AS ?day)
  FILTER (?day >= "2018-12-31T00:00:00Z"^^xsd:dateTime) .
  FILTER (?day <= "2019-02-01T00:00:00Z"^^xsd:dateTime) .
  BIND (STRAFTER(?r1, "&sum; ") AS ?BeforeString) 
  BIND (STRBEFORE(?BeforeString, ?p) AS ?AfterString) 
  BIND (IF(CONTAINS(?r1, ?p), xsd:integer(?AfterString), -1) AS ?count)
  FILTER (?count > 0 )
}
Try it!