"""Select all distinct artists in a single label."""
SELECT_ALL_DISTINCT_ARTISTS_IN_LABEL_RESUMED = """
  SELECT DISTINCT {field_name}
  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});
"""