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("∑ ") 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, "∑ ") AS ?BeforeString)
BIND (STRBEFORE(?BeforeString, ?p) AS ?AfterString)
BIND (IF(CONTAINS(?r1, ?p), xsd:integer(?AfterString), -1) AS ?count)
FILTER (?count > 0 )
}