category
BEKO WM 3350 E
BEKO WM 3350 ES
BEKO WM 3352 P
BEKO WM 3356 D
BEKO WM 3358 E
BEKO WM 5350 T
BEKO WM 5350 TB
BEKO WM 5350 TS
BEKO WM 5352 T
BEKO WM 5356 T
BEKO WMD 23500 T
BEKO WMD 23500 TS
BEKO WMN 6358 SE
BEKO WMN 6356 SD
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=3113)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_14_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC