category
SAMSUNG RB2044SL
SAMSUNG RB2055SW
SAMSUNG RB215LABB
SAMSUNG RM255BARB
SAMSUNG RM255LASH
SAMSUNG RS2530BBP
SAMSUNG RS2530BSH
SAMSUNG RS2530BWP
SAMSUNG RS2533SW
SAMSUNG RS2534BB
SAMSUNG RS2534VQ
SAMSUNG RS2534WW
SAMSUNG RS253BASB
SAMSUNG RS2542SH
SAMSUNG RS2544SL
SAMSUNG RS2545SH
SAMSUNG RS2555BB
SAMSUNG RS2555SL
SAMSUNG RS2555SW
SAMSUNG RS2556SH
SAMSUNG RS2577BB
SAMSUNG RS2577SL
SAMSUNG RS2578SH
SAMSUNG RS2578WW
SAMSUNG RS257BARB
SAMSUNG RS2623SL
SAMSUNG RS2630SH
SAMSUNG RS2630WW
SAMSUNG RS263BBSH
SAMSUNG RS263BBWP
SAMSUNG RS264ABSH
SAMSUNG RS265LABP
SAMSUNG RS267LABP
SAMSUNG RS267LASH
SAMSUNG RS267LBSH
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=23591)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
