Deletion log - Quarry

SQL

USE frwiki_p;
SELECT CONCAT('#[[file:',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 = 6 and log_title like "%undgau%"#Sundau CoA
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...
