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 "%<font%" /* <font> is gone in HTML5 */
AND user_name IN (SELECT DISTINCT rc_user_text FROM recentchanges WHERE
    rc_namespace IN (1, 3, 5, 7, 9, 11, 13, 15, 101, 109, 119, 447, 711, 829, 2301, 2303)
HAVING Active=1 and Blocked=0
SQL

Checking query status...
