"""Get track by isrc and track_type."""

GET_DIGITAL_ISRC_BY_TRACK_TYPE = """
    SELECT t.release_id as product_id, t.isrc
    FROM track t
    INNER JOIN releases r ON t.release_id = r.release_id
    INNER JOIN distribution_format df ON df.distribution_format_id = r.distribution_format_id
    WHERE df.context_type = 'digital'
    AND t.track_type = :track_type
    AND t.isrc = :isrc
"""

GET_DIGITAL_ISRC_BY_TRACK_TYPE_AND_VENDOR_ID = """
    SELECT t.id as tuid
    FROM track t
    INNER JOIN vw_product vw_p ON t.release_id = vw_p.release_id
    INNER JOIN distribution_format df ON df.distribution_format_id = vw_p.distribution_format_id
    WHERE df.context_type = 'digital'
    AND t.track_type = :track_type
    AND t.isrc = :isrc
    AND vw_p.vendor_id = :vendor_id
    AND vw_p.subaccount_id IS NULL
"""


GET_DIGITAL_ISRC_BY_TRACK_TYPE_AND_SUBACCOUNT_ID = """
    SELECT t.id as tuid
    FROM track t
    INNER JOIN vw_product vw_p ON t.release_id = vw_p.release_id
    INNER JOIN distribution_format df ON df.distribution_format_id = vw_p.distribution_format_id
    WHERE df.context_type = 'digital'
    AND t.track_type = :track_type
    AND t.isrc = :isrc
    AND vw_p.subaccount_id = :subaccount_id
"""