TYPE=VIEW
query=select `tmrwatch`.`lpplan`.`ProjName` AS `ProjName`,`tmrwatch`.`lpplan`.`PDATE` AS `PDATE`,`tmrwatch`.`lpplan`.`PEDate` AS `PEDate`,if(`tmrwatch`.`downloadedplan`.`ProjName` is null,\'未生效\',`tmrwatch`.`downloadedplan`.`ProjName`) AS `DownloadedPrijName`,`tmrwatch`.`downloadedplan`.`Mydate` AS `Mydate`,if(`tmrwatch`.`downloadedplan`.`id` is null,-1,`tmrwatch`.`downloadedplan`.`id`) AS `downloadedplanid`,`tmrwatch`.`lpplan`.`TID` AS `TID`,`tmrwatch`.`tmr`.`TNAME` AS `TNAME` from ((`tmrwatch`.`lpplan` left join `tmrwatch`.`downloadedplan` on(`tmrwatch`.`lpplan`.`ID` = `tmrwatch`.`downloadedplan`.`Pid`)) join `tmrwatch`.`tmr` on(`tmrwatch`.`lpplan`.`TID` = `tmrwatch`.`tmr`.`ID`)) where `tmrwatch`.`lpplan`.`Sel` = 1
md5=b2f226c8d900976fff7a565baff4be42
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-12-05 04:06:50
create-version=2
source=select `lpplan`.`ProjName` AS `ProjName`,`lpplan`.`PDATE` AS `PDATE`,`lpplan`.`PEDate` AS `PEDate`,if(isnull(`downloadedplan`.`ProjName`),\'未生效\',`downloadedplan`.`ProjName`) AS `DownloadedPrijName`,`downloadedplan`.`Mydate` AS `Mydate`,if(isnull(`downloadedplan`.`id`),-(1),`downloadedplan`.`id`) AS `downloadedplanid`,`lpplan`.`TID` AS `TID`,`tmr`.`TNAME` AS `TNAME` from ((`lpplan` left join `downloadedplan` on((`lpplan`.`ID` = `downloadedplan`.`Pid`))) join `tmr` on((`lpplan`.`TID` = `tmr`.`ID`))) where (`lpplan`.`Sel` = 1)
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `tmrwatch`.`lpplan`.`ProjName` AS `ProjName`,`tmrwatch`.`lpplan`.`PDATE` AS `PDATE`,`tmrwatch`.`lpplan`.`PEDate` AS `PEDate`,if(`tmrwatch`.`downloadedplan`.`ProjName` is null,\'未生效\',`tmrwatch`.`downloadedplan`.`ProjName`) AS `DownloadedPrijName`,`tmrwatch`.`downloadedplan`.`Mydate` AS `Mydate`,if(`tmrwatch`.`downloadedplan`.`id` is null,-1,`tmrwatch`.`downloadedplan`.`id`) AS `downloadedplanid`,`tmrwatch`.`lpplan`.`TID` AS `TID`,`tmrwatch`.`tmr`.`TNAME` AS `TNAME` from ((`tmrwatch`.`lpplan` left join `tmrwatch`.`downloadedplan` on(`tmrwatch`.`lpplan`.`ID` = `tmrwatch`.`downloadedplan`.`Pid`)) join `tmrwatch`.`tmr` on(`tmrwatch`.`lpplan`.`TID` = `tmrwatch`.`tmr`.`ID`)) where `tmrwatch`.`lpplan`.`Sel` = 1
mariadb-version=100511