category
SAMSUNG 731419GO / YOD
SAMSUNG 731419GL / YOD
SAMSUNG 819102GL / YOD
SAMSUNG 874062GO / YOD
SAMSUNG B1013JGW / XEP
SAMSUNG B1013JEWU / YPB
SAMSUNG B1013JEW1U / YPB
SAMSUNG B1013JEW1 / YQH
SAMSUNG B1013JEW1 / YMF
SAMSUNG B1045IW / XSA
SAMSUNG B1045AGS1 / XFA
SAMSUNG B1045AVGW1 / XEO
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=23096)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
