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

SQL

AخA
 
select concat( "[[User_talk:", page_title, "]]") as user, concat( "[[Template:", tl_title, "|", tl_title, "]]") as template, rev_timestamp as timestamp from templatelinks join page on tl_from = page_id join revision on rev_id = page_latest WHERE tl_title LIKE "Unblock%" AND tl_title NOT LIKE "%eviewed" AND tl_title != "Unblock" AND  tl_title != "Unblock_on_hold" AND tl_title != "Unblock-auto_declined" AND tl_title != "Unblock-ip_declined" AND tl_title != "Unblock-auto_on_hold" AND tl_title != "Unblock-spamun" AND tl_title != "Unblock-un" AND tl_title != "Unblock-spamun_declined" AND tl_title != "Unblock-un_declined" AND tl_title != "Unblock-softer"  AND tl_title != "Unblock-l_abuse"  AND tl_title != "Unblockabuse" AND tl_title != "Unblock-un_on_hold" AND tl_title != "Unblock_declined" AND tl_from_namespace = 3 and tl_namespace = 10 group by tl_from order by rev_timestamp desc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...