New items created by a user in a timespan

SQL

USE wikidatawiki_p;
SELECT page_title#, page_len, rev_timestamp
FROM revision r
JOIN page on rev_page = page_id/*
WHERE r.rev_timestamp > '20170523235959'
#AND r.rev_timestamp < '20170713235959'
AND r.rev_user_text = 'Jura1'#'GZWDer (flood)'
and page_id in (SELECT pl_from FROM pagelinks WHERE pl_title='Q4167836')*/
/**/
WHERE r.rev_timestamp > '20170810235959'#'20170701235959'
#AND r.rev_timestamp < '20170716235959'
AND r.rev_user_text = 'JAnDbot'
AND page_is_redirect = 0 AND page_namespace = 0

AND r.rev_parent_id = 0
and page_len < 3300#BETWEEN 500 AND 1000#< 1000#

SQL

Checking query status...