category
ELECTROLUX ZANUSSI (EW1000),ELECTROLUX (EW1,EW8,EW7,
EW9,EWF,EW6,EW5,EWG),AEG (L60,L62,LTR,L66,CLA,L64),
ARTHURMARTINELUX (AWF,AW8,AWI,AW1), FRANKE (FWM12005EI),
REX (RLP,RIE,RL6,RLE,RLS,RI1,RL9,RL7,RIS,RLU,
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=24365)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
