SELECT
  T1.ITEMID,
  T1.ITEMTYPE,
  T1.PURCHMODEL,
  T1.HEIGHT,
  T1.WIDTH,
  T1.SALESMODEL,
  T1.COSTGROUPID,
  T1.REQGROUPID,
  T1.PRIMARYVENDORID,
  T1.NETWEIGHT,
  T1.DEPTH,
  T1.UNITVOLUME,
  T1.BOMUNITID,
  T1.ITEMPRICETOLERANCEGROUPID,
  T1.DENSITY,
  T1.COSTMODEL,
  T1.USEALTITEMID,
  T1.ALTITEMID,
  T1.MATCHINGPOLICY,
  T1.INTRACODE,
  T1.PBAITEMAUTOGENERATED,
  T1.WMSARRIVALHANDLINGTIME,
  T1.PHANTOM,
  T1.INTRAUNIT,
  T1.BOMLEVEL,
  T1.BATCHNUMGROUPID,
  T1.AUTOREPORTFINISHED,
  T1.ORIGCOUNTRYREGIONID,
  T1.STATISTICSFACTOR,
  T1.ALTCONFIGID,
  T1.STANDARDCONFIGID,
  T1.PROPERTYID,
  T1.ABCTIEUP,
  T1.ABCREVENUE,
  T1.ABCVALUE,
  T1.ABCCONTRIBUTIONMARGIN,
  T1.COMMISSIONGROUPID,
  T1.SALESPERCENTMARKUP,
  T1.SALESCONTRIBUTIONRATIO,
  T1.SALESPRICEMODELBASIC,
  T1.NAMEALIAS,
  T1.PROJCATEGORYID,
  T1.GROSSDEPTH,
  T1.GROSSWIDTH,
  T1.GROSSHEIGHT,
  T1.SORTCODE,
  T1.SERIALNUMGROUPID,
  T1.ITEMBUYERGROUPID,
  T1.TAXPACKAGINGQTY,
  T1.ORIGSTATEID,
  T1.TARAWEIGHT,
  T1.PACKAGINGGROUPID,
  T1.SCRAPVAR,
  T1.SCRAPCONST,
  T1.STANDARDINVENTCOLORID,
  T1.STANDARDINVENTSIZEID,
  T1.ITEMDIMCOSTPRICE,
  T1.ALTINVENTSIZEID,
  T1.ALTINVENTCOLORID,
  T1.FORECASTDMPINCLUDE,
  T1.PRODUCT,
  T1.DEFAULTDIMENSION,
  T1.BOMCALCGROUPID,
  T1.PBAITEMCONFIGURABLE,
  T1.PBAINVENTITEMGROUPID,
  T1.PBAHIDEDIALOG,
  T1.PBAHIDEAPPROVAL,
  T1.PBAAUTOSTART,
  T1.PBAMANDATORYCONFIG,
  T1.ALTINVENTSTYLEID,
  T1.BATCHMERGEDATECALCULATIONMETHOD,
  T1.PDSBESTBEFORE,
  T1.PDSFREIGHTALLOCATIONGROUPID,
  T1.PDSITEMREBATEGROUPID,
  T1.PDSSHELFADVICE,
  T1.PDSSHELFLIFE,
  T1.PDSVENDORCHECKITEM,
  T1.STANDARDINVENTSTYLEID,
  T1.SC_LASTMODIFIED,
  T1.SC_VISIBLEINWEBSHOP,
  T1.DESCRIPTION,
  T1.FUZZY_DESCRIPTION,
  T1.MODIFIEDDATETIME,
  T1.DEL_MODIFIEDTIME,
  T1.MODIFIEDBY,
  T1.CREATEDDATETIME,
  T1.DEL_CREATEDTIME,
  T1.CREATEDBY,
  T1.RECVERSION,
  T1.PARTITION,
  T1.RECID,
  T2.UOMSEQGROUPID,
  T2.MAXPICKQTY,
  T2.ITEMID,
  T2.RFDESCRIPTION1,
  T2.RFDESCRIPTION2,
  T2.PACKSIZECATEOGRYID,
  T2.FILTERCODE,
  T2.FILTERCODE2_,
  T2.FILTERCODE3_,
  T2.FILTERCODE4_,
  T2.FILTERGROUP,
  T2.FILTERGROUP2_,
  T2.FILTERCHANGED,
  T2.PRODQTY,
  T2.PHYSDIMID,
  T2.PACKAGECLASSID,
  T2.PICKWCNEG,
  T2.MODIFIEDDATETIME,
  T2.MODIFIEDBY,
  T2.RECVERSION,
  T2.PARTITION,
  T2.RECID,
  T3.ITEMBARCODE,
  T3.ITEMID,
  T3.INVENTDIMID,
  T3.BARCODESETUPID,
  T3.USEFORPRINTING,
  T3.USEFORINPUT,
  T3.DESCRIPTION,
  T3.QTY,
  T3.UNITID,
  T3.RETAILVARIANTID,
  T3.RETAILSHOWFORITEM,
  T3.BLOCKED,
  T3.MODIFIEDDATETIME,
  T3.DEL_MODIFIEDTIME,
  T3.MODIFIEDBY,
  T3.RECVERSION,
  T3.PARTITION,
  T3.RECID,
  T4.ITEMDATAAREAID,
  T4.MODELGROUPID,
  T4.ITEMID,
  T4.MODELGROUPDATAAREAID,
  T4.RECVERSION,
  T4.PARTITION,
  T4.RECID,
  T5.ITEMID,
  T5.ITEMDATAAREAID,
  T5.ITEMGROUPID,
  T5.ITEMGROUPDATAAREAID,
  T5.RECVERSION,
  T5.PARTITION,
  T5.RECID,
  T6.TRACKINGDIMENSIONGROUP,
  T6.ITEMID,
  T6.ITEMDATAAREAID,
  T6.RECVERSION,
  T6.PARTITION,
  T6.RECID,
  T7.STORAGEDIMENSIONGROUP,
  T7.ITEMID,
  T7.ITEMDATAAREAID,
  T7.RECVERSION,
  T7.PARTITION,
  T7.RECID,
  T8.PRODUCTMASTER,
  T8.RETAITOTALWEIGHT,
  T8.VARIANTCONFIGURATIONTECHNOLOGY,
  T8.RETAILCOLORGROUPID,
  T8.RETAILSIZEGROUPID,
  T8.RETAILSTYLEGROUPID,
  T8.ISPRODUCTVARIANTUNITCONVERSIONENABLED,
  T8.INSTANCERELATIONTYPE,
  T8.DISPLAYPRODUCTNUMBER,
  T8.SEARCHNAME,
  T8.PRODUCTTYPE,
  T8.MODIFIEDBY,
  T8.RECVERSION,
  T8.RELATIONTYPE,
  T8.PARTITION,
  T8.RECID,
  T9.ITEMID,
  T9.MODULETYPE,
  T9.CUSTVENDRELATION,
  T9.EXTERNALITEMTXT,
  T9.EXTERNALITEMID,
  T9.ABCCATEGORY,
  T9.DESCRIPTION,
  T9.INVENTDIMID,
  T9.MODIFIEDBY,
  T9.RECVERSION,
  T9.PARTITION,
  T9.RECID,
  T10.ITEMID,
  T10.INVENTDIMID,
  T10.DESCRIPTION,
  T10.UNITID,
  T10.GLOBALTRADEITEMNUMBER,
  T10.MODIFIEDDATETIME,
  T10.DEL_MODIFIEDTIME,
  T10.MODIFIEDBY,
  T10.RECVERSION,
  T10.PARTITION,
  T10.RECID,
  T11.ITEMID,
  T11.MODULETYPE,
  T11.UNITID,
  T11.PRICE,
  T11.PRICEUNIT,
  T11.MARKUP,
  T11.LINEDISC,
  T11.MULTILINEDISC,
  T11.ENDDISC,
  T11.TAXITEMGROUPID,
  T11.MARKUPGROUPID,
  T11.PRICEDATE,
  T11.PRICEQTY,
  T11.ALLOCATEMARKUP,
  T11.OVERDELIVERYPCT,
  T11.UNDERDELIVERYPCT,
  T11.SUPPITEMGROUPID,
  T11.INTERCOMPANYBLOCKED,
  T11.MODIFIEDDATETIME,
  T11.DEL_MODIFIEDTIME,
  T11.MODIFIEDBY,
  T11.CREATEDDATETIME,
  T11.DEL_CREATEDTIME,
  T11.CREATEDBY,
  T11.RECVERSION,
  T11.PARTITION,
  T11.RECID,
  T12.ITEMID,
  T12.MODULETYPE,
  T12.UNITID,
  T12.PRICE,
  T12.PRICEUNIT,
  T12.MARKUP,
  T12.LINEDISC,
  T12.MULTILINEDISC,
  T12.ENDDISC,
  T12.TAXITEMGROUPID,
  T12.MARKUPGROUPID,
  T12.PRICEDATE,
  T12.PRICEQTY,
  T12.ALLOCATEMARKUP,
  T12.OVERDELIVERYPCT,
  T12.UNDERDELIVERYPCT,
  T12.SUPPITEMGROUPID,
  T12.INTERCOMPANYBLOCKED,
  T12.MODIFIEDDATETIME,
  T12.DEL_MODIFIEDTIME,
  T12.MODIFIEDBY,
  T12.CREATEDDATETIME,
  T12.DEL_CREATEDTIME,
  T12.CREATEDBY,
  T12.RECVERSION,
  T12.PARTITION,
  T12.RECID,
  T13.ITEMID,
  T13.MODULETYPE,
  T13.UNITID,
  T13.PRICE,
  T13.PRICEUNIT,
  T13.MARKUP,
  T13.LINEDISC,
  T13.MULTILINEDISC,
  T13.ENDDISC,
  T13.TAXITEMGROUPID,
  T13.MARKUPGROUPID,
  T13.PRICEDATE,
  T13.PRICEQTY,
  T13.ALLOCATEMARKUP,
  T13.OVERDELIVERYPCT,
  T13.UNDERDELIVERYPCT,
  T13.SUPPITEMGROUPID,
  T13.INTERCOMPANYBLOCKED,
  T13.MODIFIEDDATETIME,
  T13.DEL_MODIFIEDTIME,
  T13.MODIFIEDBY,
  T13.CREATEDDATETIME,
  T13.DEL_CREATEDTIME,
  T13.CREATEDBY,
  T13.RECVERSION,
  T13.PARTITION,
  T13.RECID,
  T14.ITEMID,
  T14.COUNTGROUPID,
  T14.WMSPICKINGLOCATION,
  T14.WMSLOCATIONIDDEFAULTISSUE,
  T14.WMSLOCATIONIDDEFAULTRECEIPT,
  T14.INVENTDIMID,
  T14.RECVERSION,
  T14.PARTITION,
  T14.RECID,
  T15.DISPLAYPRODUCTNUMBER,
  T15.RECVERSION,
  T15.RECID,
  T15.INSTANCERELATIONTYPE,
  T16.NAME,
  T16.RECVERSION,
  T16.RECID,
  T17.NAME,
  T17.RECVERSION,
  T17.RECID,
  T18.PRODUCTDIMENSIONGROUP,
  T18.PRODUCT,
  T18.MODIFIEDBY,
  T18.RECVERSION,
  T18.PARTITION,
  T18.RECID,
  T19.DESCRIPTION,
  T19.NAME,
  T19.PRODUCT,
  T19.LANGUAGEID,
  T19.MODIFIEDBY,
  T19.RECVERSION,
  T19.PARTITION,
  T19.RECID,
  T20.PRODUCTMASTER,
  T20.ISVARIANTGENERATIONENABLED,
  T20.ISREUSECONFIGURATIONENABLED,
  T20.RECVERSION,
  T20.PARTITION,
  T20.RECID,
  T21.NAME,
  T21.RECVERSION,
  T21.RECID
