| 12345678910111213141516 |
- 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
|
