category
BEKO CN136222DX
BEKO CN136232X
BEKO CN136122
BEKO FS127320
BEKO FN131420
BEKO FN127420
BEKO FN130420
BEKO CN136122X
BEKO CN136220T
BEKO CN132100DS
BEKO FN121420
BEKO CN136231T
BEKO CS134021A
BEKO CN136221T
BEKO CN136231X
BEKO CN136221P
BEKO CN136240P
BEKO CN136121
BEKO CN136121T
BEKO FN129420
BEKO CN136241X
BEKO CNE34220GW
BEKO CNE34220GR
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=4789)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
