category
ARISTON LV 620
ARISTON LV 620 BK
ARISTON LV 620 IX
ARISTON LV 640 A
ARISTON LV 641 AIX
ARISTON LV 650 A
ARISTON LV 660 ABK
ARISTON LV 660 AIX
ARISTON LV 661 A
ARISTON LV 670 ROW
ARISTON LV 671 AIX
HOTPOINT BFV 680 X
HOTPOINT BFZ 700 X
INDESIT DV 620
INDESIT DV 620 BK
INDESIT DV 630 A
INDESIT DV 650 A
INDESIT DV 670 A
INDESIT IDE 1000
INDESIR IDE 1000 S
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=23584)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