FROM INVENTTABLE T1
LEFT OUTER JOIN WHSINVENTTABLE T2
  ON (((T2.PARTITION = 5637144576)
  AND (T2.DATAAREAID = N'01'))
  AND (T1.ITEMID = T2.ITEMID))
LEFT OUTER JOIN INVENTITEMBARCODE T3
  ON (((T3.PARTITION = 5637144576)
  AND (T3.DATAAREAID = N'01'))
  AND (T1.ITEMID = T3.ITEMID))
LEFT OUTER JOIN INVENTMODELGROUPITEM T4
  ON ((T4.PARTITION = 5637144576)
  AND ((T1.ITEMID = T4.ITEMID)
  AND (T1.DATAAREAID = T4.ITEMDATAAREAID)))
LEFT OUTER JOIN INVENTITEMGROUPITEM T5
  ON ((T5.PARTITION = 5637144576)
  AND ((T1.ITEMID = T5.ITEMID)
  AND (T1.DATAAREAID = T5.ITEMDATAAREAID)))
LEFT OUTER JOIN ECORESTRACKINGDIMENSIONGROUPITEM T6
  ON ((T6.PARTITION = 5637144576)
  AND ((T1.ITEMID = T6.ITEMID)
  AND (T1.DATAAREAID = T6.ITEMDATAAREAID)))
