category
BEKO CM 51222 S
BEKO CE 51220 S
BEKO CM 51210 S
BEKO CM 51220 S
BEKO CM 51210
BEKO CM 58200
BEKO CM 51220
BEKO CM 51220 SX
BEKO CIM 310000 TX
BEKO CM 51221 SX
BEKO CM 58201
BEKO CE 51220 SX
BEKO CM 51221 S
BEKO CM 58201 X
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=901)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
