Untitled query #26095

SQL

select concat( "[[User_talk:", page_title, "]]") as user, concat( "{{t1|", tl_title, "}}") as template from templatelinks join page on tl_from = page_id 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_declined" AND tl_from_namespace = 3 and tl_namespace = 10 group by tl_from order by tl_title desc;
SQL

Checking query status...
