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-246`.`share_object` `sh` join `co-operativebank-246`.`account` `de`) join `co-operativebank-246`.`head` `h`) join `co-operativebank-246`.`sub_head` `s`) where ((`de`.`Member_id` = `sh`.`mem_id`) and (`sh`.`head` = `h`.`code`) and (`sh`.`sub_head` = `s`.`code`))
md5=fd5160bc3701f8f804b3989d32c4df45
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-12-29 05:45: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-246`.`share_object`  `sh`  join  `co-operativebank-246`.`account`  `de`  ) join  `co-operativebank-246`.`head`  `h`  ) join  `co-operativebank-246`.`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-246`.`share_object` `sh` join `co-operativebank-246`.`account` `de`) join `co-operativebank-246`.`head` `h`) join `co-operativebank-246`.`sub_head` `s`) where ((`de`.`Member_id` = `sh`.`mem_id`) and (`sh`.`head` = `h`.`code`) and (`sh`.`sub_head` = `s`.`code`))
