select m.RecID as id,m.DeviceNumber,m.DeviceDescr,m.MessageCode,m.CodeDescr,m.ValueType,m.StdValue,m.TopLimit,m.LowLimit,m.Ufld1,m.UM from DevMonitor m where m.Domain='{<UserFactoryNum>}' and CodeType='Prod'