category
BEKO WTV 7734 XS0
BEKO WTV 8633 XS
BEKO WTV 8634 XS0
BEKO WMY81240 LB2
BEKO WMB 71033 PL PTM
BEKO WMB 71032 PL PTLMA
BEKO WTE 11735 XCST
BEKO WMB 71032 PTM
BEKO WMD 78127 S
BEKO WMB 61431 M
BEKO WMB 71031 MS
BEKO WTV 8734 XC0M
BEKO WMD 78127
BEKO WTE 7502 B0
BEKO WMB 71443 LE
BEKO WTV 7634 XS0
BEKO WTV 8534 X0
BEKO WMB71642PTLA
BEKO WMB 71643 PTL
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=3585)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
