"""Products by ISRC Queries."""

PRODUCTS_BY_ISRC = """
SELECT vw_product.release_id,
    vw_product.display_upc,
    vw_product.distribution_format_id,
    vw_product.product_type_id,
    vw_product.context_type,
    vw_product.upc,
    vw_product.project_id,
    vw_product.vendor_id,
    vw_product.subaccount_id,
    vw_product.product_code,
    vw_product.release_name,
    vw_product.release_status,
    vw_product.release_date,
    vw_product.deletions,
    vw_product.not_for_distribution
FROM vw_product
INNER JOIN track ON track.release_id = vw_product.release_id
WHERE track.isrc=:isrc;
"""