category
BOSCH WFB1605AU/12
BOSCH WFB1605AU/15
BOSCH WFB1605GB/11
BOSCH WFB1605GB/12
BOSCH WFB1605GB/15
BOSCH WFB2000GB/02
BOSCH WFB2000GB/03
BOSCH WFB2000GB/07
BOSCH WFB2000GB/12
BOSCH WFB2004GB/15
BOSCH WFB2005GB/11
BOSCH WFB2005GB/12
BOSCH WFB2005GB/15
BOSCH WFB3000GB/01
BOSCH WFB4000GB/01
BOSCH WFB4000GB/02
BOSCH WFB4000GB/07
BOSCH WVF2000GB/15
SIEMENS WM21050GB/12
SIEMENS WM21050GB/15
SIEMENS WM23000GB/01
SIEMENS WM23000GB/07
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=23588)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
