Linter signature check

SQL

-- 2> /dev/null; date; echo '
/* User signature conformance checker
 * Checks nickname and fancysig fields in a users preferences.  Accounts matching
 * any banned code can be notified by bot or manually.  More sphonisticate checks,
 * like a text length limit, can be done with REGEXP.
 *
 * Run time: 15 min <SLOW_OK>
 */
SELECT
  user_name AS "User name",
  user_editcount AS "Edit count",
  EXISTS (SELECT 1 FROM recentchanges WHERE rc_user_text=user_name AND rc_namespace%2=1 LIMIT 1) AS "Active",
  EXISTS (SELECT 1 FROM ipblocks WHERE ipb_user=user_id AND ipb_expiry="infinity") AS "Blocked",
  nick.up_value AS "Signature"
FROM user
JOIN user_properties AS fncy ON fncy.up_user=user_id AND fncy.up_property="fancysig"
JOIN user_properties AS nick ON nick.up_user=user_id AND nick.up_property="nickname"
WHERE /* Use CAST(...) for case-insensitive searches */
   nick.up_value LIKE "%[[Image:%"
OR nick.up_value LIKE "%[[File:%"
OR (nick.up_value LIKE "%{{%" AND CAST(nick.up_value AS CHAR CHARACTER SET utf8)
    COLLATE utf8_general_ci NOT LIKE "%{{subst:%")
HAVING Active=1 and Blocked=0
-- OR nick.up_value LIKE "%<br%"
-- OR nick.up_value LIKE "%<font%" /* <font> is gone in HTML5 */
;-- ' | sql -r enwiki_p; date;
SQL

Checking query status...
