category
LG F1222TD
LG WD10150FB
LG WD12235FB
LG WD80250S
LG F1222TD5
LG WD10170ND
LG WD12331AD
LG WM10130F
LG F1256QD
LG WD10170SD
LG WD12336AD
LG WM10240F
LG F1402FDS5
LG WD10170TD
LG WD14225FD
LG WM11150FB
LG F1403FD
LG WD10180T
LG WD16225FD
LG WM11155FB
LG F1403TDS
LG WD11155FB
LG WD65130F
LG WM11220FD
LG F1422TD
LG WD12170SD
LG WD80130F
LG WM12220F
LG F1422TD5
LG WD12175ND
LG WD80150N
LG WM12225FD
LG F1456QD
LG WD12220FD
LG WD80150S
LG WM12230FB
LG WD10131F
LG WD12230FB
LG WD80180T
LG WM12235FB
LG WM12341FD
LG WM14220FD
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=23122)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
