SELECT count(*) AS retired_reregister_count FROM admin_fallback_log afl INNER JOIN dot_tools dt ON dt.code = afl.dot_code WHERE dt.status = 'retired' AND afl.reason ILIKE '%register%' AND afl.created_at > NOW() - INTERVAL '24 hours'