I want to get all Images not used by current ItemID. The this subquery but it also always returns
duplicate Images:
EDITED
select Images.ImageID, Images.ItemStatus, Images.UserName, Images.Url,
Image_Item.ItemID, Image_Item.ItemID
from Images
left join (select ImageID, ItemID, MAX(DateCreated) x
…