SELECT DISTINCT
Item_Table.IItemID AS ItemID AS customer_pk,
Item_Table.SFullDescription AS description,
Category.ICatNodeID AS category,

Item_Table.SMainBarcode AS attributes__MainBarcode,
Item_Table.BCoreRange AS attributes__CoreRange,
Item_Table.SLabelDescription AS attributes__LabelDescription,
Item_Table.CRetailValue AS attributes__RetailValue,
price.ILocationID AS attributes__PriceTypeID,
price.DTStart,
price.DTFinish,
price.BExpired AS attributes__Expired,
price.CSellInc AS attributes__SellInc,
price.DTLastModified
stk.ILocationID AS attributes__LocationID,
stk.DSoH AS attributes__SoH,
stk.DHoldSoH AS attributes__HoldSoH,
stk.IOnOrder AS attributes__OnOrder,
stk.BStocked AS attributes__Stocked,
stk.ISellMethodID AS attributes__SellMethodID,
stk.DTLastModified,
stk.ILastModifiedUserID AS attributes__LastModifiedUserID,
stk.ILastModifiedRoleID AS attributes__LastModifiedRoleID
location.SDescription AS attributes__LocDescription,
location.SLocationCode AS attributes__LocationCode,
loc2.ILocationID AS attributes__TargetStoreID,
loc2.SLocationCode AS attributes__TargetStore,
Brand.SDescription AS attributes__BrandDescription,
Manufacturer.ISupplierID AS attributes__SupplierID,
Manufacturer.SSupplierName AS attributes__SupplierName
Merchandise.SDescription AS attributes__MerchandiseDescription,
Range.SDescription AS attributes__RangeDescription,
Range.SRangeCode AS attributes__RangeCode,
SIZE.SDescription AS attributes__SizeDescription,
SubRange.SDescription AS attributes__SubRangeDescription,
Variety.SDescription AS attributes__VarietyDescription,