LEFT OUTER JOIN ECORESSTORAGEDIMENSIONGROUPITEM T7
  ON ((T7.PARTITION = 5637144576)
  AND ((T1.ITEMID = T7.ITEMID)
  AND (T1.DATAAREAID = T7.ITEMDATAAREAID)))
CROSS JOIN ECORESPRODUCT T8
LEFT OUTER JOIN CUSTVENDEXTERNALITEM T9
  ON (((T9.PARTITION = 5637144576)
  AND (T9.DATAAREAID = N'01'))
  AND (((T9.MODULETYPE = ?)
  AND (T1.PRIMARYVENDORID = T9.CUSTVENDRELATION))
  AND (T1.ITEMID = T9.ITEMID)))
LEFT OUTER JOIN INVENTITEMGTIN T10
  ON (((T10.PARTITION = 5637144576)
  AND (T10.DATAAREAID = N'01'))
  AND (T1.ITEMID = T10.ITEMID))
CROSS JOIN INVENTTABLEMODULE T11
CROSS JOIN INVENTTABLEMODULE T12
CROSS JOIN INVENTTABLEMODULE T13
CROSS JOIN INVENTITEMLOCATION T14
LEFT OUTER JOIN ECORESPRODUCT T15
  ON ((T15.PARTITION = 5637144576)
  AND (T1.PRODUCT = T15.RECID))
