category
LG WD10131F
LG WD12230FB
LG WD80250S
LG WM12235FB
LG WD10150FB
LG WD12235FB
LG WM10130F
LG WM13150FB
LG WD10170ND
LG WD14225FD
LG WM10240F
LG WM13155FB
LG WD10170SD
LG WD16225FD
LG WM11150FB
LG WM13220FD
LG WD10170TD
LG WD65130F
LG WM11155FB
LG WM14220FD
LG WD10180T
LG WD80130F
LG WM11220FD
LG WM14225FD
LG WD12170SD
LG WD80150N
LG WM12220FD
LG WM16220FD
LG WD12175ND
LG WD80150S
LG WM12225FD
LG WM16225FD
LG WD12220FD
LG WD80180T
LG WM12230FB
related products
SELECT TOP 5 LOGICALREF,CODE,NAME3 FROM LG_003_ITEMS IT WHERE LOGICALREF IN (SELECT ITEMREF FROM LG_003_ITEMCATEGORYLINE WHERE ITEMCATEGORYREF=( SELECT TOP 1 ITEMCATEGORYREF FROM LG_003_ITEMCATEGORYLINE WHERE ITEMREF=23118)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
