TYPE=VIEW
query=select `db_account_9793090153`.`tbl_gl`.`gl_id` AS `gl_id`,`db_account_9793090153`.`tbl_gl`.`gl_batch_id` AS `gl_batch_id`,`db_account_9793090153`.`tbl_gl`.`gl_ac_id` AS `gl_ac_id`,`db_account_9793090153`.`tbl_gl`.`gl_debit` AS `gl_debit`,`db_account_9793090153`.`tbl_gl`.`gl_credit` AS `gl_credit`,`db_account_9793090153`.`tbl_gl`.`gl_desc` AS `gl_desc`,`db_account_9793090153`.`tbl_gl`.`gl_doc` AS `gl_doc`,`db_account_9793090153`.`tbl_gl`.`gl_currency_id` AS `gl_currency_id`,`db_account_9793090153`.`tbl_gl`.`gl_currency_val` AS `gl_currency_val`,`db_account_9793090153`.`tbl_gl`.`gl_costcenter_id` AS `gl_costcenter_id`,`db_account_9793090153`.`tbl_gl`.`gl_const` AS `gl_const`,`db_account_9793090153`.`tbl_gl`.`gl_date` AS `gl_date` from `db_account_9793090153`.`tbl_gl` where `db_account_9793090153`.`tbl_gl`.`gl_ac_id` in (select `db_account_9793090153`.`tbl_capital`.`ca_ac_id` AS `ca_ac_id` from `db_account_9793090153`.`tbl_capital` where (`db_account_9793090153`.`tbl_capital`.`ca_share` = 1)) order by `db_account_9793090153`.`tbl_gl`.`gl_ac_id`,`db_account_9793090153`.`tbl_gl`.`gl_date`,`db_account_9793090153`.`tbl_gl`.`gl_id`
md5=3d20daab27e4bebd02586e309a49942a
updatable=1
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_gl`.`gl_id` AS `gl_id`,`tbl_gl`.`gl_batch_id` AS `gl_batch_id`,`tbl_gl`.`gl_ac_id` AS `gl_ac_id`,`tbl_gl`.`gl_debit` AS `gl_debit`,`tbl_gl`.`gl_credit` AS `gl_credit`,`tbl_gl`.`gl_desc` AS `gl_desc`,`tbl_gl`.`gl_doc` AS `gl_doc`,`tbl_gl`.`gl_currency_id` AS `gl_currency_id`,`tbl_gl`.`gl_currency_val` AS `gl_currency_val`,`tbl_gl`.`gl_costcenter_id` AS `gl_costcenter_id`,`tbl_gl`.`gl_const` AS `gl_const`,`tbl_gl`.`gl_date` AS `gl_date` from `tbl_gl` where `tbl_gl`.`gl_ac_id` in (select `tbl_capital`.`ca_ac_id` AS `ca_ac_id` from `tbl_capital` where (`tbl_capital`.`ca_share` = 1)) order by `tbl_gl`.`gl_ac_id`,`tbl_gl`.`gl_date`,`tbl_gl`.`gl_id`
client_cs_name=cp1256
connection_cl_name=cp1256_general_ci
view_body_utf8=select `db_account_9793090153`.`tbl_gl`.`gl_id` AS `gl_id`,`db_account_9793090153`.`tbl_gl`.`gl_batch_id` AS `gl_batch_id`,`db_account_9793090153`.`tbl_gl`.`gl_ac_id` AS `gl_ac_id`,`db_account_9793090153`.`tbl_gl`.`gl_debit` AS `gl_debit`,`db_account_9793090153`.`tbl_gl`.`gl_credit` AS `gl_credit`,`db_account_9793090153`.`tbl_gl`.`gl_desc` AS `gl_desc`,`db_account_9793090153`.`tbl_gl`.`gl_doc` AS `gl_doc`,`db_account_9793090153`.`tbl_gl`.`gl_currency_id` AS `gl_currency_id`,`db_account_9793090153`.`tbl_gl`.`gl_currency_val` AS `gl_currency_val`,`db_account_9793090153`.`tbl_gl`.`gl_costcenter_id` AS `gl_costcenter_id`,`db_account_9793090153`.`tbl_gl`.`gl_const` AS `gl_const`,`db_account_9793090153`.`tbl_gl`.`gl_date` AS `gl_date` from `db_account_9793090153`.`tbl_gl` where `db_account_9793090153`.`tbl_gl`.`gl_ac_id` in (select `db_account_9793090153`.`tbl_capital`.`ca_ac_id` AS `ca_ac_id` from `db_account_9793090153`.`tbl_capital` where (`db_account_9793090153`.`tbl_capital`.`ca_share` = 1)) order by `db_account_9793090153`.`tbl_gl`.`gl_ac_id`,`db_account_9793090153`.`tbl_gl`.`gl_date`,`db_account_9793090153`.`tbl_gl`.`gl_id`
