User:Faebot/SandboxJ

''' File restorations after deletion by 4060 '''
SELECT COUNT(*), LEFT(log_timestamp, 6) AS ts FROM logging_userindex AS l
WHERE log_type='delete'
AND log_action='restore'
AND NOT log_user = 4060
AND log_timestamp>20180400000000
AND log_timestamp<20180500000000
AND (SELECT COUNT(*) FROM logging_userindex AS u WHERE u.log_user=4060 AND u.log_page = l.log_page AND u.log_action='delete' AND u.log_timestamp<l.log_timestamp)>0
GROUP BY ts;

''' Count of files deleted by 4060 '''
SELECT count(*) from filearchive
WHERE fa_deleted_user = 4060
AND fa_timestamp > 20180100000000;