DELETE FROM zz_tmp_SmuckersImages select DISTINCT s.skuid, s.sku, s.skudesc, pk.scc14 as GTIN , c1.filename as img1 , c2.filename as img2 , c3.filename as img3 , c4.filename as img4 , c5.filename as mstrPkgImg , c6.filename as unitPkgImg , c7.filename as subPkgImg from tbl_PRD_Skus s inner join tbl_PRD_AttributeLinks link ON ( link.mstr_attrTypeID = 7 AND link.mstr_attrID = s.skuid AND link.child_attrTypeID = 4 AND link.child_attrID = 2046) left outer join tbl_PRD_Packaging pk on s.skuid = pk.linkid and pk.linkType = 'SKU' left outer join tbl_PRD_ProductImages i1 On s.sku = i1.code and i1.catalogLevel = 'SKU' and i1.ownerid = and i1.fsl_tableCode = left outer join tbl_FSC_Content c1 on c1.contentid = i1.img1_contentid left outer join tbl_PRD_ProductImages i2 On s.sku = i2.code and i2.catalogLevel = 'SKU' and i2.ownerid = and i2.fsl_tableCode = left outer join tbl_FSC_Content c2 on c2.contentid = i2.img2_contentid left outer join tbl_PRD_ProductImages i3 On s.sku = i3.code and i3.catalogLevel = 'SKU' and i3.ownerid = and i3.fsl_tableCode = left outer join tbl_FSC_Content c3 on c3.contentid = i3.img3_contentid left outer join tbl_PRD_ProductImages i4 On s.sku = i4.code and i4.catalogLevel = 'SKU' and i4.ownerid = and i4.fsl_tableCode = left outer join tbl_FSC_Content c4 on c4.contentid = i4.img4_contentid left outer join tbl_PRD_ProductImages i5 On s.sku = i5.code and i5.catalogLevel = 'SKU' and i5.ownerid = and i5.fsl_tableCode = left outer join tbl_FSC_Content c5 on c5.contentid = i5.MstrPkg_ContentID left outer join tbl_PRD_ProductImages i6 On s.sku = i6.code and i6.catalogLevel = 'SKU' and i6.ownerid = and i6.fsl_tableCode = left outer join tbl_FSC_Content c6 on c6.contentid = i6.UnitPkg_ContentID left outer join tbl_PRD_ProductImages i7 On s.sku = i7.code and i7.catalogLevel = 'SKU' and i7.ownerid = and i7.fsl_tableCode = left outer join tbl_FSC_Content c7 on c7.contentid = i7.SubPkg_ContentID where s.ownerid = and s.fsl_tableCode = --and s.gs1_syncdate is not null Order by Sku INSERT INTO zz_tmp_SmuckersImages(SkuID,Sku,SkuDesc,GTIN,img1,img2,img3,img4,mstrPkgImg,unitPkgImg,subPkgImg) VALUES ( , , , , , , , , , , )