category
BEKO DC 7130
BEKO DPY 8506 GXB1
BEKO DF8535RX0W
BEKO DCU 9330
BEKO DS7433 RX
BEKO DPY 7405 XHW3
BEKO DCU 7430
BEKO DPU 8360 X
BEKO DPU 7360 X
BEKO DS7434 RX
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=3895)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC