category
BEKO WTV 7734 XS0
BEKO WMN 101244 PL PTLMB1
BEKO WMY81240 LB2
BEKO WMY 81043 PL PTLMB2
BEKO WMX 81243 PL PTLMB2
BEKO WMY 71043 PL PTLMB2
BEKO WMY 71483 LMB2
BEKO WMY 81243 PL PTLMB1
BEKO WMY 71243 PL PTLMB1
BEKO WMY 81283 LMB2
BEKO HTV 8733 XS0
BEKO WMX 71243 PL PTLMB2
BEKO WMY 81243 CS PTLMB1
BEKO WMB 71043 PL PTLMA
BEKO WTV 8734 XC0M
BEKO WMX 81043 PL PTLMB3
BEKO WMY 61283 MB3
BEKO WMY 61483 MB3
BEKO WMY 71283 LMB3
BEKO WMY 71283 LMB2
BEKO WMY 61243 PL PTLB1
BEKO WMX 61243 PL PTLB2
BEKO WMX 71033 PL PTLMB3
BEKO WMY 71483 LMB2
BEKO WMY 61033 PL PTLB2
BEKO WMN 81243 PL PTLMB2
BEKO WMN 71243 PL PTLMB3
BEKO WMY 81443 STB1
BEKO WMB 61043 PL PTM
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=23046)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
