category
BEKO CA5411FFS -2, CA541 1FFW, CDA538S, CDA538 W 1,
CDA539FS, CDA5 39FW, CDA542, CDA542S, CDA543FB,
CDA543FS/2, CDA543FS/2, CDA5 43FW/2, CDA5 43FW, CDA554S,
CDA554 W, CDA5 63FW, CDA565FS, CDA5 65FW, CF5015APS,
CF501 5APW, CF540 W, CF5533APB, CF5533APS, CF553 3APW,
CF5834APB, CF5834APS, CF583 4APW, CFD540 W, CFD5834APB,
CFD5834APS, CFD583 4APW, CIS5 584 W, cool 53FW, COOL54FB,
COOL54FDS, COOL5 4FDW, COOL54FS, cool 54FW, CS553 3APW,
CS5713APS, CS571 3APW, CS5834APS, CS583 4APW, FFD5 582 W,
FS5552 W, CDA CDA539FB, CDA563FS, Flavel (ARCELIK)
CFA65S, CFA65 W, CFA70S, CFA70 W 1
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=23441)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
