category
BEKO CDP7601A
BEKO CDP7621HCA
BEKO CNE32100D
BEKO CNE32100X
BEKO CSE34020
BEKO DNE44080
BEKO DNE44080S
BEKO DNE44081
BEKO DNE44081S
BEKO DNE45080
BEKO DNE45090
BEKO DNE46090
BEKO DNE460902
BEKO DNE46090S
BEKO DNE46090S1
BEKO DNE46090S2
BEKO DNE46091
BEKO RDP6900
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=23579)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
