Edits by timestamp

SQL

SELECT page_title, (SUBSTRING(rev_timestamp,1,4)+'-'+ SUBSTRING(rev_timestamp,5,2)+'-'+SUBSTRING(rev_timestamp,7,2)+' '+
       SUBSTRING(rev_timestamp,9,2+':'+SUBSTRING(rev_timestamp,11,2)+':'+(SUBSTRING(rev_timestamp,13,2)) as DateTime,
       CONCAT('[[Special:Diff/',rev_id,']]') AS Diff, CONCAT('[[User:',actor_name,']]') AS user, actor_user
FROM page
JOIN revision
ON rev_page = page_id
JOIN actor_revision
on actor_id=rev_actor
WHERE rev_timestamp BETWEEN '2018010112' AND '2018010113'
AND page_namespace = 0
ORDER BY rev_timestamp DESC
LIMIT 10;
SQL

Checking query status...
