category
BOSCH SGI55M05EU/52
BOSCH SGI45N05EU/36
SIEMENS 3SE24M850EU/90
SIEMENS SE54M550EU/70
SIEMENS SE55E550EU/70
SIEMENS SE44M561EU/73
SIEMENS SE24M257EU/73
SIEMENS SE24A932EU/52
SIEMENS SE55E550EU/73
SIEMENS SE54M558EU/73
SIEMENS SE53A531/49
SIEMENS SE25E251EU/56
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=3554)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
