category
BEKO CHA 33100 X
BEKO CKSM 1650 X A+
BEKO CSA 34023S
BEKO CVA 34123 X
BEKO CSA 34023X
BEKO CHA 33100S
BEKO TSM 1540
BEKO CSA 34030 X
BEKO CSA 34023S
BEKO CHA 34020X
BEKO CNA 32520 XM
BEKO CNA28520 X
BEKO CVA 34123S
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=4398)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC