Edits by timestamp

SQL

SELECT CONCAT('[[',page_title,']]') AS Page, 
          CONCAT(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),' (UTC)'
          ) AS DateTime,    
       CONCAT('[[Special:Diff/',rev_id,']]') AS Diff, CONCAT('[[User:',actor_name,']]') AS User, 
       (CASE WHEN rev_minor_edit = 0 THEN 'N' ELSE 'Y' END)  AS Minor
FROM page
JOIN revision ON rev_page = page_id
JOIN actor_revision on actor_id=rev_actor
join revision_comment_temp on revcomment_rev = rev_id
WHERE rev_timestamp BETWEEN '201801010417' AND '201801010420'
AND page_namespace = 0
ORDER BY rev_timestamp ASC
LIMIT 10;
SQL

Checking query status...
