TYPE=VIEW
query=select `db_account_9793090153`.`tbl_account`.`ac_id` AS `ac_id`,`db_account_9793090153`.`tbl_account`.`ac_id_parent` AS `ac_id_parent`,`db_account_9793090153`.`tbl_account`.`ac_id_final` AS `ac_id_final`,`db_account_9793090153`.`tbl_account`.`ac_level` AS `ac_level`,`db_account_9793090153`.`tbl_account`.`ac_parents` AS `ac_parents`,`db_account_9793090153`.`tbl_account`.`ac_code` AS `ac_code`,`db_account_9793090153`.`tbl_account`.`ac_name` AS `ac_name`,`db_account_9793090153`.`tbl_account`.`ac_type` AS `ac_type` from `db_account_9793090153`.`tbl_account` where ((`db_account_9793090153`.`tbl_account`.`ac_type` = 2) and (`db_account_9793090153`.`tbl_account`.`ac_id_final` <> -(1))) union all select 0 AS `ac_id`,0 AS `ac_id_parent`,-(1) AS `ac_id_final`,1 AS `ac_level`,0 AS `ac_parents`,_cp1256\'\' AS `ac_code`,(select `db_account_9793090153`.`tbl_option`.`op_value` AS `op_value` from `db_account_9793090153`.`tbl_option` where ((`db_account_9793090153`.`tbl_option`.`op_const` = 200017) and (`db_account_9793090153`.`tbl_option`.`op_type` = 1))) AS `ac_name`,-(1) AS `ac_type`
md5=2818254514fd715422dce6c9864c7c3f
updatable=0
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2014-01-01 21:20:11
create-version=1
source=select `tbl_account`.`ac_id` AS `ac_id`,`tbl_account`.`ac_id_parent` AS `ac_id_parent`,`tbl_account`.`ac_id_final` AS `ac_id_final`,`tbl_account`.`ac_level` AS `ac_level`,`tbl_account`.`ac_parents` AS `ac_parents`,`tbl_account`.`ac_code` AS `ac_code`,`tbl_account`.`ac_name` AS `ac_name`,`tbl_account`.`ac_type` AS `ac_type` from `tbl_account` where ((`tbl_account`.`ac_type` = 2) and (`tbl_account`.`ac_id_final` <> -(1))) union all select 0 AS `ac_id`,0 AS `ac_id_parent`,-(1) AS `ac_id_final`,1 AS `ac_level`,0 AS `ac_parents`,_cp1256\'\' AS `ac_code`,(select `tbl_option`.`op_value` AS `op_value` from `tbl_option` where ((`tbl_option`.`op_const` = 200017) and (`tbl_option`.`op_type` = 1))) AS `ac_name`,-(1) AS `ac_type`
client_cs_name=cp1256
connection_cl_name=cp1256_general_ci
view_body_utf8=select `db_account_9793090153`.`tbl_account`.`ac_id` AS `ac_id`,`db_account_9793090153`.`tbl_account`.`ac_id_parent` AS `ac_id_parent`,`db_account_9793090153`.`tbl_account`.`ac_id_final` AS `ac_id_final`,`db_account_9793090153`.`tbl_account`.`ac_level` AS `ac_level`,`db_account_9793090153`.`tbl_account`.`ac_parents` AS `ac_parents`,`db_account_9793090153`.`tbl_account`.`ac_code` AS `ac_code`,`db_account_9793090153`.`tbl_account`.`ac_name` AS `ac_name`,`db_account_9793090153`.`tbl_account`.`ac_type` AS `ac_type` from `db_account_9793090153`.`tbl_account` where ((`db_account_9793090153`.`tbl_account`.`ac_type` = 2) and (`db_account_9793090153`.`tbl_account`.`ac_id_final` <> -(1))) union all select 0 AS `ac_id`,0 AS `ac_id_parent`,-(1) AS `ac_id_final`,1 AS `ac_level`,0 AS `ac_parents`,\'\' AS `ac_code`,(select `db_account_9793090153`.`tbl_option`.`op_value` AS `op_value` from `db_account_9793090153`.`tbl_option` where ((`db_account_9793090153`.`tbl_option`.`op_const` = 200017) and (`db_account_9793090153`.`tbl_option`.`op_type` = 1))) AS `ac_name`,-(1) AS `ac_type`
