category
SAMSUNG RL 34 ECMB
SAMSUNG RL 34 ECMG
SAMSUNG RL 34 ECMS
SAMSUNG RL 34 ECPS
SAMSUNG RL 34 ECSW
SAMSUNG RL 34 ECTS
SAMSUNG RL 34 ECVB
SAMSUNG RL 34 EGIH
SAMSUNG RL 34 EGMG
SAMSUNG RL 34 EGPS
SAMSUNG RL 34 EGSW
SAMSUNG RL 34 EGTS
SAMSUNG RL 34 HDIH
SAMSUNG RL 34 HGIH
SAMSUNG RL 34 HGMG
SAMSUNG RL 34 HGSW
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=23595)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
