category
VESTEL WM1034TS
VESTEL WM3410
VESTEL WMS1034TS
VESTEL WM1034
VESTEL WM1034E
VESTEL WM1234E
VESTEL WM834TS
VESTEL WM 3260
VESTEL WM 634 T
VESTEL WM 632 T
VESTEL WM 634 E4
VESTEL WM834T
VESTEL WM1034E4
VESTEL WM1234E4
VESTEL WM 640 T
VESTEL WM652
VESTEL WM 840 T
VESTEL WM 840 TS
VESTEL WMS 840 TS
VESTEL WM4080S
VESTEL WM 1040 TS
VESTEL WM4100
VESTEL WMS 1040 TS
VESTEL WMS 4010 TS
VESTEL WM1040TSB
VESTEL WM1040E
VESTEL WM 1240 E
VESTEL WM1040E4
VESTEL WM1240E
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=3309)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
