Fork of Untitled query #32270 by SQL
This query is marked as a draft This query has been published by SQL.

SQL

AخA
 
SELECT Concat("[[user_talk:", page_title, "]]") AS page, 
       user_name                                AS "protecting admin", 
       comment_text                             AS reason, 
       log_timestamp                            AS "set date", 
       pr_expiry                                AS expiration 
FROM   page_restrictions 
       JOIN page 
         ON pr_page = page_id 
       JOIN logging_userindex 
         ON log_title = page_title 
            AND log_namespace = page_namespace 
       JOIN comment 
         ON log_comment_id = comment_id 
       JOIN user 
         ON log_user = user_id 
WHERE  log_namespace = 3 
       AND pr_type = "edit" 
       AND pr_level = "sysop" 
GROUP  BY page_title 
ORDER  BY page_title DESC;
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
All SQL code is licensed under CC0 License.

Checking query status...