Deleted or moved cats on Commons at given date

SQL

USE commonswiki_p;
SET @date = '20170501';
(SELECT CONCAT('# [[:Category:', REPLACE(log_title,'_',' '), ']]') AS catname FROM logging
WHERE log_namespace = 14
AND NOT EXISTS (SELECT 1 FROM page WHERE page_title = log_title AND page_namespace = 14) #not recreated
AND SUBSTR(log_timestamp, 1, 8) = @date
AND log_type = 'delete' AND log_action = 'delete'
AND log_title NOT LIKE 'Images_from_the_Geograph_British_Isles_project_needing_categories%'
) UNION
(SELECT CONCAT('# [[:Category:', REPLACE(log_title,'_',' '), ']]') AS catname FROM logging
WHERE log_namespace = 14
AND SUBSTR(log_timestamp, 1, 8) = @date
AND log_type = 'move'
);

SQL

Checking query status...