category
BEKO WTV 6533 BS
BEKO WMD 78127 S
BEKO WTV 6633 BS0
BEKO WTV 6633 BS
BEKO WMB91242LC
BEKO WMY 61283 MB3
BEKO WMY 61483 MB3
BEKO WMD 78127
BEKO MWTV 6633 BB
BEKO MWTV 6533 BB
BEKO WMB 61043 PL PTM
BEKO WMB91442LC
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=4183)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
