zhwiki: check-sign

SQL

SELECT rc_actor, actor_name, actor_user, up2.up_value AS `nickname`
FROM recentchanges
LEFT JOIN actor ON rc_actor = actor_id
LEFT JOIN user_properties AS up1 ON actor_user = up1.up_user AND up1.up_property = 'fancysig'
LEFT JOIN user_properties AS up2 ON actor_user = up2.up_user AND up2.up_property = 'nickname'
WHERE (rc_namespace = 4 OR rc_namespace % 2 = 1)
    AND rc_timestamp > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 7 DAY), '%Y%m%d%H%i%s')
    AND actor_user IS NOT NULL
    AND up1.up_value IS NOT NULL
    AND up2.up_value IS NOT NULL
GROUP BY actor_user
ORDER BY rc_timestamp DESC
SQL

Checking query status...
