TYPE=VIEW
query=select `sh`.`id` AS `id`,`sh`.`mem_id` AS `mem_id`,`sh`.`code` AS `code`,`de`.`Acc_no` AS `acc_no`,`de`.`Name` AS `name`,`de`.`Father_Name` AS `father_name`,`h`.`head` AS `head`,`s`.`sub_head` AS `sub_head`,`sh`.`mesurement` AS `mesurement` from (((`co-operativebank`.`share_object` `sh` join `co-operativebank`.`account` `de`) join `co-operativebank`.`head` `h`) join `co-operativebank`.`sub_head` `s`) where ((`de`.`Member_id` = `sh`.`mem_id`) and (`sh`.`head` = `h`.`code`) and (`sh`.`sub_head` = `s`.`code`))
md5=49cb63ba875ad89b22104e3b01edb52e
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2015-12-01 04:25:57
create-version=1
source=select `sh`.`id` AS `id`,`sh`.`mem_id` AS `mem_id`,`sh`.`code` AS `code`,`de`.`Acc_no` AS `acc_no`,`de`.`Name` AS `name`,`de`.`Father_Name` AS `father_name`,`h`.`head` AS `head`,`s`.`sub_head` AS `sub_head`,`sh`.`mesurement` AS `mesurement` from (((`share_object` `sh` join `account` `de`) join `head` `h`) join `sub_head` `s`) where ((`de`.`Member_id` = `sh`.`mem_id`) and (`sh`.`head` = `h`.`code`) and (`sh`.`sub_head` = `s`.`code`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `sh`.`id` AS `id`,`sh`.`mem_id` AS `mem_id`,`sh`.`code` AS `code`,`de`.`Acc_no` AS `acc_no`,`de`.`Name` AS `name`,`de`.`Father_Name` AS `father_name`,`h`.`head` AS `head`,`s`.`sub_head` AS `sub_head`,`sh`.`mesurement` AS `mesurement` from (((`co-operativebank`.`share_object` `sh` join `co-operativebank`.`account` `de`) join `co-operativebank`.`head` `h`) join `co-operativebank`.`sub_head` `s`) where ((`de`.`Member_id` = `sh`.`mem_id`) and (`sh`.`head` = `h`.`code`) and (`sh`.`sub_head` = `s`.`code`))
