SELECT 
A.ITEMGROUPID,A.ITEMID,A.ITEMNAME,A.ITEMTYPE,A.PURCHMODEL,A.HEIGHT,A.WIDTH,A.SALESMODEL,
A.COSTGROUPID,A.REQGROUPID,A.PRIMARYVENDORID,A.NETWEIGHT,A.DEPTH,A.UNITVOLUME,A.BOMUNITID,
A.DENSITY,A.DEL_SCRAPTYPEID,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.COSTMODEL,A.USEALTITEMID,
A.ALTITEMID,A.INTRACODE,A.BOMMANUALCONSUMP,A.BOMMANUALRECEIPT,A.STOPEXPLODE,A.DEL_COVPERINVENTLOCATION,
A.PHANTOM,A.INTRAUNIT,A.BOMLEVEL,A.BATCHNUMGROUPID,A.AUTOREPORTFINISHED,A.ORIGCOUNTRYID,
A.STATISTICSFACTOR,A.ALTCONFIGID,A.STANDARDCONFIGID,A.DEL_CONFIGACTIVE,A.PRODPOOLID,A.PROPERTYID,
A.ABCTIEUP,A.ABCREVENUE,A.ABCVALUE,A.ABCCONTRIBUTIONMARGIN,A.COMMISSIONGROUPID,A.DEL_BARCODE,
A.DEL_BARCODETYPE,A.CONFIGURABLE,A.SALESPERCENTMARKUP,A.SALESCONTRIBUTIONRATIO,A.SALESPRICEMODELBASIC,
A.MINAVERAGESETTLE,A.NAMEALIAS,A.PRODGROUPID,A.PROJCATEGORYID,A.GROSSDEPTH,A.GROSSWIDTH,
A.GROSSHEIGHT,A.SORTCODE,A.CONFIGSIMILAR,A.SERIALNUMGROUPID,A.DIMGROUPID,A.MODELGROUPID,
A.ITEMBUYERGROUPID,A.TAXPACKAGINGQTY,A.DEL_TEMPLATE,A.ORIGSTATEID,A.STOPEXPLODEPRICE,A.WMSPICKINGQTYTIME,
A.TARAWEIGHT,A.PACKAGINGGROUPID,A.SCRAPVAR,A.SCRAPCONST,A.STANDARDINVENTCOLORID,A.STANDARDINVENTSIZEID,
A.ITEMDIMCOMBINATIONAUTOCREATE,A.ITEMDIMCOSTPRICE,A.ITEMIDCOMPANY,A.ALTINVENTSIZEID,A.ALTINVENTCOLORID,
A.FORECASTDMPINCLUDE,A.PBAITEMCONFIGURABLE,A.PBAINVENTITEMGROUPID,A.GROSSWEIGHT_RU,A.PACKING_RU,
A.ASSETGROUPID_RU,A.ASSETID_RU,A.OWNERTMID,A.OWNERTMGROUPID,A.ITEMRANGEID,A.ITEMRANGEIDREF,
A.SALESDEPID,A.ITEMID_CRYSTALL,A.ITEMNAME_CRYSTALL,A.CERTIFGROUPID,A.PRICELISTTEMPLATEID,
A.PRICELISTGROUPID,A.REQMUSTBEBOUGHT,A.BOMSALECHANELID,A.USEBYDAY,A.OLAPITEMNAME,A.DCMANDATORY,
A.GRS_CREATEDATE,A.GRS_RATEOFLOSS,A.RECID,B.ITEMID,B.MODULETYPE,B.UNITID,B.PRICE,B.PRICEUNIT,
B.MARKUP,B.LINEDISC,B.MULTILINEDISC,B.ENDDISC,B.QUANTITY,B.LOWESTQTY,B.HIGHESTQTY,B.TAXITEMGROUPID,
B.BLOCKED,B.DELIVERYTIME,B.INVENTLOCATIONID,B.MANDATORYINVENTLOCATION,B.STANDARDQTY,B.MARKUPGROUPID,
B.PRICEDATE,B.PRICEQTY,B.ALLOCATEMARKUP,B.OVERDELIVERYPCT,B.UNDERDELIVERYPCT,B.SUPPITEMGROUPID,
B.CALENDARDAYS,B.INTERCOMPANYBLOCKED,B.PRICESECCUR_RU,B.MARKUPSECCUR_RU,B.ACCOUNTDEPATMENTBLOCK,
B.RETAILSALESBLOCKED,B.DEL_PRIMARYVENDID,B.WEIGHTITEM,B.BLOCKEDRETURN,B.RECID,C.ITEMID,
C.MODULETYPE,C.UNITID,C.PRICE,C.PRICEUNIT,C.MARKUP,C.LINEDISC,C.MULTILINEDISC,C.ENDDISC,
C.QUANTITY,C.LOWESTQTY,C.HIGHESTQTY,C.TAXITEMGROUPID,C.BLOCKED,C.DELIVERYTIME,C.INVENTLOCATIONID,
C.MANDATORYINVENTLOCATION,C.STANDARDQTY,C.MARKUPGROUPID,C.PRICEDATE,C.PRICEQTY,C.ALLOCATEMARKUP,
C.OVERDELIVERYPCT,C.UNDERDELIVERYPCT,C.SUPPITEMGROUPID,C.CALENDARDAYS,C.INTERCOMPANYBLOCKED,
C.PRICESECCUR_RU,C.MARKUPSECCUR_RU,C.ACCOUNTDEPATMENTBLOCK,C.RETAILSALESBLOCKED,C.DEL_PRIMARYVENDID,
C.WEIGHTITEM,C.BLOCKEDRETURN,C.RECID,D.ITEMID,D.MODULETYPE,D.UNITID,D.PRICE,D.PRICEUNIT,D.MARKUP,
D.LINEDISC,D.MULTILINEDISC,D.ENDDISC,D.QUANTITY,D.LOWESTQTY,D.HIGHESTQTY,D.TAXITEMGROUPID,
D.BLOCKED,D.DELIVERYTIME,D.INVENTLOCATIONID,D.MANDATORYINVENTLOCATION,D.STANDARDQTY,D.MARKUPGROUPID,
D.PRICEDATE,D.PRICEQTY,D.ALLOCATEMARKUP,D.OVERDELIVERYPCT,D.UNDERDELIVERYPCT,D.SUPPITEMGROUPID,
D.CALENDARDAYS,D.INTERCOMPANYBLOCKED,D.PRICESECCUR_RU,D.MARKUPSECCUR_RU,D.ACCOUNTDEPATMENTBLOCK,
D.RETAILSALESBLOCKED,D.DEL_PRIMARYVENDID,D.WEIGHTITEM,D.BLOCKEDRETURN,D.RECID,E.ITEMID,
E.DEL_CONFIGID,E.DEL_INVENTLOCATIONID,E.DEL_COVRULE,E.DEL_COVPERIOD,E.DEL_MININVENTONHAND,
E.DEL_MAXINVENTONHAND,E.COUNTGROUPID,E.DEL_DELIVERYTIME,E.WMSSTOREZONEID,E.WMSPICKINGLOCATION,
E.COUNTINGSTARTED,E.COUNTINGJOURNALID,E.WMSLOCATIONIDDEFAULTISSUE,E.WMSLOCATIONIDDEFAULTRECEIPT,
E.INVENTDIMID,E.USEWMSORDER,E.PICKINGLOCATIONREFILLMIN,E.AUTOREPORTFINISHED,E.RECID 


