"""Select all rows in the bulk upload views by Phonofile release id."""
SELECT_BULK_UPLOAD_LABEL_BY_INGESTION_KEY = """
    SELECT DISTINCT orchlabelid
    FROM {snowflake_database}.{snowflake_schema}.{table_name}
    WHERE {ingestion_key_field} = {ingestion_key_value}
    ORDER BY {ingestion_key_field} DESC,
             PRODUCT_CODE DESC,
             VOLUME,
             TRACK_NO
;
"""