drafts restored in last 7 days

This query is marked as a draft This query has been published by DreamRimmer.

SQL

SELECT 
    log_id, 
    log_type, 
    log_action, 
    log_timestamp, 
    CASE 
        WHEN log_namespace = 2 THEN CONCAT('User:', log_title)
        WHEN log_namespace = 118 THEN CONCAT('Draft:', log_title)
        ELSE log_title
    END AS page_title,
    actor_name
FROM logging
JOIN actor ON logging.log_actor = actor.actor_id
WHERE log_type = 'delete'
  AND log_action = 'restore'
  AND log_namespace IN (2, 118)
  AND log_timestamp > DATE_FORMAT(NOW() - INTERVAL 1 DAY, '%Y%m%d%H%i%s')
ORDER BY log_timestamp DESC
LIMIT 100;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...