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.