category
SAMSUNG B1245A
SAMSUNG B1445AGW
SAMSUNG P1253SGS
SAMSUNG Q1244SGS
SAMSUNG B1245AGS
SAMSUNG B1445SGS
SAMSUNG P1253SGS_XEU
SAMSUNG WF7604NAW
SAMSUNG B1245SGS
SAMSUNG J1453SGS
SAMSUNG P1253WG_XEU
SAMSUNG WF-B145N
SAMSUNG B1245W
SAMSUNG J1453SGS/XEU
SAMSUNG P1453GW
SAMSUNG WFB145NS
SAMSUNG B1445A
SAMSUNG P1253GW
SAMSUNG P1453SGS
SAMSUNG WFJ145N
SAMSUNG B1445AG
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=4699)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
