求一个聚合的sql语句 本帖最后由 lazygc520 于 2013-04-11 20:52:36 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 count(a.packageno)==》count(distinct a.packageno) 一对多:count(distinct a.packageno) 按照实际效果看,开始说明有误。应该是wh_info和packageno成一对多的关系。求同一wh_info时,对应的packageno的数量。 贴插入数据的SQL及要求结果出来看看 INSERT INTO `kw_manage` (`ID`, `username`, `rkno`, `packageno`, `type`, `cust_no`, `snp`, `wh_info`, `date`) VALUES(1, 'admin', '201304090015', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:39'),(2, 'admin', '201304090015', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:42'),(3, 'admin', '201304090015', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:43'),(4, 'admin', '201304090015', 'VP3.0 130409004', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:45'),(5, 'admin', '201304090015', 'VP3.0 130409005', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:47'),(6, 'admin', '201304090015', 'VP3.0 130409006', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:49'),(7, 'admin', '201304090015', 'VP3.0 130409007', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:53'),(8, 'admin', '201304090015', 'VP3.0 130409008', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:55'),(9, 'admin', '201304090015', 'VP3.0 130409009', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:57'),(10, 'admin', '201304090015', 'VP3.0 130409010', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:22:00'),(11, 'admin', '201304090015', 'VP3.0 130409011', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:22:02'),(12, 'admin', '201304090015', 'VP3.0 130409012', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:22:27');---- 转存表中的数据 `vp_barcode_2d_y`(部分数据)--INSERT INTO `vp_barcode_2d_y` (`ID`, `username`, `packageno`, `hi_no`, `cust_no`, `lotno`, `description`, `type`, `barcode`, `date`) VALUES(135046, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1040', '2013-04-09 08:25:11'),(135047, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1044', '2013-04-09 08:25:13'),(135048, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1050', '2013-04-09 08:25:14'),(135049, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1002', '2013-04-09 08:25:17'),(135050, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1053', '2013-04-09 08:25:18'),(135051, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1049', '2013-04-09 08:25:20'),(135052, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1035', '2013-04-09 08:25:21'),(135053, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1006', '2013-04-09 08:25:25'),(135054, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1034', '2013-04-09 08:25:26'),(135055, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1031', '2013-04-09 08:25:27'),(135056, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0019', '2013-04-09 08:25:29'),(135057, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0030', '2013-04-09 08:25:30'),(135058, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0008', '2013-04-09 08:25:32'),(135059, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0017', '2013-04-09 08:25:34'),(135060, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0031', '2013-04-09 08:25:36'),(135061, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0058', '2013-04-09 08:26:26'),(135062, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0077', '2013-04-09 08:26:28'),(135063, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0099', '2013-04-09 08:26:30'),(135064, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0108', '2013-04-09 08:26:31'),(135065, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0103', '2013-04-09 08:26:32'),(135066, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0090', '2013-04-09 08:26:35'),(135067, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0051', '2013-04-09 08:26:37'),(135068, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0106', '2013-04-09 08:26:41'),(135069, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0101', '2013-04-09 08:26:43'),(135070, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0055', '2013-04-09 08:26:45'),(135071, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0089', '2013-04-09 08:26:46'),(135072, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0105', '2013-04-09 08:26:48'),(135073, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0100', '2013-04-09 08:26:49'),(135074, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0041', '2013-04-09 08:26:51'),(135075, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0068', '2013-04-09 08:26:54'),(135076, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0096', '2013-04-09 08:28:12'),(135077, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0104', '2013-04-09 08:28:14'),(135078, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0122', '2013-04-09 08:28:15'),(135079, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0093', '2013-04-09 08:28:16'),(135080, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0111', '2013-04-09 08:28:18'),(135081, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0070', '2013-04-09 08:28:31'),(135082, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0102', '2013-04-09 08:28:33'),(135083, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0020', '2013-04-09 08:28:39'),(135084, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0129', '2013-04-09 08:28:41'),(135085, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0120', '2013-04-09 08:28:43'),(135086, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0095', '2013-04-09 08:28:44'),(135087, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0109', '2013-04-09 08:28:47'),(135088, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0098', '2013-04-09 08:28:48'),(135089, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0107', '2013-04-09 08:28:49'),(135090, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0092', '2013-04-09 08:29:05'); 求图例中库位对应箱子数量的sql。 SET Date_Format = '%d/%m/%y'; 运行以后报告错误 mysql 如何将多个字段的内容联合成一个字符串? MY SQL 还原数据库问题 谁能帮我把sql文件导出frm,MYD,MYI形式? 建议 group by与distinct [mysqldump] 指令詳解 [文檔] 请教一个mysql的语法问题 我在WIN 2000 Advanced Server 下遇到的安装问题,UP都有分,不够再加 MySQL用BLOB类型存储的图片取出来后失真 mysql 分区问题 求助,我这种情况使用SQLite还是MySQL
和packageno成一对多的关系。求同一wh_info
时,对应的packageno的数量。
INSERT INTO `kw_manage` (`ID`, `username`, `rkno`, `packageno`, `type`, `cust_no`, `snp`, `wh_info`, `date`) VALUES
(1, 'admin', '201304090015', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:39'),
(2, 'admin', '201304090015', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:42'),
(3, 'admin', '201304090015', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:43'),
(4, 'admin', '201304090015', 'VP3.0 130409004', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:45'),
(5, 'admin', '201304090015', 'VP3.0 130409005', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:47'),
(6, 'admin', '201304090015', 'VP3.0 130409006', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:49'),
(7, 'admin', '201304090015', 'VP3.0 130409007', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:53'),
(8, 'admin', '201304090015', 'VP3.0 130409008', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:55'),
(9, 'admin', '201304090015', 'VP3.0 130409009', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:21:57'),
(10, 'admin', '201304090015', 'VP3.0 130409010', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:22:00'),
(11, 'admin', '201304090015', 'VP3.0 130409011', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:22:02'),
(12, 'admin', '201304090015', 'VP3.0 130409012', 'BEM212-500', '23703 EX80A', 15, 'YG-00-01', '2013-04-11 11:22:27');
--
-- 转存表中的数据 `vp_barcode_2d_y`(部分数据)
--INSERT INTO `vp_barcode_2d_y` (`ID`, `username`, `packageno`, `hi_no`, `cust_no`, `lotno`, `description`, `type`, `barcode`, `date`) VALUES
(135046, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1040', '2013-04-09 08:25:11'),
(135047, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1044', '2013-04-09 08:25:13'),
(135048, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1050', '2013-04-09 08:25:14'),
(135049, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1002', '2013-04-09 08:25:17'),
(135050, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1053', '2013-04-09 08:25:18'),
(135051, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1049', '2013-04-09 08:25:20'),
(135052, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1035', '2013-04-09 08:25:21'),
(135053, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1006', '2013-04-09 08:25:25'),
(135054, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1034', '2013-04-09 08:25:26'),
(135055, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3406', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340623703 EX80A1031', '2013-04-09 08:25:27'),
(135056, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0019', '2013-04-09 08:25:29'),
(135057, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0030', '2013-04-09 08:25:30'),
(135058, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0008', '2013-04-09 08:25:32'),
(135059, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0017', '2013-04-09 08:25:34'),
(135060, '00278', 'VP3.0 130409001', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0031', '2013-04-09 08:25:36'),
(135061, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0058', '2013-04-09 08:26:26'),
(135062, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0077', '2013-04-09 08:26:28'),
(135063, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0099', '2013-04-09 08:26:30'),
(135064, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0108', '2013-04-09 08:26:31'),
(135065, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0103', '2013-04-09 08:26:32'),
(135066, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0090', '2013-04-09 08:26:35'),
(135067, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0051', '2013-04-09 08:26:37'),
(135068, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0106', '2013-04-09 08:26:41'),
(135069, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0101', '2013-04-09 08:26:43'),
(135070, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0055', '2013-04-09 08:26:45'),
(135071, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0089', '2013-04-09 08:26:46'),
(135072, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0105', '2013-04-09 08:26:48'),
(135073, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0100', '2013-04-09 08:26:49'),
(135074, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0041', '2013-04-09 08:26:51'),
(135075, '00278', 'VP3.0 130409002', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0068', '2013-04-09 08:26:54'),
(135076, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0096', '2013-04-09 08:28:12'),
(135077, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0104', '2013-04-09 08:28:14'),
(135078, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0122', '2013-04-09 08:28:15'),
(135079, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0093', '2013-04-09 08:28:16'),
(135080, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0111', '2013-04-09 08:28:18'),
(135081, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0070', '2013-04-09 08:28:31'),
(135082, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0102', '2013-04-09 08:28:33'),
(135083, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0020', '2013-04-09 08:28:39'),
(135084, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0129', '2013-04-09 08:28:41'),
(135085, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0120', '2013-04-09 08:28:43'),
(135086, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0095', '2013-04-09 08:28:44'),
(135087, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0109', '2013-04-09 08:28:47'),
(135088, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0098', '2013-04-09 08:28:48'),
(135089, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0107', '2013-04-09 08:28:49'),
(135090, '00278', 'VP3.0 130409003', 'BEM212-500', '23703 EX80A', '3408', 'VP3.0', 'BEM212-500', 'ZLBEM212-500A10000ZL340823703 EX80A0092', '2013-04-09 08:29:05');