category
LG WM3875HVCA
LG WM2601HL
LG WM2601HW
LG WM2701HV
LG WM2801HRA
LG F1403FD9
LG F1459FDS3
LG WM2801HWA
LG WM3875HWCA
LG WM3455HW
LG F1403FD
LG F1314FDS1
LG F1314FDS2
LG WM1355HR
LG WM1355HW
LG F1254FD
LG F1459FDS
LG 48231010108
LG F1403RD
LG F1254FD1
LG F1254FD3
LG F1255FD5
LG WM2050CW
LG WM2901HVA
LG F1267FDY
LG F1314FDS
LG WM3001HPA
LG WM3001HRA
LG F1354FDS1
LG F1354FDS3
LG F1355FDS5
LG F1354FDS
LG WM2801HLA
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=23123)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
