category
BEKO BCDP503W
BEKO BCDVC503W
BEKO BD533AKB
BEKO D533AS
BEKO BD533AW
BEKO BDV555AK
BEKO BDV555AS
BEKO BDV555AW
BEKO BDV555AX
BEKO BDVC100K
BEKO BDVC100X
BEKO BDVC563AK
BEKO BDVC563AW
BEKO BDVC5XNTW
BEKO BDVF100K
BEKO BDVF100X
BEKO BE10DUFK
BEKO BE10DUFS
BEKO BE10ELEK
BEKO BE10ELES
BEKO BHDO50CK
BEKO BRTF22300X
BEKO BTF26300X
BEKO BXTF25300X
BEKO OTF22300X
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=23018)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
