category
ARCELIK 9650DI
BEKO DBDF243WG
BEKO DBM243BG
BEKO ODF21300B
BEKO ODF21300W
BEKO ODF22300X
BEKO OIC21000W
BEKO OIE22300X
BEKO OIF21100W
BEKO OIF21300B
BEKO OIF21300W
BEKO OIF22100X
BEKO OIF22300X
BEKO OIF22300XL
BEKO OIF22300XR
BEKO OIF22301XL
BEKO OIF22301XR
BEKO OIM22300X
BEKO OSF21121X
BEKO OSF22110X
BEKO OSF22125X
BEKO OSF22130SX
BEKO OSF22135SX
BLOOMBERG BDO9564X
BLOOMBERG BEO9414X
FLAVEL FLS61FX
FLAVEL FLS63FX
FLAVEL FLV91FX
LAMONA HJA3400
LAMONA HJA3660
LAMONA HJA4620
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=3864)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
