category
ARISTON (AQUALTIS, AQX, AQ9, AQS, AQM, AQ7, AQG, AQD,
AQ1, AQL, ADS), HOTPOINT (AQ1, AQX, AQ9, AQ7, AQD, AQL,
AQG, AQM), HOTPOINT-ARISTON (AQ9, AQS, AQ8, AQ7, AQ1,
AQD, AQX, AQM, AQG, AQL, ADS, QVS, AQ6, QVE, AQP, QVD,
QVB)
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=23128)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
