Linter signature check

SQL

-- ; sql --cluster=analytics enwiki
/* Checks nickname and fancysig fields in a users preferences.  Accounts matching
 * any banned code can be notified by bot or manually.  More sophisticated checks,
 * like a text length limit, can be done with REGEXP.
 */
SELECT user_name AS "User", user_editcount AS "Edits", nick.up_value AS "Signature"
FROM user
JOIN user_properties AS fancy ON fancy.up_user=user_id AND fancy.up_property="fancysig"
JOIN user_properties AS nick  ON  nick.up_user=user_id AND  nick.up_property="nickname"
LEFT JOIN ipblocks_ipindex    ON ipb_user=user_id
/* User is not blocked */
WHERE ipb_user IS NULL
/* User edited a talk page in last 30 days */
AND user_name IN (SELECT DISTINCT rc_user_text FROM recentchanges WHERE
    rc_namespace IN (1, 3, 4, 5, 7, 9, 11, 13, 15, 101, 109, 119, 447, 711, 829, 2301, 2303)
)
/* No unsubst'ed templates [[WP:SIG#NT]]; No images [[WP:SIGIMAGE]]; [[WP:SIGAPP]] */
AND nick.up_value REGEXP
    "(?i)[{][{](?!\\s*SUBST:)|\\[\\[(FILE|IMAGE):|<(BR|FONT)[^<>]*>"
SQL

Checking query status...
