category
ARISTON AB 103 MTK
ARISTON AB 104
ARISTON AB 105 TK
ARISTON AB 64 EX 115
ARISTON AB 84
ARISTON AB 86
ARISTON AB 95
ARISTON AL 10
ARISTON AL 102 P
ARISTON AL 109
ARISTON AL 68
INDESIT GA 10 TP
INDESIT GA 8 TP
INDESIT LNA 1000
INDESIT LNA 800
INDESIT LNA 850
INDESIT LNA 855
INDESIT W101
INDESIT W103
INDESIT W104
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=2940)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
