BASE_GET_ASSET_FINALS = """
SELECT DISTINCT
    af.ID,
    af.DURATION
FROM ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.PROJECT AS pj
JOIN ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.RELEASES AS r
    ON pj.PROJECT_ID = r.PROJECT_ID
JOIN ORCHARD_APP_REPORTING_V2.PROD_OWS_ASSETS_OWS_ASSETS.ASSET_UPLOAD AS au
    ON r.RELEASE_ID = au.PRODUCT_ID
JOIN ORCHARD_APP_REPORTING_V2.PROD_OWS_ASSETS_OWS_ASSETS.ASSET_FINAL AS af
    ON au.ID = af.ASSET_UPLOAD_ID
    AND au.IS_CORRECTION = 0
    AND au.DELETED = 0
    AND au.API_VERSION = 2
    AND af.ASSET_TYPE = 'FLAC'
    AND af.DURATION < 600 * 1000
LEFT JOIN ORCHARD_APP_REPORTING_V2.PROD_OWS_ASSETS_OWS_ASSETS.HIVE_SEGMENT AS hs
    ON hs.ASSET_FINAL_ID = af.ID
WHERE
    hs.ASSET_FINAL_ID IS NULL
"""