TYPE=VIEW
query=select 0 AS `is_delete`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_id` AS `ba_list_id`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_xid` AS `ba_list_xid`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_date` AS `ba_list_date`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_number` AS `ba_list_number`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_type` AS `ba_list_type`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_type_id` AS `ba_list_type_id`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_user_id` AS `ba_list_user_id`,\'\' AS `audit_guid` from `db_account_9793090153`.`tbl_batch_list` union all select 1 AS `is_delete`,`d`.`ba_list_id` AS `ba_list_id`,`d`.`ba_list_xid` AS `ba_list_xid`,`d`.`ba_list_date` AS `ba_list_date`,`d`.`ba_list_number` AS `ba_list_number`,`d`.`ba_list_type` AS `ba_list_type`,`d`.`ba_list_type_id` AS `ba_list_type_id`,`d`.`ba_list_user_id` AS `ba_list_user_id`,`d`.`audit_guid` AS `audit_guid` from `db_account_9793090153`.`temp_tbl_batch_list` `d` where ((`d`.`audit_type` = 1) and (`d`.`audit_id` = (select max(`s`.`audit_id`) AS `MAX(audit_id)` from `db_account_9793090153`.`temp_tbl_batch_list` `s` where (`s`.`ba_list_id` = `d`.`ba_list_id`)))) group by `d`.`ba_list_id` order by `ba_list_date`,`ba_list_type`,`ba_list_type_id`
md5=e448bf87dd1909b6aafa14de74341f34
updatable=0
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2014-01-01 21:20:12
create-version=1
source=select 0 AS `is_delete`,`tbl_batch_list`.`ba_list_id` AS `ba_list_id`,`tbl_batch_list`.`ba_list_xid` AS `ba_list_xid`,`tbl_batch_list`.`ba_list_date` AS `ba_list_date`,`tbl_batch_list`.`ba_list_number` AS `ba_list_number`,`tbl_batch_list`.`ba_list_type` AS `ba_list_type`,`tbl_batch_list`.`ba_list_type_id` AS `ba_list_type_id`,`tbl_batch_list`.`ba_list_user_id` AS `ba_list_user_id`,\'\' AS `audit_guid` from `tbl_batch_list` union all select 1 AS `is_delete`,`d`.`ba_list_id` AS `ba_list_id`,`d`.`ba_list_xid` AS `ba_list_xid`,`d`.`ba_list_date` AS `ba_list_date`,`d`.`ba_list_number` AS `ba_list_number`,`d`.`ba_list_type` AS `ba_list_type`,`d`.`ba_list_type_id` AS `ba_list_type_id`,`d`.`ba_list_user_id` AS `ba_list_user_id`,`d`.`audit_guid` AS `audit_guid` from `temp_tbl_batch_list` `d` where ((`d`.`audit_type` = 1) and (`d`.`audit_id` = (select max(`s`.`audit_id`) AS `MAX(audit_id)` from 
\n`temp_tbl_batch_list` `s` 
\nwhere (`s`.`ba_list_id` = `d`.`ba_list_id`)))) group by `d`.`ba_list_id` order by `ba_list_date`,`ba_list_type`,`ba_list_type_id`
client_cs_name=cp1256
connection_cl_name=cp1256_general_ci
view_body_utf8=select 0 AS `is_delete`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_id` AS `ba_list_id`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_xid` AS `ba_list_xid`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_date` AS `ba_list_date`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_number` AS `ba_list_number`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_type` AS `ba_list_type`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_type_id` AS `ba_list_type_id`,`db_account_9793090153`.`tbl_batch_list`.`ba_list_user_id` AS `ba_list_user_id`,\'\' AS `audit_guid` from `db_account_9793090153`.`tbl_batch_list` union all select 1 AS `is_delete`,`d`.`ba_list_id` AS `ba_list_id`,`d`.`ba_list_xid` AS `ba_list_xid`,`d`.`ba_list_date` AS `ba_list_date`,`d`.`ba_list_number` AS `ba_list_number`,`d`.`ba_list_type` AS `ba_list_type`,`d`.`ba_list_type_id` AS `ba_list_type_id`,`d`.`ba_list_user_id` AS `ba_list_user_id`,`d`.`audit_guid` AS `audit_guid` from `db_account_9793090153`.`temp_tbl_batch_list` `d` where ((`d`.`audit_type` = 1) and (`d`.`audit_id` = (select max(`s`.`audit_id`) AS `MAX(audit_id)` from `db_account_9793090153`.`temp_tbl_batch_list` `s` where (`s`.`ba_list_id` = `d`.`ba_list_id`)))) group by `d`.`ba_list_id` order by `ba_list_date`,`ba_list_type`,`ba_list_type_id`
