1 15 PACKAGE_ELIXIRACCESSORY 1 0 10 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 PACKAGE_ELIXIRACCESSORY 2 0 10 -1 xxx -1 xxx -1 xxx -1 xxx
UPDATE dbo._RefScrapOfPackageItem SET Data = i.Dur_L FROM dbo._RefScrapOfPackageItem s with(NOLOCK) JOIN dbo._RefObjCommon r with(NOLOCK) on s.RefItemCodeName = r.CodeName128 JOIN dbo._RefObjItem i with(NOLOCK) on r.Link = i.ID WHERE TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 in (1,2,3,4,6,9,10,11) AND r.[Service] = 1