category
SAMSUNG WD8122CVB
SAMSUNG WD9122CLE
SAMSUNG WF203ANS
SAMSUNG WF203ANW
SAMSUNG WF206ANS
SAMSUNG WF206BNW
SAMSUNG WF206LNW
SAMSUNG WF306BAW
SAMSUNG WF306BHW
SAMSUNG WF306LAW
SAMSUNG WF316BAC
SAMSUNG WF316BAW
SAMSUNG WF316HAC
SAMSUNG WF316LAS
SAMSUNG WF316LAW
SAMSUNG WF317AAG
SAMSUNG WF317AAS
SAMSUNG WF317AAW
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=23095)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
