SELECTSQL = """
    SELECT subaccount_id FROM subaccount
    WHERE 1 AND last_updated < CURDATE()
    ORDER BY subaccount_id asc LIMIT {offset}, {limit}
    """

UPDATESQL = 'UPDATE subaccount SET last_updated = NOW() WHERE subaccount_id = {subaccount_id}'