select
m_id,
m_username,
m_identity,
m_email,
m_password,
m_comment,
m_sex,
m_age,
m_capture,
m_camera,
case when m_alivetime > 1337525279 then m_status else 'off' end m_status,
m_user,
m_updatetime,
m_registeredtime,
m_alivetime
from
vp_registrations
where
m_username = '' order by m_id