Warning: include(../connect_mysql.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\ps_c.php on line 2

Warning: include() [function.include]: Failed opening '../connect_mysql.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\ps_c.php on line 2

Warning: include(../connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\ps_c.php on line 3

Warning: include() [function.include]: Failed opening '../connect.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\ps_c.php on line 3

Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\ps_c.php on line 4

Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\ps_c.php on line 4
http://203.155.18.96/bcweb_services/back/RouteJsonData.aspx?orderdate=20160713


Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\www\mobile\no\_ps\ps_c.php on line 16

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\www\mobile\no\_ps\ps_c.php on line 16
07-13-2016 05:25:20 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,560.00',orderNo='1607135030074',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/E213017' and custDay='7' and custArea='C203' and custNo='V16140007' and mn='07' and yr='2016';Update cust_route set price_buy='2,560.00',orderNo='1607135030074',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/E213017' and custDay='7' and custArea='C203' and custNo='V16140007' and mn='07' and yr='2016';
07-13-2016 05:23:59 PM1970-01-01 07:00:07

Update cust_route set price_buy='656.00',orderNo='1607136010123',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSC/S221006' and custDay='6' and custArea='S201' and custNo='V85120001' and mn='07' and yr='2016';Update cust_route set price_buy='656.00',orderNo='1607136010123',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSC/S221006' and custDay='6' and custArea='S201' and custNo='V85120001' and mn='07' and yr='2016';
07-13-2016 05:23:49 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,098.00',orderNo='1607135030073',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/E213017' and custDay='7' and custArea='C203' and custNo='V16140005' and mn='07' and yr='2016';Update cust_route set price_buy='1,098.00',orderNo='1607135030073',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/E213017' and custDay='7' and custArea='C203' and custNo='V16140005' and mn='07' and yr='2016';
07-13-2016 05:22:24 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,560.00',orderNo='1607135030072',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/E213017' and custDay='7' and custArea='C203' and custNo='V16140004' and mn='07' and yr='2016';Update cust_route set price_buy='2,560.00',orderNo='1607135030072',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/E213017' and custDay='7' and custArea='C203' and custNo='V16140004' and mn='07' and yr='2016';
07-13-2016 05:19:43 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,788.00',orderNo='1607135030071',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/E213017' and custDay='7' and custArea='C203' and custNo='V16140003' and mn='07' and yr='2016';Update cust_route set price_buy='2,788.00',orderNo='1607135030071',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/E213017' and custDay='7' and custArea='C203' and custNo='V16140003' and mn='07' and yr='2016';
07-13-2016 05:18:23 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,376.00',orderNo='1607135030070',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/E213017' and custDay='7' and custArea='C203' and custNo='V16140002' and mn='07' and yr='2016';Update cust_route set price_buy='2,376.00',orderNo='1607135030070',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/E213017' and custDay='7' and custArea='C203' and custNo='V16140002' and mn='07' and yr='2016';
07-13-2016 05:17:15 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,280.00',orderNo='1607132060052',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220019' and mn='07' and yr='2016';Update cust_route set price_buy='2,280.00',orderNo='1607132060052',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220019' and mn='07' and yr='2016';
07-13-2016 05:15:46 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,376.00',orderNo='1607132060051',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220018' and mn='07' and yr='2016';Update cust_route set price_buy='2,376.00',orderNo='1607132060051',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220018' and mn='07' and yr='2016';
07-13-2016 05:14:26 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,208.00',orderNo='1607132060050',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220016' and mn='07' and yr='2016';Update cust_route set price_buy='2,208.00',orderNo='1607132060050',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220016' and mn='07' and yr='2016';
07-13-2016 05:14:23 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,376.00',orderNo='1607135030069',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/E213017' and custDay='7' and custArea='C203' and custNo='V16140001' and mn='07' and yr='2016';Update cust_route set price_buy='2,376.00',orderNo='1607135030069',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/E213017' and custDay='7' and custArea='C203' and custNo='V16140001' and mn='07' and yr='2016';
07-13-2016 05:12:04 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,280.00',orderNo='1607132060049',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220014' and mn='07' and yr='2016';Update cust_route set price_buy='2,280.00',orderNo='1607132060049',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220014' and mn='07' and yr='2016';
07-13-2016 05:07:40 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,824.00',orderNo='1607134050095',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E205' and custNo='V34140002' and mn='07' and yr='2016';Update cust_route set price_buy='1,824.00',orderNo='1607134050095',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E205' and custNo='V34140002' and mn='07' and yr='2016';
07-13-2016 05:05:37 PM1970-01-01 07:00:07

Update cust_route set price_buy='916.00',orderNo='1607134050094',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSN/E222022' and custDay='2' and custArea='N/E205' and custNo='VZ20500103' and mn='07' and yr='2016';Update cust_route set price_buy='916.00',orderNo='1607134050094',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSN/E222022' and custDay='2' and custArea='N/E205' and custNo='VZ20500103' and mn='07' and yr='2016';
07-13-2016 04:56:41 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,736.00',orderNo='1607136010115',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSC/S221003' and custDay='3' and custArea='S201' and custNo='V85000001' and mn='07' and yr='2016';Update cust_route set price_buy='2,736.00',orderNo='1607136010115',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSC/S221003' and custDay='3' and custArea='S201' and custNo='V85000001' and mn='07' and yr='2016';
07-13-2016 04:54:20 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,024.00',orderNo='1607132020066',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB214002' and custDay='2' and custArea='B202' and custNo='VB20200012' and mn='07' and yr='2016';Update cust_route set price_buy='1,024.00',orderNo='1607132020066',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB214002' and custDay='2' and custArea='B202' and custNo='VB20200012' and mn='07' and yr='2016';
07-13-2016 04:53:08 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,024.00',orderNo='1607132020065',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200009' and mn='07' and yr='2016';Update cust_route set price_buy='1,024.00',orderNo='1607132020065',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200009' and mn='07' and yr='2016';
07-13-2016 04:50:57 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,176.00',orderNo='1607132020064',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10500002' and mn='07' and yr='2016';Update cust_route set price_buy='1,176.00',orderNo='1607132020064',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10500002' and mn='07' and yr='2016';
07-13-2016 04:50:56 PM1970-01-01 07:00:07

Update cust_route set price_buy='3,096.00',orderNo='1607136020187',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='S202' and custNo='V92120008' and mn='07' and yr='2016';Update cust_route set price_buy='3,096.00',orderNo='1607136020187',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='S202' and custNo='V92120008' and mn='07' and yr='2016';
07-13-2016 04:49:54 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,536.00',orderNo='1607132020063',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10400002' and mn='07' and yr='2016';Update cust_route set price_buy='1,536.00',orderNo='1607132020063',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10400002' and mn='07' and yr='2016';
07-13-2016 04:48:34 PM1970-01-01 07:00:07

Update cust_route set price_buy='736.00',orderNo='1607134070111',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700039' and mn='07' and yr='2016';Update cust_route set price_buy='736.00',orderNo='1607134070111',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700039' and mn='07' and yr='2016';
07-13-2016 04:48:26 PM1970-01-01 07:00:07

Update cust_route set price_buy='4,788.00',orderNo='1607136020186',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='S202' and custNo='V92120003' and mn='07' and yr='2016';Update cust_route set price_buy='4,788.00',orderNo='1607136020186',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='S202' and custNo='V92120003' and mn='07' and yr='2016';
07-13-2016 04:47:44 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,424.00',orderNo='1607132020062',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB214001' and custDay='1' and custArea='B202' and custNo='V10400004' and mn='07' and yr='2016';Update cust_route set price_buy='1,424.00',orderNo='1607132020062',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB214001' and custDay='1' and custArea='B202' and custNo='V10400004' and mn='07' and yr='2016';
07-13-2016 04:46:06 PM1970-01-01 07:00:07

Update cust_route set price_buy='5,160.00',orderNo='1607136020185',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='9' and custRoute='VSC/S224009' and custDay='9' and custArea='S202' and custNo='V92120004' and mn='07' and yr='2016';Update cust_route set price_buy='5,160.00',orderNo='1607136020185',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='9' and custRoute='VSC/S224009' and custDay='9' and custArea='S202' and custNo='V92120004' and mn='07' and yr='2016';
07-13-2016 04:45:20 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,356.00',orderNo='1607132020061',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB214001' and custDay='1' and custArea='B202' and custNo='V10400001' and mn='07' and yr='2016';Update cust_route set price_buy='1,356.00',orderNo='1607132020061',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB214001' and custDay='1' and custArea='B202' and custNo='V10400001' and mn='07' and yr='2016';
07-13-2016 04:16:07 PM1970-01-01 07:00:07

Update cust_route set price_buy='3,796.00',orderNo='1607133040099',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N204' and custNo='V63110008' and mn='07' and yr='2016';Update cust_route set price_buy='3,796.00',orderNo='1607133040099',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N204' and custNo='V63110008' and mn='07' and yr='2016';
07-13-2016 04:14:08 PM1970-01-01 07:00:07

Update cust_route set price_buy='396.00',orderNo='1607134070110',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700038' and mn='07' and yr='2016';Update cust_route set price_buy='396.00',orderNo='1607134070110',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700038' and mn='07' and yr='2016';
07-13-2016 04:13:17 PM1970-01-01 07:00:07

Update cust_route set price_buy='8,975.00',orderNo='1607133020077',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='1' and custRoute='VSN213011' and custDay='1' and custArea='N202' and custNo='V58120004' and mn='07' and yr='2016';Update cust_route set price_buy='8,975.00',orderNo='1607133020077',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='1' and custRoute='VSN213011' and custDay='1' and custArea='N202' and custNo='V58120004' and mn='07' and yr='2016';
07-13-2016 04:11:59 PM1970-01-01 07:00:07

Update cust_route set price_buy='328.00',orderNo='1607134020130',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200076' and mn='07' and yr='2016';Update cust_route set price_buy='328.00',orderNo='1607134020130',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200076' and mn='07' and yr='2016';
07-13-2016 04:11:26 PM1970-01-01 07:00:07

Update cust_route set price_buy='198.00',orderNo='1607134020129',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200077' and mn='07' and yr='2016';Update cust_route set price_buy='198.00',orderNo='1607134020129',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200077' and mn='07' and yr='2016';
07-13-2016 04:06:54 PM1970-01-01 07:00:07

Update cust_route set price_buy='990.00',orderNo='1607134070108',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700033' and mn='07' and yr='2016';Update cust_route set price_buy='990.00',orderNo='1607134070108',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700033' and mn='07' and yr='2016';
07-13-2016 03:58:57 PM1970-01-01 07:00:07

Update cust_route set price_buy='328.00',orderNo='1607134040133',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E204' and custNo='VZ20400131' and mn='07' and yr='2016';Update cust_route set price_buy='328.00',orderNo='1607134040133',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E204' and custNo='VZ20400131' and mn='07' and yr='2016';
07-13-2016 03:40:33 PM1970-01-01 07:00:07

Update cust_route set price_buy='684.00',orderNo='1607138030076',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='E203' and custNo='VE20300012' and mn='07' and yr='2016';Update cust_route set price_buy='684.00',orderNo='1607138030076',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='E203' and custNo='VE20300012' and mn='07' and yr='2016';
07-13-2016 03:39:51 PM1970-01-01 07:00:07

Update cust_route set price_buy='12,860.00',orderNo='1607138030075',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E224022' and custDay='2' and custArea='E203' and custNo='V24160010' and mn='07' and yr='2016';Update cust_route set price_buy='12,860.00',orderNo='1607138030075',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E224022' and custDay='2' and custArea='E203' and custNo='V24160010' and mn='07' and yr='2016';
07-13-2016 03:37:55 PM1970-01-01 07:00:07

Update cust_route set price_buy='3,516.00',orderNo='1607138030074',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='E203' and custNo='V24160009' and mn='07' and yr='2016';Update cust_route set price_buy='3,516.00',orderNo='1607138030074',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='E203' and custNo='V24160009' and mn='07' and yr='2016';
07-13-2016 03:37:43 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,472.00',orderNo='1607134070107',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700044' and mn='07' and yr='2016';Update cust_route set price_buy='1,472.00',orderNo='1607134070107',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700044' and mn='07' and yr='2016';
07-13-2016 03:33:56 PM1970-01-01 07:00:07

Update cust_route set price_buy='770.00',orderNo='1607134070106',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700026' and mn='07' and yr='2016';Update cust_route set price_buy='770.00',orderNo='1607134070106',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700026' and mn='07' and yr='2016';
07-13-2016 03:28:00 PM1970-01-01 07:00:07

Update cust_route set price_buy='3,072.00',orderNo='1607135040084',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSC/E215003' and custDay='3' and custArea='C204' and custNo='V13150001' and mn='07' and yr='2016';Update cust_route set price_buy='3,072.00',orderNo='1607135040084',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSC/E215003' and custDay='3' and custArea='C204' and custNo='V13150001' and mn='07' and yr='2016';
07-13-2016 03:25:55 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,784.00',orderNo='1607134010090',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='4' and custRoute='VSN/E211014' and custDay='4' and custArea='N/E201' and custNo='VZ20100070' and mn='07' and yr='2016';Update cust_route set price_buy='2,784.00',orderNo='1607134010090',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='4' and custRoute='VSN/E211014' and custDay='4' and custArea='N/E201' and custNo='VZ20100070' and mn='07' and yr='2016';
07-13-2016 03:23:45 PM1970-01-01 07:00:07

Update cust_route set price_buy='4,986.00',orderNo='1607133020076',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N202' and custNo='V58120003' and mn='07' and yr='2016';Update cust_route set price_buy='4,986.00',orderNo='1607133020076',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N202' and custNo='V58120003' and mn='07' and yr='2016';
07-13-2016 03:19:46 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,980.00',orderNo='1607134070105',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700045' and mn='07' and yr='2016';Update cust_route set price_buy='1,980.00',orderNo='1607134070105',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700045' and mn='07' and yr='2016';
07-13-2016 03:00:28 PM1970-01-01 07:00:07

Update cust_route set price_buy='594.00',orderNo='1607135040083',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='1' and custRoute='VSC/E215011' and custDay='1' and custArea='C204' and custNo='V13240002' and mn='07' and yr='2016';Update cust_route set price_buy='594.00',orderNo='1607135040083',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='1' and custRoute='VSC/E215011' and custDay='1' and custArea='C204' and custNo='V13240002' and mn='07' and yr='2016';
07-13-2016 02:58:50 PM1970-01-01 07:00:07

Update cust_route set price_buy='516.00',orderNo='1607132040062',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSB215003' and custDay='3' and custArea='B204' and custNo='VB20400011' and mn='07' and yr='2016';Update cust_route set price_buy='516.00',orderNo='1607132040062',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSB215003' and custDay='3' and custArea='B204' and custNo='VB20400011' and mn='07' and yr='2016';
07-13-2016 02:58:07 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,220.00',orderNo='1607132040061',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='' and custDay='' and custArea='B204' and custNo='V11000011' and mn='07' and yr='2016';Update cust_route set price_buy='2,220.00',orderNo='1607132040061',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='' and custDay='' and custArea='B204' and custNo='V11000011' and mn='07' and yr='2016';
07-13-2016 02:56:31 PM1970-01-01 07:00:07

Update cust_route set price_buy='4,492.00',orderNo='1607132040060',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB215003' and custDay='3' and custArea='B204' and custNo='V11000010' and mn='07' and yr='2016';Update cust_route set price_buy='4,492.00',orderNo='1607132040060',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB215003' and custDay='3' and custArea='B204' and custNo='V11000010' and mn='07' and yr='2016';
07-13-2016 02:56:04 PM1970-01-01 07:00:07

Update cust_route set price_buy='4,554.00',orderNo='1607136030175',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSC/S216023' and custDay='3' and custArea='S203' and custNo='V84000008' and mn='07' and yr='2016';Update cust_route set price_buy='4,554.00',orderNo='1607136030175',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSC/S216023' and custDay='3' and custArea='S203' and custNo='V84000008' and mn='07' and yr='2016';
07-13-2016 02:55:41 PM1970-01-01 07:00:07

Update cust_route set price_buy='3,968.00',orderNo='1607132100140',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB224006' and custDay='6' and custArea='B208' and custNo='V10530004' and mn='07' and yr='2016';Update cust_route set price_buy='3,968.00',orderNo='1607132100140',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB224006' and custDay='6' and custArea='B208' and custNo='V10530004' and mn='07' and yr='2016';
07-13-2016 02:55:06 PM1970-01-01 07:00:07

Update cust_route set price_buy='4,554.00',orderNo='1607136030174',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='S203' and custNo='V84000005' and mn='07' and yr='2016';Update cust_route set price_buy='4,554.00',orderNo='1607136030174',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='S203' and custNo='V84000005' and mn='07' and yr='2016';
07-13-2016 02:52:27 PM1970-01-01 07:00:07

Update cust_route set price_buy='4,566.00',orderNo='1607136030173',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='S203' and custNo='V84130011' and mn='07' and yr='2016';Update cust_route set price_buy='4,566.00',orderNo='1607136030173',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='S203' and custNo='V84130011' and mn='07' and yr='2016';
07-13-2016 02:46:13 PM1970-01-01 07:00:07

Update cust_route set price_buy='4,554.00',orderNo='1607136030172',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/S216017' and custDay='7' and custArea='S203' and custNo='V84350003' and mn='07' and yr='2016';Update cust_route set price_buy='4,554.00',orderNo='1607136030172',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSC/S216017' and custDay='7' and custArea='S203' and custNo='V84350003' and mn='07' and yr='2016';
07-13-2016 02:30:38 PM1970-01-01 07:00:07

Update cust_route set price_buy='4,458.00',orderNo='1607135040081',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='1' and custRoute='VSC/E215011' and custDay='1' and custArea='C204' and custNo='V13240003' and mn='07' and yr='2016';Update cust_route set price_buy='4,458.00',orderNo='1607135040081',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='1' and custRoute='VSC/E215011' and custDay='1' and custArea='C204' and custNo='V13240003' and mn='07' and yr='2016';
07-13-2016 02:25:11 PM1970-01-01 07:00:07

Update cust_route set price_buy='198.00',orderNo='1607134010087',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='VZ20100056' and mn='07' and yr='2016';Update cust_route set price_buy='198.00',orderNo='1607134010087',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='VZ20100056' and mn='07' and yr='2016';
07-13-2016 02:23:25 PM1970-01-01 07:00:07

Update cust_route set price_buy='198.00',orderNo='1607134010086',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100055' and mn='07' and yr='2016';Update cust_route set price_buy='198.00',orderNo='1607134010086',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100055' and mn='07' and yr='2016';
07-13-2016 02:22:05 PM1970-01-01 07:00:07

Update cust_route set price_buy='198.00',orderNo='1607134010085',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100054' and mn='07' and yr='2016';Update cust_route set price_buy='198.00',orderNo='1607134010085',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100054' and mn='07' and yr='2016';
07-13-2016 02:18:43 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,960.00',orderNo='1607134050093',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='8' and custRoute='VSN/E226018' and custDay='8' and custArea='N/E205' and custNo='V37000042' and mn='07' and yr='2016';Update cust_route set price_buy='2,960.00',orderNo='1607134050093',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='8' and custRoute='VSN/E226018' and custDay='8' and custArea='N/E205' and custNo='V37000042' and mn='07' and yr='2016';
07-13-2016 02:18:25 PM1970-01-01 07:00:07

Update cust_route set price_buy='6,600.00',orderNo='1607133020075',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N202' and custNo='V58120001' and mn='07' and yr='2016';Update cust_route set price_buy='6,600.00',orderNo='1607133020075',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N202' and custNo='V58120001' and mn='07' and yr='2016';
07-13-2016 02:18:10 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,960.00',orderNo='1607134050093',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='8' and custRoute='VSN/E226018' and custDay='8' and custArea='N/E205' and custNo='V37000042' and mn='07' and yr='2016';Update cust_route set price_buy='2,960.00',orderNo='1607134050093',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='8' and custRoute='VSN/E226018' and custDay='8' and custArea='N/E205' and custNo='V37000042' and mn='07' and yr='2016';
07-13-2016 02:18:08 PM1970-01-01 07:00:07

Update cust_route set price_buy='6,840.00',orderNo='1607132030038',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='11' and custRoute='' and custDay='' and custArea='B203' and custNo='V10600005' and mn='07' and yr='2016';Update cust_route set price_buy='6,840.00',orderNo='1607132030038',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='11' and custRoute='' and custDay='' and custArea='B203' and custNo='V10600005' and mn='07' and yr='2016';
07-13-2016 02:17:59 PM1970-01-01 07:00:07

Update cust_route set price_buy='198.00',orderNo='1607134070104',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700042' and mn='07' and yr='2016';Update cust_route set price_buy='198.00',orderNo='1607134070104',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700042' and mn='07' and yr='2016';
07-13-2016 02:16:45 PM1970-01-01 07:00:07

Update cust_route set price_buy='6,936.00',orderNo='1607132030037',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='11' and custRoute='VSB213007' and custDay='7' and custArea='B203' and custNo='V10600003' and mn='07' and yr='2016';Update cust_route set price_buy='6,936.00',orderNo='1607132030037',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='11' and custRoute='VSB213007' and custDay='7' and custArea='B203' and custNo='V10600003' and mn='07' and yr='2016';
07-13-2016 02:06:42 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,904.00',orderNo='1607132100139',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='' and custDay='' and custArea='B208' and custNo='V10530009' and mn='07' and yr='2016';Update cust_route set price_buy='2,904.00',orderNo='1607132100139',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='' and custDay='' and custArea='B208' and custNo='V10530009' and mn='07' and yr='2016';
07-13-2016 02:04:29 PM1970-01-01 07:00:07

Update cust_route set price_buy='3,016.00',orderNo='1607132100138',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224001' and custDay='1' and custArea='B208' and custNo='V10530002' and mn='07' and yr='2016';Update cust_route set price_buy='3,016.00',orderNo='1607132100138',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224001' and custDay='1' and custArea='B208' and custNo='V10530002' and mn='07' and yr='2016';
07-13-2016 02:03:02 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,618.00',orderNo='1607134010083',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='V41220006' and mn='07' and yr='2016';Update cust_route set price_buy='1,618.00',orderNo='1607134010083',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='V41220006' and mn='07' and yr='2016';
07-13-2016 02:01:39 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,788.00',orderNo='1607134060170',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='9' and custRoute='VSN/E227019' and custDay='9' and custArea='N/E206' and custNo='V33190001' and mn='07' and yr='2016';Update cust_route set price_buy='2,788.00',orderNo='1607134060170',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='9' and custRoute='VSN/E227019' and custDay='9' and custArea='N/E206' and custNo='V33190001' and mn='07' and yr='2016';
07-13-2016 02:00:41 PM1970-01-01 07:00:07

Update cust_route set price_buy='512.00',orderNo='1607134010082',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='VZ20100058' and mn='07' and yr='2016';Update cust_route set price_buy='512.00',orderNo='1607134010082',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='VZ20100058' and mn='07' and yr='2016';
07-13-2016 01:56:05 PM1970-01-01 07:00:07

Update cust_route set price_buy='5,964.00',orderNo='1607134040131',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSN/E224012' and custDay='2' and custArea='N/E204' and custNo='V44210002' and mn='07' and yr='2016';Update cust_route set price_buy='5,964.00',orderNo='1607134040131',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSN/E224012' and custDay='2' and custArea='N/E204' and custNo='V44210002' and mn='07' and yr='2016';
07-13-2016 01:51:20 PM1970-01-01 07:00:07

Update cust_route set price_buy='4,536.00',orderNo='1607132030036',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='11' and custRoute='' and custDay='' and custArea='B203' and custNo='V10600008' and mn='07' and yr='2016';Update cust_route set price_buy='4,536.00',orderNo='1607132030036',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='11' and custRoute='' and custDay='' and custArea='B203' and custNo='V10600008' and mn='07' and yr='2016';
07-13-2016 01:48:09 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,296.00',orderNo='1607136010111',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSC/S221006' and custDay='6' and custArea='S201' and custNo='V85120004' and mn='07' and yr='2016';Update cust_route set price_buy='2,296.00',orderNo='1607136010111',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSC/S221006' and custDay='6' and custArea='S201' and custNo='V85120004' and mn='07' and yr='2016';
07-13-2016 01:08:14 PM1970-01-01 07:00:07

Update cust_route set price_buy='256.00',orderNo='1607134060169',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSN/E227006' and custDay='6' and custArea='N/E206' and custNo='VZ20600103' and mn='07' and yr='2016';Update cust_route set price_buy='256.00',orderNo='1607134060169',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSN/E227006' and custDay='6' and custArea='N/E206' and custNo='VZ20600103' and mn='07' and yr='2016';
07-13-2016 01:07:01 PM1970-01-01 07:00:07

Update cust_route set price_buy='512.00',orderNo='1607134010081',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='V41220013' and mn='07' and yr='2016';Update cust_route set price_buy='512.00',orderNo='1607134010081',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='V41220013' and mn='07' and yr='2016';
07-13-2016 01:06:14 PM1970-01-01 07:00:07

Update cust_route set price_buy='684.00',orderNo='1607134040129',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSN/E224012' and custDay='2' and custArea='N/E204' and custNo='V44210001' and mn='07' and yr='2016';Update cust_route set price_buy='684.00',orderNo='1607134040129',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSN/E224012' and custDay='2' and custArea='N/E204' and custNo='V44210001' and mn='07' and yr='2016';
07-13-2016 01:04:44 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,840.00',orderNo='1607134040128',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSN/E224010' and custDay='0' and custArea='N/E204' and custNo='V44110001' and mn='07' and yr='2016';Update cust_route set price_buy='2,840.00',orderNo='1607134040128',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSN/E224010' and custDay='0' and custArea='N/E204' and custNo='V44110001' and mn='07' and yr='2016';
07-13-2016 01:04:02 PM1970-01-01 07:00:07

Update cust_route set price_buy='4,486.00',orderNo='1607138050069',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='E205' and custNo='V20110010' and mn='07' and yr='2016';Update cust_route set price_buy='4,486.00',orderNo='1607138050069',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='E205' and custNo='V20110010' and mn='07' and yr='2016';
07-13-2016 12:54:36 PM1970-01-01 07:00:07

Update cust_route set price_buy='256.00',orderNo='1607134060168',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E227013' and custDay='3' and custArea='N/E206' and custNo='V33220003' and mn='07' and yr='2016';Update cust_route set price_buy='256.00',orderNo='1607134060168',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E227013' and custDay='3' and custArea='N/E206' and custNo='V33220003' and mn='07' and yr='2016';
07-13-2016 12:53:34 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,098.00',orderNo='1607132100137',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSB224006' and custDay='6' and custArea='B208' and custNo='V10530006' and mn='07' and yr='2016';Update cust_route set price_buy='1,098.00',orderNo='1607132100137',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSB224006' and custDay='6' and custArea='B208' and custNo='V10530006' and mn='07' and yr='2016';
07-13-2016 12:51:50 PM1970-01-01 07:00:07

Update cust_route set price_buy='256.00',orderNo='1607134060167',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E227013' and custDay='3' and custArea='N/E206' and custNo='V33220002' and mn='07' and yr='2016';Update cust_route set price_buy='256.00',orderNo='1607134060167',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E227013' and custDay='3' and custArea='N/E206' and custNo='V33220002' and mn='07' and yr='2016';
07-13-2016 12:49:33 PM1970-01-01 07:00:07

Update cust_route set price_buy='256.00',orderNo='1607134060166',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E227013' and custDay='3' and custArea='N/E206' and custNo='V33220001' and mn='07' and yr='2016';Update cust_route set price_buy='256.00',orderNo='1607134060166',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E227013' and custDay='3' and custArea='N/E206' and custNo='V33220001' and mn='07' and yr='2016';
07-13-2016 12:49:25 PM1970-01-01 07:00:07

Update cust_route set price_buy='4,584.00',orderNo='1607132070072',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270011' and mn='07' and yr='2016';Update cust_route set price_buy='4,584.00',orderNo='1607132070072',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270011' and mn='07' and yr='2016';
07-13-2016 12:48:49 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='V33160004' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='V33160004' and mn='07' and yr='2016';
07-13-2016 12:48:10 PM1970-01-01 07:00:07

Update cust_route set price_buy='256.00',orderNo='1607134060165',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E227013' and custDay='3' and custArea='N/E206' and custNo='VZ20600111' and mn='07' and yr='2016';Update cust_route set price_buy='256.00',orderNo='1607134060165',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E227013' and custDay='3' and custArea='N/E206' and custNo='VZ20600111' and mn='07' and yr='2016';
07-13-2016 12:42:28 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100061' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100061' and mn='07' and yr='2016';
07-13-2016 12:36:24 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้ามาส่งช้า' WHERE myDay='6' and custRoute='VSN/E211016' and custDay='6' and custArea='N/E201' and custNo='V41340001' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้ามาส่งช้า' WHERE myDay='6' and custRoute='VSN/E211016' and custDay='6' and custArea='N/E201' and custNo='V41340001' and mn='07' and yr='2016';
07-13-2016 12:36:03 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='V41340002' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='V41340002' and mn='07' and yr='2016';
07-13-2016 12:35:12 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100062' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100062' and mn='07' and yr='2016';
07-13-2016 12:35:00 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='VZ20100063' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='VZ20100063' and mn='07' and yr='2016';
07-13-2016 12:34:21 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='V41340003' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='V41340003' and mn='07' and yr='2016';
07-13-2016 12:34:02 PM1970-01-01 07:00:07

Update cust_route set price_buy='3,208.00',orderNo='1607134050091',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSN/E222006' and custDay='6' and custArea='N/E205' and custNo='V34140004' and mn='07' and yr='2016';Update cust_route set price_buy='3,208.00',orderNo='1607134050091',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSN/E222006' and custDay='6' and custArea='N/E205' and custNo='V34140004' and mn='07' and yr='2016';
07-13-2016 12:29:34 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,024.00',orderNo='1607134020121',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200058' and mn='07' and yr='2016';Update cust_route set price_buy='1,024.00',orderNo='1607134020121',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200058' and mn='07' and yr='2016';
07-13-2016 12:28:47 PM1970-01-01 07:00:07

Update cust_route set price_buy='512.00',orderNo='1607134020120',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200056' and mn='07' and yr='2016';Update cust_route set price_buy='512.00',orderNo='1607134020120',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200056' and mn='07' and yr='2016';
07-13-2016 12:28:13 PM1970-01-01 07:00:07

Update cust_route set price_buy='456.00',orderNo='1607134020119',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200055' and mn='07' and yr='2016';Update cust_route set price_buy='456.00',orderNo='1607134020119',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200055' and mn='07' and yr='2016';
07-13-2016 12:27:30 PM1970-01-01 07:00:07

Update cust_route set price_buy='702.00',orderNo='1607134020118',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200054' and mn='07' and yr='2016';Update cust_route set price_buy='702.00',orderNo='1607134020118',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200054' and mn='07' and yr='2016';
07-13-2016 12:26:49 PM1970-01-01 07:00:07

Update cust_route set price_buy='198.00',orderNo='1607134020117',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200053' and mn='07' and yr='2016';Update cust_route set price_buy='198.00',orderNo='1607134020117',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200053' and mn='07' and yr='2016';
07-13-2016 12:25:42 PM1970-01-01 07:00:07

Update cust_route set price_buy='736.00',orderNo='1607134020116',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200066' and mn='07' and yr='2016';Update cust_route set price_buy='736.00',orderNo='1607134020116',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E202' and custNo='VZ20200066' and mn='07' and yr='2016';
07-13-2016 12:22:55 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,462.00',orderNo='1607138020060',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E216012' and custDay='2' and custArea='E202' and custNo='V18110002' and mn='07' and yr='2016';Update cust_route set price_buy='2,462.00',orderNo='1607138020060',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E216012' and custDay='2' and custArea='E202' and custNo='V18110002' and mn='07' and yr='2016';
07-13-2016 12:22:28 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='V33160005' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='V33160005' and mn='07' and yr='2016';
07-13-2016 12:21:37 PM1970-01-01 07:00:07

Update cust_route set price_buy='256.00',orderNo='1607134060164',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='5' and custRoute='VSN/E227005' and custDay='5' and custArea='N/E206' and custNo='VZ20600102' and mn='07' and yr='2016';Update cust_route set price_buy='256.00',orderNo='1607134060164',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='5' and custRoute='VSN/E227005' and custDay='5' and custArea='N/E206' and custNo='VZ20600102' and mn='07' and yr='2016';
07-13-2016 12:20:24 PM1970-01-01 07:00:07

Update cust_route set price_buy='256.00',orderNo='1607134060163',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='VZ20600101' and mn='07' and yr='2016';Update cust_route set price_buy='256.00',orderNo='1607134060163',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='VZ20600101' and mn='07' and yr='2016';
07-13-2016 12:20:01 PM1970-01-01 07:00:07

Update cust_route set price_buy='256.00',orderNo='1607134060162',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='VZ20600100' and mn='07' and yr='2016';Update cust_route set price_buy='256.00',orderNo='1607134060162',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='VZ20600100' and mn='07' and yr='2016';
07-13-2016 12:17:32 PM1970-01-01 07:00:07

Update cust_route set price_buy='351.00',orderNo='1607134050090',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSN/E222006' and custDay='6' and custArea='N/E205' and custNo='V34140001' and mn='07' and yr='2016';Update cust_route set price_buy='351.00',orderNo='1607134050090',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSN/E222006' and custDay='6' and custArea='N/E205' and custNo='V34140001' and mn='07' and yr='2016';
07-13-2016 12:17:25 PM1970-01-01 07:00:07

Update cust_route set price_buy='256.00',orderNo='1607134060161',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='VZ20600099' and mn='07' and yr='2016';Update cust_route set price_buy='256.00',orderNo='1607134060161',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='VZ20600099' and mn='07' and yr='2016';
07-13-2016 12:17:02 PM1970-01-01 07:00:07

Update cust_route set price_buy='256.00',orderNo='1607134060160',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='VZ20600098' and mn='07' and yr='2016';Update cust_route set price_buy='256.00',orderNo='1607134060160',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='VZ20600098' and mn='07' and yr='2016';
07-13-2016 12:16:21 PM1970-01-01 07:00:07

Update cust_route set price_buy='5,052.00',orderNo='1607138020059',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E216012' and custDay='2' and custArea='E202' and custNo='V18110015' and mn='07' and yr='2016';Update cust_route set price_buy='5,052.00',orderNo='1607138020059',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E216012' and custDay='2' and custArea='E202' and custNo='V18110015' and mn='07' and yr='2016';
07-13-2016 12:12:33 PM1970-01-01 07:00:07

Update cust_route set price_buy='1,024.00',orderNo='1607134060158',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='VZ20600097' and mn='07' and yr='2016';Update cust_route set price_buy='1,024.00',orderNo='1607134060158',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E206' and custNo='VZ20600097' and mn='07' and yr='2016';
07-13-2016 12:11:56 PM1970-01-01 07:00:07

Update cust_route set price_buy='256.00',orderNo='1607134060157',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='5' and custRoute='VSN/E227005' and custDay='5' and custArea='N/E206' and custNo='VZ20600096' and mn='07' and yr='2016';Update cust_route set price_buy='256.00',orderNo='1607134060157',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='5' and custRoute='VSN/E227005' and custDay='5' and custArea='N/E206' and custNo='VZ20600096' and mn='07' and yr='2016';
07-13-2016 12:11:00 PM1970-01-01 07:00:07

Update cust_route set price_buy='198.00',orderNo='1607134060156',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='5' and custRoute='VSN/E227005' and custDay='5' and custArea='N/E206' and custNo='VZ20600095' and mn='07' and yr='2016';Update cust_route set price_buy='198.00',orderNo='1607134060156',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='5' and custRoute='VSN/E227005' and custDay='5' and custArea='N/E206' and custNo='VZ20600095' and mn='07' and yr='2016';
07-13-2016 12:09:34 PM1970-01-01 07:00:07

Update cust_route set price_buy='2,236.00',orderNo='1607138020058',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E216012' and custDay='2' and custArea='E202' and custNo='VE20200038' and mn='07' and yr='2016';Update cust_route set price_buy='2,236.00',orderNo='1607138020058',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E216012' and custDay='2' and custArea='E202' and custNo='VE20200038' and mn='07' and yr='2016';
07-13-2016 12:08:38 PM1970-01-01 07:00:07

Update cust_route set price_buy='4,492.00',orderNo='1607134050089',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSN/E222006' and custDay='6' and custArea='N/E205' and custNo='V34140003' and mn='07' and yr='2016';Update cust_route set price_buy='4,492.00',orderNo='1607134050089',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSN/E222006' and custDay='6' and custArea='N/E205' and custNo='V34140003' and mn='07' and yr='2016';
07-13-2016 12:06:13 PM1970-01-01 07:00:07

Update cust_route set price_buy='990.00',orderNo='1607138020057',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E216012' and custDay='2' and custArea='E202' and custNo='VE20200037' and mn='07' and yr='2016';Update cust_route set price_buy='990.00',orderNo='1607138020057',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E216012' and custDay='2' and custArea='E202' and custNo='VE20200037' and mn='07' and yr='2016';
07-13-2016 12:02:01 PM1970-01-01 07:00:07

Update cust_route set price_buy='5,120.00',orderNo='1607138020056',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E216012' and custDay='2' and custArea='E202' and custNo='V18110006' and mn='07' and yr='2016';Update cust_route set price_buy='5,120.00',orderNo='1607138020056',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E216012' and custDay='2' and custArea='E202' and custNo='V18110006' and mn='07' and yr='2016';
07-13-2016 11:58:17 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='2' and custRoute='VSC/E216012' and custDay='2' and custArea='E202' and custNo='V18110003' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='2' and custRoute='VSC/E216012' and custDay='2' and custArea='E202' and custNo='V18110003' and mn='07' and yr='2016';
07-13-2016 11:54:03 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,140.00',orderNo='1607132010059',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='9' and custRoute='' and custDay='' and custArea='B201' and custNo='V10160018' and mn='07' and yr='2016';Update cust_route set price_buy='1,140.00',orderNo='1607132010059',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='9' and custRoute='' and custDay='' and custArea='B201' and custNo='V10160018' and mn='07' and yr='2016';
07-13-2016 11:45:56 AM1970-01-01 07:00:07

Update cust_route set price_buy='512.00',orderNo='1607132100136',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510011' and mn='07' and yr='2016';Update cust_route set price_buy='512.00',orderNo='1607132100136',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510011' and mn='07' and yr='2016';
07-13-2016 11:44:39 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='E203' and custNo='V24120006' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='E203' and custNo='V24120006' and mn='07' and yr='2016';
07-13-2016 11:44:32 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='8' and custRoute='VSC/E224018' and custDay='8' and custArea='E203' and custNo='V24120004' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='8' and custRoute='VSC/E224018' and custDay='8' and custArea='E203' and custNo='V24120004' and mn='07' and yr='2016';
07-13-2016 11:44:00 AM1970-01-01 07:00:07

Update cust_route set price_buy='4,074.00',orderNo='1607138030073',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='9' and custRoute='VSC/E224019' and custDay='9' and custArea='E203' and custNo='V24120005' and mn='07' and yr='2016';Update cust_route set price_buy='4,074.00',orderNo='1607138030073',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='9' and custRoute='VSC/E224019' and custDay='9' and custArea='E203' and custNo='V24120005' and mn='07' and yr='2016';
07-13-2016 11:41:16 AM1970-01-01 07:00:07

Update cust_route set price_buy='736.00',orderNo='1607134050088',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E205' and custNo='V34000025' and mn='07' and yr='2016';Update cust_route set price_buy='736.00',orderNo='1607134050088',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E205' and custNo='V34000025' and mn='07' and yr='2016';
07-13-2016 11:40:16 AM1970-01-01 07:00:07

Update cust_route set price_buy='644.00',orderNo='1607134050087',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E205' and custNo='VZ20500075' and mn='07' and yr='2016';Update cust_route set price_buy='644.00',orderNo='1607134050087',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E205' and custNo='VZ20500075' and mn='07' and yr='2016';
07-13-2016 11:37:37 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510007' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510007' and mn='07' and yr='2016';
07-13-2016 11:37:05 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B208' and custNo='V10510014' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B208' and custNo='V10510014' and mn='07' and yr='2016';
07-13-2016 11:36:13 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510018' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510018' and mn='07' and yr='2016';
07-13-2016 11:35:59 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510026' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510026' and mn='07' and yr='2016';
07-13-2016 11:35:40 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB224004' and custDay='4' and custArea='B208' and custNo='V10510035' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB224004' and custDay='4' and custArea='B208' and custNo='V10510035' and mn='07' and yr='2016';
07-13-2016 11:35:30 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB224004' and custDay='4' and custArea='B208' and custNo='V10510038' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB224004' and custDay='4' and custArea='B208' and custNo='V10510038' and mn='07' and yr='2016';
07-13-2016 11:33:09 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,192.00',orderNo='1607134050086',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='4' and custRoute='VSN/E222004' and custDay='4' and custArea='N/E205' and custNo='V34000010' and mn='07' and yr='2016';Update cust_route set price_buy='1,192.00',orderNo='1607134050086',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='4' and custRoute='VSN/E222004' and custDay='4' and custArea='N/E205' and custNo='V34000010' and mn='07' and yr='2016';
07-13-2016 11:33:02 AM1970-01-01 07:00:07

Update cust_route set price_buy='2,808.00',orderNo='1607132100135',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224006' and custDay='6' and custArea='B208' and custNo='V10530017' and mn='07' and yr='2016';Update cust_route set price_buy='2,808.00',orderNo='1607132100135',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224006' and custDay='6' and custArea='B208' and custNo='V10530017' and mn='07' and yr='2016';
07-13-2016 11:30:56 AM1970-01-01 07:00:07

Update cust_route set price_buy='2,208.00',orderNo='1607136050161',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='S205' and custNo='V94000024' and mn='07' and yr='2016';Update cust_route set price_buy='2,208.00',orderNo='1607136050161',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='S205' and custNo='V94000024' and mn='07' and yr='2016';
07-13-2016 11:30:30 AM1970-01-01 07:00:07

Update cust_route set price_buy='516.00',orderNo='1607132100134',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510010' and mn='07' and yr='2016';Update cust_route set price_buy='516.00',orderNo='1607132100134',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510010' and mn='07' and yr='2016';
07-13-2016 11:30:06 AM1970-01-01 07:00:07

Update cust_route set price_buy='6,758.00',orderNo='1607136050160',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='1' and custRoute='VSC/S227001' and custDay='1' and custArea='S205' and custNo='V94000009' and mn='07' and yr='2016';Update cust_route set price_buy='6,758.00',orderNo='1607136050160',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='1' and custRoute='VSC/S227001' and custDay='1' and custArea='S205' and custNo='V94000009' and mn='07' and yr='2016';
07-13-2016 11:29:26 AM1970-01-01 07:00:07

Update cust_route set price_buy='968.00',orderNo='1607132100133',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510008' and mn='07' and yr='2016';Update cust_route set price_buy='968.00',orderNo='1607132100133',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510008' and mn='07' and yr='2016';
07-13-2016 11:28:54 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้ามาส่งช้า' WHERE myDay='' and custRoute='' and custDay='' and custArea='S205' and custNo='VS20500021' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้ามาส่งช้า' WHERE myDay='' and custRoute='' and custDay='' and custArea='S205' and custNo='VS20500021' and mn='07' and yr='2016';
07-13-2016 11:28:32 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='1' and custRoute='VSC/S227001' and custDay='1' and custArea='S205' and custNo='V94000008' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='1' and custRoute='VSC/S227001' and custDay='1' and custArea='S205' and custNo='V94000008' and mn='07' and yr='2016';
07-13-2016 11:28:23 AM1970-01-01 07:00:07

Update cust_route set price_buy='2,339.00',orderNo='1607132050080',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='' and custDay='' and custArea='B205' and custNo='V12120021' and mn='07' and yr='2016';Update cust_route set price_buy='2,339.00',orderNo='1607132050080',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='' and custDay='' and custArea='B205' and custNo='V12120021' and mn='07' and yr='2016';
07-13-2016 11:28:18 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,214.00',orderNo='1607132100132',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B208' and custNo='V10510009' and mn='07' and yr='2016';Update cust_route set price_buy='1,214.00',orderNo='1607132100132',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B208' and custNo='V10510009' and mn='07' and yr='2016';
07-13-2016 11:24:37 AM1970-01-01 07:00:07

Update cust_route set price_buy='2,328.00',orderNo='1607138050068',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='E205' and custNo='V20110009' and mn='07' and yr='2016';Update cust_route set price_buy='2,328.00',orderNo='1607138050068',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='E205' and custNo='V20110009' and mn='07' and yr='2016';
07-13-2016 11:24:20 AM1970-01-01 07:00:07

Update cust_route set price_buy='2,130.00',orderNo='1607132010058',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='9' and custRoute='' and custDay='' and custArea='B201' and custNo='V10160050' and mn='07' and yr='2016';Update cust_route set price_buy='2,130.00',orderNo='1607132010058',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='9' and custRoute='' and custDay='' and custArea='B201' and custNo='V10160050' and mn='07' and yr='2016';
07-13-2016 11:20:54 AM1970-01-01 07:00:07

Update cust_route set price_buy='696.00',orderNo='1607132100131',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224004' and custDay='4' and custArea='B208' and custNo='V10510039' and mn='07' and yr='2016';Update cust_route set price_buy='696.00',orderNo='1607132100131',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224004' and custDay='4' and custArea='B208' and custNo='V10510039' and mn='07' and yr='2016';
07-13-2016 11:19:21 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='0' and custRoute='VSN/E227020' and custDay='0' and custArea='N/E206' and custNo='V33160002' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='0' and custRoute='VSN/E227020' and custDay='0' and custArea='N/E206' and custNo='V33160002' and mn='07' and yr='2016';
07-13-2016 11:18:45 AM1970-01-01 07:00:07

Update cust_route set price_buy='2,698.00',orderNo='1607132100130',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510012' and mn='07' and yr='2016';Update cust_route set price_buy='2,698.00',orderNo='1607132100130',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510012' and mn='07' and yr='2016';
07-13-2016 11:18:21 AM1970-01-01 07:00:07

Update cust_route set price_buy='3,072.00',orderNo='1607134060155',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='5' and custRoute='VSN/E227005' and custDay='5' and custArea='N/E206' and custNo='V33160007' and mn='07' and yr='2016';Update cust_route set price_buy='3,072.00',orderNo='1607134060155',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='5' and custRoute='VSN/E227005' and custDay='5' and custArea='N/E206' and custNo='V33160007' and mn='07' and yr='2016';
07-13-2016 11:17:06 AM1970-01-01 07:00:07

Update cust_route set price_buy='396.00',orderNo='1607134060154',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='5' and custRoute='VSN/E227005' and custDay='5' and custArea='N/E206' and custNo='V33160001' and mn='07' and yr='2016';Update cust_route set price_buy='396.00',orderNo='1607134060154',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='5' and custRoute='VSN/E227005' and custDay='5' and custArea='N/E206' and custNo='V33160001' and mn='07' and yr='2016';
07-13-2016 11:12:35 AM1970-01-01 07:00:07

Update cust_route set price_buy='2,666.00',orderNo='1607132100129',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B208' and custNo='V10510021' and mn='07' and yr='2016';Update cust_route set price_buy='2,666.00',orderNo='1607132100129',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B208' and custNo='V10510021' and mn='07' and yr='2016';
07-13-2016 11:08:28 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300018' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300018' and mn='07' and yr='2016';
07-13-2016 11:07:42 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ เจ้าของร้านไม่อยู่ครับ' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200006' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ เจ้าของร้านไม่อยู่ครับ' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200006' and mn='07' and yr='2016';
07-13-2016 11:05:58 AM1970-01-01 07:00:07

Update cust_route set price_buy='736.00',orderNo='1607132020060',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200007' and mn='07' and yr='2016';Update cust_route set price_buy='736.00',orderNo='1607132020060',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200007' and mn='07' and yr='2016';
07-13-2016 11:03:57 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ เลิกกิจการ' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300026' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ เลิกกิจการ' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300026' and mn='07' and yr='2016';
07-13-2016 11:02:50 AM1970-01-01 07:00:07

Update cust_route set price_buy='512.00',orderNo='1607134040125',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E204' and custNo='VZ20400097' and mn='07' and yr='2016';Update cust_route set price_buy='512.00',orderNo='1607134040125',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E204' and custNo='VZ20400097' and mn='07' and yr='2016';
07-13-2016 11:01:56 AM1970-01-01 07:00:07

Update cust_route set price_buy='198.00',orderNo='1607134040124',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E204' and custNo='VZ20400099' and mn='07' and yr='2016';Update cust_route set price_buy='198.00',orderNo='1607134040124',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E204' and custNo='VZ20400099' and mn='07' and yr='2016';
07-13-2016 11:01:19 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,024.00',orderNo='1607134040123',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E224013' and custDay='3' and custArea='N/E204' and custNo='VZ20400098' and mn='07' and yr='2016';Update cust_route set price_buy='1,024.00',orderNo='1607134040123',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E224013' and custDay='3' and custArea='N/E204' and custNo='VZ20400098' and mn='07' and yr='2016';
07-13-2016 11:00:35 AM1970-01-01 07:00:07

Update cust_route set price_buy='736.00',orderNo='1607134040122',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E204' and custNo='VZ20400096' and mn='07' and yr='2016';Update cust_route set price_buy='736.00',orderNo='1607134040122',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E204' and custNo='VZ20400096' and mn='07' and yr='2016';
07-13-2016 10:59:15 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,024.00',orderNo='1607134040121',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E204' and custNo='V44170002' and mn='07' and yr='2016';Update cust_route set price_buy='1,024.00',orderNo='1607134040121',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E204' and custNo='V44170002' and mn='07' and yr='2016';
07-13-2016 10:58:57 AM1970-01-01 07:00:07

Update cust_route set price_buy='990.00',orderNo='1607132020059',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB213005' and custDay='5' and custArea='B202' and custNo='VB20200004' and mn='07' and yr='2016';Update cust_route set price_buy='990.00',orderNo='1607132020059',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB213005' and custDay='5' and custArea='B202' and custNo='VB20200004' and mn='07' and yr='2016';
07-13-2016 10:58:26 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,472.00',orderNo='1607134040120',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E204' and custNo='V44170001' and mn='07' and yr='2016';Update cust_route set price_buy='1,472.00',orderNo='1607134040120',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E204' and custNo='V44170001' and mn='07' and yr='2016';
07-13-2016 10:57:32 AM1970-01-01 07:00:07

Update cust_route set price_buy='198.00',orderNo='1607132020058',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB213005' and custDay='5' and custArea='B202' and custNo='VB20200005' and mn='07' and yr='2016';Update cust_route set price_buy='198.00',orderNo='1607132020058',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB213005' and custDay='5' and custArea='B202' and custNo='VB20200005' and mn='07' and yr='2016';
07-13-2016 10:56:55 AM1970-01-01 07:00:07

Update cust_route set price_buy='276.00',orderNo='1607134040119',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E224013' and custDay='3' and custArea='N/E204' and custNo='V44170003' and mn='07' and yr='2016';Update cust_route set price_buy='276.00',orderNo='1607134040119',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E224013' and custDay='3' and custArea='N/E204' and custNo='V44170003' and mn='07' and yr='2016';
07-13-2016 10:56:54 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N203' and custNo='V57210003' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N203' and custNo='V57210003' and mn='07' and yr='2016';
07-13-2016 10:56:44 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N203' and custNo='V57210002' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N203' and custNo='V57210002' and mn='07' and yr='2016';
07-13-2016 10:56:42 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200008' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200008' and mn='07' and yr='2016';
07-13-2016 10:56:05 AM1970-01-01 07:00:07

Update cust_route set price_buy='6,592.00',orderNo='1607134040118',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E224013' and custDay='3' and custArea='N/E204' and custNo='V44170005' and mn='07' and yr='2016';Update cust_route set price_buy='6,592.00',orderNo='1607134040118',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E224013' and custDay='3' and custArea='N/E204' and custNo='V44170005' and mn='07' and yr='2016';
07-13-2016 10:55:29 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='3' and custRoute='' and custDay='' and custArea='B204' and custNo='V11120008' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='3' and custRoute='' and custDay='' and custArea='B204' and custNo='V11120008' and mn='07' and yr='2016';
07-13-2016 10:55:15 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,536.00',orderNo='1607132020057',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300019' and mn='07' and yr='2016';Update cust_route set price_buy='1,536.00',orderNo='1607132020057',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300019' and mn='07' and yr='2016';
07-13-2016 10:55:14 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSB215003' and custDay='3' and custArea='B204' and custNo='VB20400009' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSB215003' and custDay='3' and custArea='B204' and custNo='VB20400009' and mn='07' and yr='2016';
07-13-2016 10:55:00 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ เจ้ไม่อยู่' WHERE myDay='3' and custRoute='VSB215004' and custDay='4' and custArea='B204' and custNo='VB20400022' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ เจ้ไม่อยู่' WHERE myDay='3' and custRoute='VSB215004' and custDay='4' and custArea='B204' and custNo='VB20400022' and mn='07' and yr='2016';
07-13-2016 10:54:57 AM1970-01-01 07:00:07

Update cust_route set price_buy='10,184.00',orderNo='1607134040117',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E224013' and custDay='3' and custArea='N/E204' and custNo='V44170004' and mn='07' and yr='2016';Update cust_route set price_buy='10,184.00',orderNo='1607134040117',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSN/E224013' and custDay='3' and custArea='N/E204' and custNo='V44170004' and mn='07' and yr='2016';
07-13-2016 10:54:42 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSB215002' and custDay='2' and custArea='B204' and custNo='V11000008' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSB215002' and custDay='2' and custArea='B204' and custNo='V11000008' and mn='07' and yr='2016';
07-13-2016 10:54:32 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSB215002' and custDay='2' and custArea='B204' and custNo='V11120011' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSB215002' and custDay='2' and custArea='B204' and custNo='V11120011' and mn='07' and yr='2016';
07-13-2016 10:54:21 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSB215001' and custDay='1' and custArea='B204' and custNo='V11000007' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSB215001' and custDay='1' and custArea='B204' and custNo='V11000007' and mn='07' and yr='2016';
07-13-2016 10:54:06 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300021' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300021' and mn='07' and yr='2016';
07-13-2016 10:54:03 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSB215002' and custDay='2' and custArea='B204' and custNo='V11000009' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSB215002' and custDay='2' and custArea='B204' and custNo='V11000009' and mn='07' and yr='2016';
07-13-2016 10:53:49 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB214004' and custDay='4' and custArea='B202' and custNo='V10160054' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB214004' and custDay='4' and custArea='B202' and custNo='V10160054' and mn='07' and yr='2016';
07-13-2016 10:53:11 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ เจ้าของร้านไม่อยู่ครับ' WHERE myDay='10' and custRoute='VSB213005' and custDay='5' and custArea='B202' and custNo='V10300005' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ เจ้าของร้านไม่อยู่ครับ' WHERE myDay='10' and custRoute='VSB213005' and custDay='5' and custArea='B202' and custNo='V10300005' and mn='07' and yr='2016';
07-13-2016 10:52:40 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300004' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300004' and mn='07' and yr='2016';
07-13-2016 10:50:30 AM1970-01-01 07:00:07

Update cust_route set price_buy='256.00',orderNo='1607134010079',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSN/E211016' and custDay='6' and custArea='N/E201' and custNo='VZ20100071' and mn='07' and yr='2016';Update cust_route set price_buy='256.00',orderNo='1607134010079',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSN/E211016' and custDay='6' and custArea='N/E201' and custNo='VZ20100071' and mn='07' and yr='2016';
07-13-2016 10:48:05 AM1970-01-01 07:00:07

Update cust_route set price_buy='198.00',orderNo='1607134010078',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSN/E211016' and custDay='6' and custArea='N/E201' and custNo='VZ20100072' and mn='07' and yr='2016';Update cust_route set price_buy='198.00',orderNo='1607134010078',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='6' and custRoute='VSN/E211016' and custDay='6' and custArea='N/E201' and custNo='VZ20100072' and mn='07' and yr='2016';
07-13-2016 10:47:54 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,182.00',orderNo='1607132100128',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510013' and mn='07' and yr='2016';Update cust_route set price_buy='1,182.00',orderNo='1607132100128',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510013' and mn='07' and yr='2016';
07-13-2016 10:45:52 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,024.00',orderNo='1607134010077',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100073' and mn='07' and yr='2016';Update cust_route set price_buy='1,024.00',orderNo='1607134010077',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100073' and mn='07' and yr='2016';
07-13-2016 10:45:44 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,568.00',orderNo='1607132100127',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224004' and custDay='4' and custArea='B208' and custNo='V10510040' and mn='07' and yr='2016';Update cust_route set price_buy='1,568.00',orderNo='1607132100127',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224004' and custDay='4' and custArea='B208' and custNo='V10510040' and mn='07' and yr='2016';
07-13-2016 10:42:39 AM1970-01-01 07:00:07

Update cust_route set price_buy='2,240.00',orderNo='1607133030070',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N203' and custNo='V57210001' and mn='07' and yr='2016';Update cust_route set price_buy='2,240.00',orderNo='1607133030070',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N203' and custNo='V57210001' and mn='07' and yr='2016';
07-13-2016 10:38:15 AM1970-01-01 07:00:07

Update cust_route set price_buy='2,400.00',orderNo='1607133030069',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N203' and custNo='V57290004' and mn='07' and yr='2016';Update cust_route set price_buy='2,400.00',orderNo='1607133030069',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N203' and custNo='V57290004' and mn='07' and yr='2016';
07-13-2016 10:37:26 AM1970-01-01 07:00:07

Update cust_route set price_buy='2,392.00',orderNo='1607135040078',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E215002' and custDay='2' and custArea='C204' and custNo='V13230017' and mn='07' and yr='2016';Update cust_route set price_buy='2,392.00',orderNo='1607135040078',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E215002' and custDay='2' and custArea='C204' and custNo='V13230017' and mn='07' and yr='2016';
07-13-2016 10:35:54 AM1970-01-01 07:00:07

Update cust_route set price_buy='6,646.00',orderNo='1607138050067',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='E205' and custNo='V20110005' and mn='07' and yr='2016';Update cust_route set price_buy='6,646.00',orderNo='1607138050067',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='E205' and custNo='V20110005' and mn='07' and yr='2016';
07-13-2016 10:32:54 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B205' and custNo='V12120031' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B205' and custNo='V12120031' and mn='07' and yr='2016';
07-13-2016 10:32:48 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B205' and custNo='V12120027' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B205' and custNo='V12120027' and mn='07' and yr='2016';
07-13-2016 10:32:33 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB226003' and custDay='3' and custArea='B205' and custNo='V12120003' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB226003' and custDay='3' and custArea='B205' and custNo='V12120003' and mn='07' and yr='2016';
07-13-2016 10:28:59 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,715.00',orderNo='1607132010057',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='9' and custRoute='' and custDay='' and custArea='B201' and custNo='V10160016' and mn='07' and yr='2016';Update cust_route set price_buy='1,715.00',orderNo='1607132010057',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='9' and custRoute='' and custDay='' and custArea='B201' and custNo='V10160016' and mn='07' and yr='2016';
07-13-2016 10:27:18 AM1970-01-01 07:00:07

Update cust_route set price_buy='831.00',orderNo='1607132100126',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510027' and mn='07' and yr='2016';Update cust_route set price_buy='831.00',orderNo='1607132100126',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510027' and mn='07' and yr='2016';
07-13-2016 10:23:24 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,936.00',orderNo='1607132100125',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510022' and mn='07' and yr='2016';Update cust_route set price_buy='1,936.00',orderNo='1607132100125',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510022' and mn='07' and yr='2016';
07-13-2016 10:20:10 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,116.00',orderNo='1607132100124',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510020' and mn='07' and yr='2016';Update cust_route set price_buy='1,116.00',orderNo='1607132100124',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510020' and mn='07' and yr='2016';
07-13-2016 10:17:04 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,252.00',orderNo='1607132100123',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510016' and mn='07' and yr='2016';Update cust_route set price_buy='1,252.00',orderNo='1607132100123',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB224003' and custDay='3' and custArea='B208' and custNo='V10510016' and mn='07' and yr='2016';
07-13-2016 10:16:09 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,992.00',orderNo='1607132010056',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='' and custDay='' and custArea='B201' and custNo='V10160017' and mn='07' and yr='2016';Update cust_route set price_buy='1,992.00',orderNo='1607132010056',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='' and custDay='' and custArea='B201' and custNo='V10160017' and mn='07' and yr='2016';
07-13-2016 10:07:56 AM1970-01-01 07:00:07

Update cust_route set price_buy='2,266.00',orderNo='1607135040077',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E215002' and custDay='2' and custArea='C204' and custNo='V13230015' and mn='07' and yr='2016';Update cust_route set price_buy='2,266.00',orderNo='1607135040077',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='2' and custRoute='VSC/E215002' and custDay='2' and custArea='C204' and custNo='V13230015' and mn='07' and yr='2016';
07-13-2016 10:07:07 AM1970-01-01 07:00:07

Update cust_route set price_buy='5,482.00',orderNo='1607133040096',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='1' and custRoute='VSN222001' and custDay='1' and custArea='N204' and custNo='V63000003' and mn='07' and yr='2016';Update cust_route set price_buy='5,482.00',orderNo='1607133040096',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='1' and custRoute='VSN222001' and custDay='1' and custArea='N204' and custNo='V63000003' and mn='07' and yr='2016';
07-13-2016 10:06:58 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,708.00',orderNo='1607132010055',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='' and custDay='' and custArea='B201' and custNo='VB20100005' and mn='07' and yr='2016';Update cust_route set price_buy='1,708.00',orderNo='1607132010055',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='' and custDay='' and custArea='B201' and custNo='VB20100005' and mn='07' and yr='2016';
07-13-2016 10:03:25 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='' and custDay='' and custArea='B204' and custNo='V11120022' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='' and custDay='' and custArea='B204' and custNo='V11120022' and mn='07' and yr='2016';
07-13-2016 10:03:13 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='' and custDay='' and custArea='B204' and custNo='V11120014' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='' and custDay='' and custArea='B204' and custNo='V11120014' and mn='07' and yr='2016';
07-13-2016 10:03:04 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ ร้านปิด' WHERE myDay='3' and custRoute='VSB215002' and custDay='2' and custArea='B204' and custNo='V11120013' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ ร้านปิด' WHERE myDay='3' and custRoute='VSB215002' and custDay='2' and custArea='B204' and custNo='V11120013' and mn='07' and yr='2016';
07-13-2016 10:02:38 AM1970-01-01 07:00:07

Update cust_route set price_buy='198.00',orderNo='1607132040058',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSB215002' and custDay='2' and custArea='B204' and custNo='V11120010' and mn='07' and yr='2016';Update cust_route set price_buy='198.00',orderNo='1607132040058',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='3' and custRoute='VSB215002' and custDay='2' and custArea='B204' and custNo='V11120010' and mn='07' and yr='2016';
07-13-2016 10:02:23 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSB215002' and custDay='2' and custArea='B204' and custNo='V11120009' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSB215002' and custDay='2' and custArea='B204' and custNo='V11120009' and mn='07' and yr='2016';
07-13-2016 10:02:05 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='3' and custRoute='' and custDay='' and custArea='B204' and custNo='V11120030' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='3' and custRoute='' and custDay='' and custArea='B204' and custNo='V11120030' and mn='07' and yr='2016';
07-13-2016 09:58:34 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,596.00',orderNo='1607132010054',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B201' and custNo='VB20100004' and mn='07' and yr='2016';Update cust_route set price_buy='1,596.00',orderNo='1607132010054',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B201' and custNo='VB20100004' and mn='07' and yr='2016';
07-13-2016 09:55:18 AM1970-01-01 07:00:07

Update cust_route set price_buy='1,192.00',orderNo='1607132010053',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB211001' and custDay='1' and custArea='B201' and custNo='VB20100003' and mn='07' and yr='2016';Update cust_route set price_buy='1,192.00',orderNo='1607132010053',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='10' and custRoute='VSB211001' and custDay='1' and custArea='B201' and custNo='VB20100003' and mn='07' and yr='2016';
07-13-2016 09:49:21 AM1970-01-01 07:00:07

Update cust_route set price_buy='4,441.00',orderNo='1607138050066',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='E205' and custNo='V20110004' and mn='07' and yr='2016';Update cust_route set price_buy='4,441.00',orderNo='1607138050066',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='E205' and custNo='V20110004' and mn='07' and yr='2016';
07-13-2016 09:37:54 AM1970-01-01 07:00:07

Update cust_route set price_buy='6,608.00',orderNo='1607132070069',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270005' and mn='07' and yr='2016';Update cust_route set price_buy='6,608.00',orderNo='1607132070069',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270005' and mn='07' and yr='2016';
07-13-2016 09:18:31 AM1970-01-01 07:00:07

Update cust_route set price_buy='198.00',orderNo='1607134070098',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700040' and mn='07' and yr='2016';Update cust_route set price_buy='198.00',orderNo='1607134070098',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E207' and custNo='VZ20700040' and mn='07' and yr='2016';
07-13-2016 08:55:24 AM1970-01-01 07:00:07

Update cust_route set price_buy='2,560.00',orderNo='1607132050076',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='' and custDay='' and custArea='B205' and custNo='V12120002' and mn='07' and yr='2016';Update cust_route set price_buy='2,560.00',orderNo='1607132050076',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='' and custDay='' and custArea='B205' and custNo='V12120002' and mn='07' and yr='2016';
07-13-2016 08:50:56 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270004' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270004' and mn='07' and yr='2016';
07-13-2016 08:50:48 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270003' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270003' and mn='07' and yr='2016';
07-13-2016 08:50:29 AM1970-01-01 07:00:07

Update cust_route set price_buy='2,400.00',orderNo='1607132050075',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB226003' and custDay='3' and custArea='B205' and custNo='V12120018' and mn='07' and yr='2016';Update cust_route set price_buy='2,400.00',orderNo='1607132050075',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='0' and custRoute='VSB226003' and custDay='3' and custArea='B205' and custNo='V12120018' and mn='07' and yr='2016';
07-13-2016 08:50:23 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227001' and custDay='1' and custArea='B207' and custNo='V10270002' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227001' and custDay='1' and custArea='B207' and custNo='V10270002' and mn='07' and yr='2016';
07-13-2016 08:49:28 AM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB226003' and custDay='3' and custArea='B205' and custNo='V12120001' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB226003' and custDay='3' and custArea='B205' and custNo='V12120001' and mn='07' and yr='2016';
07-13-2016 08:18:22 AM1970-01-01 07:00:07

Update cust_route set price_buy='7,968.00',orderNo='1607135040076',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='4' and custRoute='VSC/E215004' and custDay='4' and custArea='C204' and custNo='V13000004' and mn='07' and yr='2016';Update cust_route set price_buy='7,968.00',orderNo='1607135040076',visit_date='1970-01-01 07:00:07',is_buy='Y',reason='' WHERE myDay='4' and custRoute='VSC/E215004' and custDay='4' and custArea='C204' and custNo='V13000004' and mn='07' and yr='2016';
07-13-2016 07:30:40 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160002' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160002' and mn='07' and yr='2016';
07-13-2016 07:30:34 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='2' and custRoute='VSN216002' and custDay='2' and custArea='N205' and custNo='V54160001' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='2' and custRoute='VSN216002' and custDay='2' and custArea='N205' and custNo='V54160001' and mn='07' and yr='2016';
07-13-2016 07:30:27 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSN216003' and custDay='3' and custArea='N205' and custNo='V54150005' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='3' and custRoute='VSN216003' and custDay='3' and custArea='N205' and custNo='V54150005' and mn='07' and yr='2016';
07-13-2016 07:30:21 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54150004' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54150004' and mn='07' and yr='2016';
07-13-2016 07:30:15 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54150003' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54150003' and mn='07' and yr='2016';
07-13-2016 07:30:08 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='3' and custRoute='VSN216003' and custDay='3' and custArea='N205' and custNo='V54150002' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='3' and custRoute='VSN216003' and custDay='3' and custArea='N205' and custNo='V54150002' and mn='07' and yr='2016';
07-13-2016 05:16:37 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='11' and custRoute='' and custDay='' and custArea='B206' and custNo='V10220026' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='11' and custRoute='' and custDay='' and custArea='B206' and custNo='V10220026' and mn='07' and yr='2016';
07-13-2016 05:16:29 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='11' and custRoute='' and custDay='' and custArea='B206' and custNo='V10220025' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='11' and custRoute='' and custDay='' and custArea='B206' and custNo='V10220025' and mn='07' and yr='2016';
07-13-2016 05:13:33 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='11' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220015' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='11' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220015' and mn='07' and yr='2016';
07-13-2016 05:13:25 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='11' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220014' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='11' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220014' and mn='07' and yr='2016';
07-13-2016 05:13:14 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='11' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220013' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='11' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220013' and mn='07' and yr='2016';
07-13-2016 05:11:24 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='3' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220013' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='3' and custRoute='VSB221003' and custDay='3' and custArea='B206' and custNo='V10220013' and mn='07' and yr='2016';
07-13-2016 04:58:46 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='10' and custRoute='VSB214001' and custDay='1' and custArea='B202' and custNo='V10330002' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='10' and custRoute='VSB214001' and custDay='1' and custArea='B202' and custNo='V10330002' and mn='07' and yr='2016';
07-13-2016 04:58:36 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB214004' and custDay='4' and custArea='B202' and custNo='V10330001' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB214004' and custDay='4' and custArea='B202' and custNo='V10330001' and mn='07' and yr='2016';
07-13-2016 04:58:26 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200019' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200019' and mn='07' and yr='2016';
07-13-2016 04:58:19 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200018' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200018' and mn='07' and yr='2016';
07-13-2016 04:58:11 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200017' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200017' and mn='07' and yr='2016';
07-13-2016 04:58:03 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200016' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='VB20200016' and mn='07' and yr='2016';
07-13-2016 04:57:54 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10600038' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10600038' and mn='07' and yr='2016';
07-13-2016 04:57:20 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300017' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300017' and mn='07' and yr='2016';
07-13-2016 04:57:13 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300013' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300013' and mn='07' and yr='2016';
07-13-2016 04:57:05 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300012' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10300012' and mn='07' and yr='2016';
07-13-2016 04:56:50 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10100002' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10100002' and mn='07' and yr='2016';
07-13-2016 04:56:41 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10100001' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10100001' and mn='07' and yr='2016';
07-13-2016 04:56:27 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB214007' and custDay='7' and custArea='B202' and custNo='V10500001' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='VSB214007' and custDay='7' and custArea='B202' and custNo='V10500001' and mn='07' and yr='2016';
07-13-2016 04:56:09 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10400003' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='10' and custRoute='' and custDay='' and custArea='B202' and custNo='V10400003' and mn='07' and yr='2016';
07-13-2016 02:32:04 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54170001' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54170001' and mn='07' and yr='2016';
07-13-2016 02:31:58 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160011' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160011' and mn='07' and yr='2016';
07-13-2016 02:31:50 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160010' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160010' and mn='07' and yr='2016';
07-13-2016 02:31:44 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160009' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160009' and mn='07' and yr='2016';
07-13-2016 02:31:33 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160008' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160008' and mn='07' and yr='2016';
07-13-2016 02:31:21 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160007' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160007' and mn='07' and yr='2016';
07-13-2016 02:31:10 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='2' and custRoute='VSN216002' and custDay='2' and custArea='N205' and custNo='V54160005' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='2' and custRoute='VSN216002' and custDay='2' and custArea='N205' and custNo='V54160005' and mn='07' and yr='2016';
07-13-2016 02:30:55 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160004' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160004' and mn='07' and yr='2016';
07-13-2016 02:30:44 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160003' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N205' and custNo='V54160003' and mn='07' and yr='2016';
07-13-2016 02:02:10 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='9' and custRoute='VSN/E227019' and custDay='9' and custArea='N/E206' and custNo='V33190002' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='9' and custRoute='VSN/E227019' and custDay='9' and custArea='N/E206' and custNo='V33190002' and mn='07' and yr='2016';
07-13-2016 01:54:53 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270001' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270001' and mn='07' and yr='2016';
07-13-2016 01:54:39 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227003' and custDay='3' and custArea='B207' and custNo='VB20700030' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227003' and custDay='3' and custArea='B207' and custNo='VB20700030' and mn='07' and yr='2016';
07-13-2016 01:54:34 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227002' and custDay='2' and custArea='B207' and custNo='VB20700029' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227002' and custDay='2' and custArea='B207' and custNo='VB20700029' and mn='07' and yr='2016';
07-13-2016 01:54:29 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227002' and custDay='2' and custArea='B207' and custNo='VB20700028' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227002' and custDay='2' and custArea='B207' and custNo='VB20700028' and mn='07' and yr='2016';
07-13-2016 01:54:24 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='' and custDay='' and custArea='B207' and custNo='V10270025' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='' and custDay='' and custArea='B207' and custNo='V10270025' and mn='07' and yr='2016';
07-13-2016 01:54:15 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270010' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270010' and mn='07' and yr='2016';
07-13-2016 01:54:10 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270009' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270009' and mn='07' and yr='2016';
07-13-2016 01:54:04 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='' and custDay='' and custArea='B207' and custNo='V10270008' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='' and custDay='' and custArea='B207' and custNo='V10270008' and mn='07' and yr='2016';
07-13-2016 01:53:59 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270007' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='VSB227004' and custDay='4' and custArea='B207' and custNo='V10270007' and mn='07' and yr='2016';
07-13-2016 01:53:52 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='' and custDay='' and custArea='B207' and custNo='V10270006' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='17' and custRoute='' and custDay='' and custArea='B207' and custNo='V10270006' and mn='07' and yr='2016';
07-13-2016 01:41:07 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='VZ20100068' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='VZ20100068' and mn='07' and yr='2016';
07-13-2016 01:40:56 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้ามาส่งช้า' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='VZ20100064' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้ามาส่งช้า' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='VZ20100064' and mn='07' and yr='2016';
07-13-2016 01:40:44 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100066' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100066' and mn='07' and yr='2016';
07-13-2016 01:40:32 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100065' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100065' and mn='07' and yr='2016';
07-13-2016 01:39:22 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='V41220005' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='V41220005' and mn='07' and yr='2016';
07-13-2016 01:39:10 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100069' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='VZ20100069' and mn='07' and yr='2016';
07-13-2016 01:37:58 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='V41220004' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='V41220004' and mn='07' and yr='2016';
07-13-2016 01:37:34 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='VZ20100067' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='ซื้อกับยี่ปั๊ว' WHERE myDay='7' and custRoute='VSN/E211017' and custDay='7' and custArea='N/E201' and custNo='VZ20100067' and mn='07' and yr='2016';
07-13-2016 01:36:18 PM1970-01-01 07:00:07

Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='V41220008' and mn='07' and yr='2016';Update cust_route set price_buy='0.00',orderNo='',visit_date='1970-01-01 07:00:07',is_buy='N',reason='สินค้าระบายไม่ดี' WHERE myDay='' and custRoute='' and custDay='' and custArea='N/E201' and custNo='V41220008' and mn='07' and yr='2016';

Update Visit Complete . . . All Rows is -> 264