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-10-12 17:31:57
create-version=1
source=select  `sh`.`id`  AS  `id` ,\n `sh`.`mem_id`  AS  `mem_id` ,\n `sh`.`code`  AS  `code` ,\n `de`.`Acc_no`  AS  `acc_no` ,\n `de`.`Name`  AS  `name` ,\n `de`.`Father_Name`  AS  `father_name` ,\n `h`.`head`  AS  `head` ,\n `s`.`sub_head`  AS  `sub_head` ,\n `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`  ) )
client_cs_name=utf8
connection_cl_name=utf8mb4_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`))
