category
BEKO DFS1500
BEKO DFN05211W
BEKO DFN1530X
BEKO DFN1530
BEKO D5543FW
BEKO 3505LL
BEKO DSS2500X
BEKO 3503LL
BEKO DFC05210X
BEKO DFC05210W
BEKO DFN1300
BEKO DSN1400XN
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=1389)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC