Ph8Adjustments_Short_ios14-16_Clbt-PA.txt

SELECT
ZUNMANAGEDADJUSTMENT.ZADJUSTMENTTIMESTAMP,
ZASSET.ZDATECREATED,
ZASSET.ZADDEDDATE,
ZADDITIONALASSETATTRIBUTES.ZEXIFTIMESTAMPSTRING,
ZASSET.ZHASADJUSTMENTS,
ZADDITIONALASSETATTRIBUTES.ZEDITORBUNDLEID,
ZUNMANAGEDADJUSTMENT.ZEDITORLOCALIZEDNAME,
ZUNMANAGEDADJUSTMENT.ZADJUSTMENTFORMATIDENTIFIER,
ZASSET.ZDIRECTORY,
ZASSET.ZFILENAME,
ZADDITIONALASSETATTRIBUTES.ZORIGINALFILENAME,
ZASSET.Z_PK,
ZADDITIONALASSETATTRIBUTES.Z_PK
FROM ZASSET
    LEFT JOIN ZADDITIONALASSETATTRIBUTES ON ZADDITIONALASSETATTRIBUTES.Z_PK = ZASSET.ZADDITIONALATTRIBUTES
    LEFT JOIN ZUNMANAGEDADJUSTMENT ON ZADDITIONALASSETATTRIBUTES.ZUNMANAGEDADJUSTMENT = ZUNMANAGEDADJUSTMENT.Z_PK
    LEFT JOIN ZCLOUDMASTER ON ZASSET.ZMASTER = ZCLOUDMASTER.Z_PK	
WHERE ZASSET.ZHASADJUSTMENTS > 0
ORDER BY ZUNMANAGEDADJUSTMENT.ZADJUSTMENTTIMESTAMP