category
BRANDT WFC0515F
BRANDT WFC0815F
BRANDT WFE0510K
BRANDT WFE0610
BRANDT WFE0610Q
BRANDT WFE0676E
BRANDT WFE0860K
BRANDT WFE0862U
BRANDT WFE0866A
BRANDT WFE0876E
BRANDT WFE1035E
BRANDT WFE1062K
BRANDT WFE1076E
BRANDT WFE1261K
BRANDT WFE1266A
BRANDT WFE1276E
BRANDT WFE1461K
BRANDT WFE1476E
FAR LF12200
PROLINE L6200
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=3349)) AND ACTIVE=0 ORDER BY (SELECT ISNULL(SUM(SALES_AMOUNT),0) FROM LV_003_12_STINVENS WHERE STOCKREF=IT.LOGICALREF AND INVENNO=-1) DESC
