category
BEKO HTV 8733 XS0
BEKO HTV 8733 XS0
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=3888)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
