category
BEKO CIM 306008 TX
BEKO CIM 302000 TX
BEKO CIM 303000 TX
BEKO CIM 310000 TX
BEKO CIM 303008 TX
BEKO CIM 300008 TB
BEKO BPM 5632 WT
BEKO BPM 5632 W
BEKO CIM 300006 TB
BEKO CIM 310001 TX
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=3980)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
