category
ARISTON AQXXF129
ARISTON AQXD169UK
ARISTON AQGD169SUK
ARISTON AQXXD169PM
ARISTON AQXXF149PI
ARISTON AQXXL129PI
ARISTON AQXL169UK
ARISTON AQXXF149HPI
ARISTON AQXXF149PM
ARISTON AQXXL129PM
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=23125)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC