TYPE=VIEW
query=select `co-operativebank-mohati`.`sv`.`code` AS `code`,`co-operativebank-mohati`.`sv`.`amt` AS `amt`,`co-operativebank-mohati`.`sv`.`interest` AS `interest`,\'\' AS `nq`,\'\' AS `Duration`,\'\' AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`sv`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`sv` union all select `co-operativebank-mohati`.`fd`.`Code` AS `code`,`co-operativebank-mohati`.`fd`.`P_Amt` AS `p_amt`,`co-operativebank-mohati`.`fd`.`Interest` AS `interest`,\'\' AS `nq`,`co-operativebank-mohati`.`fd`.`Duration` AS `Duration`,`co-operativebank-mohati`.`fd`.`Durattion_D` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`fd`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`fd` union all select `co-operativebank-mohati`.`rd`.`code` AS `code`,`co-operativebank-mohati`.`rd`.`amt` AS `amt`,`co-operativebank-mohati`.`rd`.`interest` AS `interest`,`co-operativebank-mohati`.`rd`.`nq` AS `nq`,\'\' AS `Duration`,\'\' AS `Durattion_D`,`co-operativebank-mohati`.`rd`.`Inst` AS `Inst`,`co-operativebank-mohati`.`rd`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`rd` union all select `co-operativebank-mohati`.`reinv`.`Code` AS `code`,`co-operativebank-mohati`.`reinv`.`amt` AS `amt`,`co-operativebank-mohati`.`reinv`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank-mohati`.`reinv`.`dur` AS `Duration`,`co-operativebank-mohati`.`reinv`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`reinv`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`reinv` union all select `co-operativebank-mohati`.`home_sv`.`Code` AS `code`,`co-operativebank-mohati`.`home_sv`.`amt` AS `amt`,`co-operativebank-mohati`.`home_sv`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank-mohati`.`home_sv`.`dur` AS `Duration`,`co-operativebank-mohati`.`home_sv`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`home_sv`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`home_sv` union all select `co-operativebank-mohati`.`pension`.`Code` AS `code`,`co-operativebank-mohati`.`pension`.`amt` AS `amt`,`co-operativebank-mohati`.`pension`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank-mohati`.`pension`.`dur` AS `Duration`,`co-operativebank-mohati`.`pension`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`pension`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`pension` union all select `co-operativebank-mohati`.`mis`.`Code` AS `code`,`co-operativebank-mohati`.`mis`.`amt` AS `amt`,`co-operativebank-mohati`.`mis`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank-mohati`.`mis`.`dur` AS `Duration`,`co-operativebank-mohati`.`mis`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`mis`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`mis` union all select `co-operativebank-mohati`.`other`.`Code` AS `code`,`co-operativebank-mohati`.`other`.`P_Amt` AS `p_amt`,`co-operativebank-mohati`.`other`.`Interest` AS `interest`,\'\' AS `nq`,`co-operativebank-mohati`.`other`.`Duration` AS `Duration`,`co-operativebank-mohati`.`other`.`Durattion_D` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`other`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`other`
md5=13ae680d6ad86b42b41c9d180e48a8a6
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2020-10-16 13:11:34
create-version=1
source=select  `co-operativebank-mohati`.`sv`.`code`  AS  `code` ,\n `co-operativebank-mohati`.`sv`.`amt`  AS  `amt` ,\n `co-operativebank-mohati`.`sv`.`interest`  AS  `interest` ,\n \'\' AS  `nq` ,\n \'\' AS  `Duration` ,\n \'\' AS  `Durattion_D` ,\n \'\' AS  `Inst` ,\n `co-operativebank-mohati`.`sv`.`scheme`  AS  `Scheme`  from  `co-operativebank-mohati`.`sv`  union  all  select  `co-operativebank-mohati`.`fd`.`Code`  AS  `code` ,\n `co-operativebank-mohati`.`fd`.`P_Amt`  AS  `p_amt` ,\n `co-operativebank-mohati`.`fd`.`Interest`  AS  `interest` ,\n \'\' AS  `nq` ,\n `co-operativebank-mohati`.`fd`.`Duration`  AS  `Duration` ,\n `co-operativebank-mohati`.`fd`.`Durattion_D`  AS  `Durattion_D` ,\n \'\' AS  `Inst` ,\n `co-operativebank-mohati`.`fd`.`scheme`  AS  `Scheme`  from  `co-operativebank-mohati`.`fd`  union  all  select  `co-operativebank-mohati`.`rd`.`code`  AS  `code` ,\n `co-operativebank-mohati`.`rd`.`amt`  AS  `amt` ,\n `co-operativebank-mohati`.`rd`.`interest`  AS  `interest` ,\n `co-operativebank-mohati`.`rd`.`nq`  AS  `nq` ,\n \'\' AS  `Duration` ,\n \'\' AS  `Durattion_D` ,\n `co-operativebank-mohati`.`rd`.`Inst`  AS  `Inst` ,\n `co-operativebank-mohati`.`rd`.`scheme`  AS  `Scheme`  from  `co-operativebank-mohati`.`rd`  union  all  select  `co-operativebank-mohati`.`reinv`.`Code`  AS  `code` ,\n `co-operativebank-mohati`.`reinv`.`amt`  AS  `amt` ,\n `co-operativebank-mohati`.`reinv`.`interst`  AS  `interst` ,\n \'\' AS  `nq` ,\n `co-operativebank-mohati`.`reinv`.`dur`  AS  `Duration` ,\n `co-operativebank-mohati`.`reinv`.`dur_type`  AS  `Durattion_D` ,\n \'\' AS  `Inst` ,\n `co-operativebank-mohati`.`reinv`.`scheme`  AS  `Scheme`  from  `co-operativebank-mohati`.`reinv`  union  all  select  `co-operativebank-mohati`.`home_sv`.`Code`  AS  `code` ,\n `co-operativebank-mohati`.`home_sv`.`amt`  AS  `amt` ,\n `co-operativebank-mohati`.`home_sv`.`interst`  AS  `interst` ,\n \'\' AS  `nq` ,\n `co-operativebank-mohati`.`home_sv`.`dur`  AS  `Duration` ,\n `co-operativebank-mohati`.`home_sv`.`dur_type`  AS  `Durattion_D` ,\n \'\' AS  `Inst` ,\n `co-operativebank-mohati`.`home_sv`.`scheme`  AS  `Scheme`  from  `co-operativebank-mohati`.`home_sv`  union  all  select  `co-operativebank-mohati`.`pension`.`Code`  AS  `code` ,\n `co-operativebank-mohati`.`pension`.`amt`  AS  `amt` ,\n `co-operativebank-mohati`.`pension`.`interst`  AS  `interst` ,\n \'\' AS  `nq` ,\n `co-operativebank-mohati`.`pension`.`dur`  AS  `Duration` ,\n `co-operativebank-mohati`.`pension`.`dur_type`  AS  `Durattion_D` ,\n \'\' AS  `Inst` ,\n `co-operativebank-mohati`.`pension`.`scheme`  AS  `Scheme`  from  `co-operativebank-mohati`.`pension`  union  all  select  `co-operativebank-mohati`.`mis`.`Code`  AS  `code` ,\n `co-operativebank-mohati`.`mis`.`amt`  AS  `amt` ,\n `co-operativebank-mohati`.`mis`.`interst`  AS  `interst` ,\n \'\' AS  `nq` ,\n `co-operativebank-mohati`.`mis`.`dur`  AS  `Duration` ,\n `co-operativebank-mohati`.`mis`.`dur_type`  AS  `Durattion_D` ,\n \'\' AS  `Inst` ,\n `co-operativebank-mohati`.`mis`.`scheme`  AS  `Scheme`  from  `co-operativebank-mohati`.`mis`  union  all  select  `co-operativebank-mohati`.`other`.`Code`  AS  `code` ,\n `co-operativebank-mohati`.`other`.`P_Amt`  AS  `p_amt` ,\n `co-operativebank-mohati`.`other`.`Interest`  AS  `interest` ,\n \'\' AS  `nq` ,\n `co-operativebank-mohati`.`other`.`Duration`  AS  `Duration` ,\n `co-operativebank-mohati`.`other`.`Durattion_D`  AS  `Durattion_D` ,\n \'\' AS  `Inst` ,\n `co-operativebank-mohati`.`other`.`scheme`  AS  `Scheme`  from  `co-operativebank-mohati`.`other`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-mohati`.`sv`.`code` AS `code`,`co-operativebank-mohati`.`sv`.`amt` AS `amt`,`co-operativebank-mohati`.`sv`.`interest` AS `interest`,\'\' AS `nq`,\'\' AS `Duration`,\'\' AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`sv`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`sv` union all select `co-operativebank-mohati`.`fd`.`Code` AS `code`,`co-operativebank-mohati`.`fd`.`P_Amt` AS `p_amt`,`co-operativebank-mohati`.`fd`.`Interest` AS `interest`,\'\' AS `nq`,`co-operativebank-mohati`.`fd`.`Duration` AS `Duration`,`co-operativebank-mohati`.`fd`.`Durattion_D` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`fd`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`fd` union all select `co-operativebank-mohati`.`rd`.`code` AS `code`,`co-operativebank-mohati`.`rd`.`amt` AS `amt`,`co-operativebank-mohati`.`rd`.`interest` AS `interest`,`co-operativebank-mohati`.`rd`.`nq` AS `nq`,\'\' AS `Duration`,\'\' AS `Durattion_D`,`co-operativebank-mohati`.`rd`.`Inst` AS `Inst`,`co-operativebank-mohati`.`rd`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`rd` union all select `co-operativebank-mohati`.`reinv`.`Code` AS `code`,`co-operativebank-mohati`.`reinv`.`amt` AS `amt`,`co-operativebank-mohati`.`reinv`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank-mohati`.`reinv`.`dur` AS `Duration`,`co-operativebank-mohati`.`reinv`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`reinv`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`reinv` union all select `co-operativebank-mohati`.`home_sv`.`Code` AS `code`,`co-operativebank-mohati`.`home_sv`.`amt` AS `amt`,`co-operativebank-mohati`.`home_sv`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank-mohati`.`home_sv`.`dur` AS `Duration`,`co-operativebank-mohati`.`home_sv`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`home_sv`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`home_sv` union all select `co-operativebank-mohati`.`pension`.`Code` AS `code`,`co-operativebank-mohati`.`pension`.`amt` AS `amt`,`co-operativebank-mohati`.`pension`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank-mohati`.`pension`.`dur` AS `Duration`,`co-operativebank-mohati`.`pension`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`pension`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`pension` union all select `co-operativebank-mohati`.`mis`.`Code` AS `code`,`co-operativebank-mohati`.`mis`.`amt` AS `amt`,`co-operativebank-mohati`.`mis`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank-mohati`.`mis`.`dur` AS `Duration`,`co-operativebank-mohati`.`mis`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`mis`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`mis` union all select `co-operativebank-mohati`.`other`.`Code` AS `code`,`co-operativebank-mohati`.`other`.`P_Amt` AS `p_amt`,`co-operativebank-mohati`.`other`.`Interest` AS `interest`,\'\' AS `nq`,`co-operativebank-mohati`.`other`.`Duration` AS `Duration`,`co-operativebank-mohati`.`other`.`Durattion_D` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank-mohati`.`other`.`scheme` AS `Scheme` from `co-operativebank-mohati`.`other`
