category
ARISTON LBF 51 EXR 60 HZ
ARISTON LDF 12314 AG.R
ARISTON LDF 12314 BEX
ARISTON LFF 8114 AGR
HOTPOINT FDD 914 G.R
HOTPOINT FDF 780 PR
HOTPOINT FDL 570 G.R
HOTPOINT LFT 114
HOTPOINT LFT 116 A
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=23134)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
