category
BEKO CA5410S
BEKO CA5410W
BEKO CA5411FFS
BEKO CA5411FFS-2
BEKO CA5411FFW
BEKO CA5411FFW/1
BEKO CA5411FFW-2
BEKO CA5411FFX
BEKO CDA538S
BEKO CDA538S-1
BEKO CDA538W
BEKO CDA538W-1
BEKO CDA539FS
BEKO CDA539FS/1
BEKO CDA539FS-2
BEKO CDA539FW
BEKO CDA539FW/1
BEKO CDA539FW-2
BEKO CDA539FX
BEKO CDA541S
BEKO CDA541W
BEKO CDA542S
BEKO CDA542W
BEKO CDA543FB
BEKO CDA543FS
BEKO CDA543FS/1
BEKO CDA543FS/2
BEKO CDA543FW
BEKO CDA543FW/1
BEKO CDA543FW/2
BEKO CDA543FX
BEKO CDA554S
BEKO CDA554W
BEKO CDA563FS
BEKO CDA563FS/1
BEKO CDA563FW
BEKO CDA563FW/1
BEKO CDA565FW
BEKO CFA65S
BEKO CFA65W
BEKO CFA65W-1
BEKO CFA70S
BEKO CFA70W
BEKO TZDA504FS
BEKO TZDA504FW
BEKO TZDA524FS
BEKO TZDA524FW
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=23305)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
