category
BEKO WMF 25126
BEKO WMF 51221 E
BEKO WMF 51421 E
BEKO WMF 66160
BEKO WMP 501 S
BEKO WMP 541 W
BEKO WMP 601 W
BEKO WMP 621 W
BEKO WMP 631 S
BEKO WMP 632 B
BEKO WMP 652 W
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=3589)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
