category
BEKO CA7014FFX
BEKO CA7015FFS
BEKO CA7015FFS/1
BEKO CA7015FFW
BEKO CA7015FFX
BEKO CDA751FS
BEKO CDA751FS/1
BEKO CDA751FW
BEKO CDA751FW/1
BEKO CDA751FX
BEKO CDA752FS
BEKO CDA752FS/1
BEKO CDA752FW
BEKO CDA752FW/1
BEKO CDA752FX
BEKO TDA735S
BEKO TDA735W
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=2747)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
