category
BEKO WM 2456 D
BEKO WM 2506 D
BEKO WM 5500 T
BEKO WM 5450 T
BEKO WM 3450 E
BEKO WM 2358 E
BEKO WM 5458 T
BEKO WM 5508 T
BEKO WM 2458 E
BEKO WM 2450 ES
BEKO WM 2350 ES
BEKO WM 2350 E
BEKO WM 5350 T
BEKO WM 2450 E
BEKO WM 5552 T
BEKO WM 2510 MS
BEKO WM 5554 T
BEKO WM 5356 T
BEKO WM 2510 M
BEKO WM 5456 T
BEKO WM 2510 M
BEKO WM 5358 T
BEKO WM 2508 L
BEKO WM 2356 D
BEKO WM 5506 T
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=24)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
