"""Select all rows in the bulk upload views by orchard label id."""
SELECT_BULK_UPLOAD_TABLE_BY_ORCHLABELID_OMIT_RELEASES = """
SELECT * FROM {snowflake_database}.{snowflake_schema}.{table_name} p
  WHERE p.orchlabelid = {label_id}
    AND p.{ingestion_key_field} NOT IN (
      SELECT DISTINCT PROJECT_CODE
        FROM {snowflake_database}.{snowflake_schema}.{log_table}
      WHERE PROJECT_CODE IS NOT NULL
        AND PROJECT_CODE <> 'NULL'
        and session_id = '{session_id}'
        and ORCHARD_VENDOR_ID = {label_id}
)
ORDER BY {ingestion_key_field}, PRODUCT_CODE, VOLUME, TRACK_NO;
"""