"""Select access token based on given label id."""
SELECT_ACCESS_TOKEN_ALW = """
SELECT
    vat.oauth_token as access_token,
    vat.user_id,
    vat.user_type,
    vat.client_id,
    vc.redirect_uri
FROM vectorapi_access_tokens vat
    INNER JOIN vectorapi_clients vc ON vc.client_id = vat.client_id
    INNER JOIN vend_contact vcont ON vcont.id = vat.user_id
    INNER JOIN vendor v ON v.vendor_id = vcont.vendor_id
WHERE
    v.vendor_id = {vendor_id}
    AND vcont.master = 'Y';
"""