Код: Выделить всё
Select Coalesce(Sum(CL.WKolInt/N.TonIntrn*1e-06),0.000), Count( *)
From MP_MGSost MGS
Join UAG_Members UAM
On UAM.Gruppa=MGS.CodeUAG And UAM.TipZap=1
/*Left*/ Join Claims CL
On CL.KodTov=UAM.KodTov And CL.PStatus=1
Join ClaimPrZak CPZ
On CPZ.Filial=CL.Filial And CPZ.Claim=CL.Code And CPZ.Priznak='Д'
Join Nomenkl N
On N.Code=CL.KodTov
Join Sellers_Marks SM
On SM.Mark=N.Mark And SM.Seller=:Seller
Left Join X_LMGS_CL XCL
On XCL.Filial=CPZ.Filial And XCL.CodeCL=CPZ.Claim
Where MGS.CodeMG=:CodeMG And XCL.Letter Is Null
Plan JOIN (MGS INDEX (MP_MGSOST_MG),
UAM INDEX (UAM_FKGR),
CL INDEX (CL_KTSTFL),
CPZ INDEX (CLAIMPRZAK_PFC),
N INDEX (Nmnkl_Co),
SM INDEX (SM_SELMARK),
XCL INDEX (XLMGSCL_FKC))
Код: Выделить всё
PLAN JOIN (JOIN (MGS INDEX (MP_MGSOST_MG),
SM INDEX (SM_SELMARK),
CPZ INDEX (CLAIMPRZAK_PFC),
UAM INDEX (UAM_FKGR),
CL INDEX (CL_KTSTFL),
N INDEX (NMNKL_CO)),
XCL INDEX (XLMGSCL_FKC))