Deletion log - Quarry

SQL

USE hiwiki_p;
SELECT /*CONCAT('#[[{{NS:0}}:',log_title,']]') AS page_title, LEFT(log_timestamp, 8) AS date,*/
log_user_text, count (log_title)#, log_comment
FROM logging
WHERE log_type = 'move'
AND log_action = 'move'
and log_namespace = 0 #and log_title like "%undgau%"
#and LEFT(log_timestamp, 4) = 2016
and log_timestamp between 20160101195058 and 20161217195058
group by log_user_text
#order by log_timestamp desc
#limit 100
/*USE enwiki_p;
SELECT CONCAT('#[[Category:',log_title,']]') AS page_title, LEFT(log_timestamp, 8) AS date, log_user_text, log_comment
FROM logging
WHERE log_type = 'delete'
AND log_action = 'delete'
and log_namespace = 14
#and log_timestamp between 20161204195058 and 20161207195058
order by log_timestamp desc
limit 1600
*/
/*USE enwiki_p;
SELECT CONCAT('#[[User:',log_title,']]') AS page_title, LEFT(log_timestamp, 8) AS date, log_user_text, log_comment
FROM logging
WHERE log_type = 'delete'
AND log_action = 'delete'
and log_namespace = 2 #and log_user_text = "John Doe"
and log_timestamp between 20161204195058 and 20161207195058
order by log_timestamp desc
#limit 600
*/
SQL

Checking query status...