LEFT OUTER JOIN ECORESTRACKINGDIMENSIONGROUP T16
  ON ((T16.PARTITION = 5637144576)
  AND (T6.TRACKINGDIMENSIONGROUP = T16.RECID))
LEFT OUTER JOIN ECORESSTORAGEDIMENSIONGROUP T17
  ON ((T17.PARTITION = 5637144576)
  AND (T7.STORAGEDIMENSIONGROUP = T17.RECID))
LEFT OUTER JOIN ECORESPRODUCTDIMENSIONGROUPPRODUCT T18
  ON ((T18.PARTITION = 5637144576)
  AND (T8.RECID = T18.PRODUCT))
LEFT OUTER JOIN ECORESPRODUCTTRANSLATION T19
  ON ((T19.PARTITION = 5637144576)
  AND (((T19.LANGUAGEID = ?)
  OR (T19.LANGUAGEID = ?))
  AND (T8.RECID = T19.PRODUCT)))
LEFT OUTER JOIN ECORESPRODUCTMASTERMODELINGPOLICY T20
  ON ((T20.PARTITION = 5637144576)
  AND (T8.RECID = T20.PRODUCTMASTER))
LEFT OUTER JOIN ECORESPRODUCTDIMENSIONGROUP T21
  ON ((T21.PARTITION = 5637144576)
  AND ((T18.PRODUCTDIMENSIONGROUP = T21.RECID)
  AND (T18.PRODUCTDIMENSIONGROUP = T21.RECID)))
WHERE (((T1.PARTITION = 5637144576)
AND (T1.DATAAREAID = N'01'))
AND ((T19.DESCRIPTION LIKE ? ESCAPE '\')
AND (((((((((T1.ITEMID = ?)
AND (T8.DISPLAYPRODUCTNUMBER = ?))
AND (T8.RECID = ?))
AND (T19.PRODUCT = ?))
AND (T19.LANGUAGEID >= ?))
OR ((((T1.ITEMID = ?)
AND (T8.DISPLAYPRODUCTNUMBER = ?))
AND (T8.RECID = ?))
AND (T19.PRODUCT > ?)))
OR (((T1.ITEMID = ?)
AND (T8.DISPLAYPRODUCTNUMBER = ?))
AND (T8.RECID > ?)))
OR ((T1.ITEMID = ?)
AND (T8.DISPLAYPRODUCTNUMBER > ?)))
OR (T1.ITEMID > ?))))
AND ((T8.PARTITION = 5637144576)
AND (T1.PRODUCT = T8.RECID))
AND (((T11.PARTITION = 5637144576)
AND (T11.DATAAREAID = N'01'))
AND ((T11.MODULETYPE = ?)
AND (T11.ITEMID = T1.ITEMID)))
AND (((T12.PARTITION = 5637144576)
AND (T12.DATAAREAID = N'01'))
AND ((T12.MODULETYPE = ?)
AND (T12.ITEMID = T1.ITEMID)))
AND (((T13.PARTITION = 5637144576)
AND (T13.DATAAREAID = N'01'))
AND ((T13.MODULETYPE = ?)
AND (T13.ITEMID = T1.ITEMID)))
AND (((T14.PARTITION = 5637144576)
AND (T14.DATAAREAID = N'01'))
AND ((T14.INVENTDIMID = ?)
AND (T1.ITEMID = T14.ITEMID)))
ORDER BY T1.ITEMID, T8.DISPLAYPRODUCTNUMBER, T8.RECID, T19.PRODUCT, T19.LANGUAGEID
OPTION (FAST 2)