category
BEKO D3421FS
BEKO D3421FW
BEKO D3731FS
BEKO D3731FW
BEKO DE3541FS
BEKO DE3541FW
BEKO DE3762FS
BEKO DE3762FW
BEKO DE3861FS
BEKO DE3861FW
BEKO DE6340S
BEKO DE6340W
BEKO DFN6830
BEKO DIN5630XN
BEKO DIN5832XLN
BEKO DW450
BEKO DWD8657S
BEKO DWD8657S/1
BEKO DWD8657W
BEKO DWD8657W/1
BEKO DWD8657X
BEKO DWD8657X/1
BEKO DWLT65
BEKO DWLT68
BEKO DWP5212
BEKO FDW45
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=23583)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