FROM 

INVENTTABLE A(NOLOCK),
INVENTTABLEMODULE B(NOLOCK),
INVENTTABLEMODULE C(NOLOCK),
INVENTTABLEMODULE D(NOLOCK),
INVENTITEMLOCATION E(NOLOCK)  
WHERE 
(A.DATAAREAID='mzg') AND ((B.DATAAREAID='mzg') AND ((B.MODULETYPE= 1 ) AND (A.ITEMID=B.ITEMID))) 
AND ((C.DATAAREAID='mzg') AND ((C.MODULETYPE= 0 ) AND (A.ITEMID=C.ITEMID))) 
AND ((D.DATAAREAID='mzg') AND ((D.MODULETYPE= 2 ) AND (A.ITEMID=D.ITEMID))) 
AND ((E.DATAAREAID='mzg') AND ((E.INVENTDIMID='              Axapta') 
AND (A.ITEMID=E.ITEMID))) AND EXISTS (SELECT 'x' FROM INVENTITEMRANGEREF F(NOLOCK)  
WHERE ((F.DATAAREAID='mzg') AND ((F.RANGEIDREFPARENT= 1193379382 ) AND (A.ITEMRANGEIDREF=F.RANGEIDREF)))) 
ORDER BY A.DATAAREAID,A.ITEMID OPTION(FAST  1 ,LOOP JOIN)

SELECT 
	SUM(A.POSTEDQTY),
	SUM(A.POSTEDVALUE),
	SUM(A.PHYSICALVALUE),
	SUM(A.DEDUCTED),
	SUM(A.RECEIVED),
	SUM(A.RESERVPHYSICAL),
	SUM(A.RESERVORDERED),
	SUM(A.REGISTERED),
	SUM(A.PICKED),
	SUM(A.ONORDER),
	SUM(A.ORDERED),
	SUM(A.ARRIVED),
	SUM(A.QUOTATIONRECEIPT),
	SUM(A.QUOTATIONISSUE),
	SUM(A.AVAILPHYSICAL),
	SUM(A.AVAILORDERED),
	SUM(A.POSTEDVALUESECCUR_RU),
	SUM(A.PHYSICALVALUESECCUR_RU),
	SUM(A.PHYSICALINVENT)
FROM 
	INVENTSUM A(NOLOCK),
	INVENTDIM B(NOLOCK)  
WHERE 
	((A.DATAAREAID='mzg') AND ((A.ITEMID='06050') AND (A.CLOSED= 0 ))) 
	AND ((B.DATAAREAID='mzg') AND ((B.INVENTDIMID=A.INVENTDIMID) 
	AND (B.INVENTLOCATIONID='Производство'))) 

OPTION(FAST  27 )

SELECT 
	SUM(A.AMOUNTMST) 
FROM 
	REQUESTLINE A 
WHERE 
	(A.DATAAREAID='mzg') 
AND 
	EXISTS (
			SELECT 
				'x' 
			FROM a
				REQUESTTABLE B 
			WHERE 
				((B.DATAAREAID='mzg') 
					AND 
				((B.PURCHID=B.PURCHID) 
				AND 
				(B.REQUESTID=A.REQUESTID)))) 
OPTION(FAST  17 )