SELECT AGILE.ITEM.ITEM_NUMBER,
AGILE.REV.REV_NUMBER,
AGILE.FILES.FILENAME,
AGILE.FILES.CONTENT_URL,
AGILE.REV.LATEST_FLAG
FROM AGILE.ATTACHMENT_MAP
INNER JOIN AGILE.VERSION_FILE_MAP
ON AGILE.ATTACHMENT_MAP.LATEST_VSN = AGILE.VERSION_FILE_MAP.VERSION_ID
INNER JOIN AGILE.FILES
ON AGILE.VERSION_FILE_MAP.FILE_ID = AGILE.FILES.ID
INNER JOIN AGILE.ITEM
ON AGILE.ATTACHMENT_MAP.PARENT_CLASS = AGILE.ITEM.CLASS
AND AGILE.ITEM.ID = AGILE.ATTACHMENT_MAP.PARENT_ID
INNER JOIN AGILE.REV
ON AGILE.REV.ITEM = AGILE.ITEM.ID
WHERE AGILE.ATTACHMENT_MAP.PARENT_ID2 = AGILE.REV.CHANGE
AND AGILE.REV.LATEST_FLAG = 1;