Find Wordpress users who have logged in at some point, but not within the past year

wp-user-login-time.sql

SELECT u.id, u.user_login, u.user_email, u.user_registered, 
    from_unixtime(
        trim( trailing ';}}' from 
            RIGHT(
                um.meta_value, 
                (LENGTH(um.meta_value) - LOCATE('login',um.meta_value) - 8) 
            )
	    ) 
     ,'%Y-%m-%d') as last_login
FROM wp_users u, wp_usermeta um
WHERE um.user_id = u.id
AND um.meta_key = 'session_tokens'
HAVING last_login < DATE_SUB(NOW(),INTERVAL 1 YEAR)
ORDER BY last_login DESC