category
MERLONI ARISTON (AR6F/L.. - AR7D/F/L.. - ARM7L., ARMX.. -
ARXX.. - WDG.. - WMG.), MERLONI HOTPOINT (BHWD.. - BHWM..
- HV7L - WDF..), MERLONI INDESIT (IWE.. - IWSE.. - XWE..
- XWSE.)
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=23078)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
