| 12345678910111213141516 |
- TYPE=VIEW
- query=select `tmrwatch`.`feedp`.`BNAME` AS `bNAME`,`tmrwatch`.`lpplandtl2`.`ID` AS `ID`,`tmrwatch`.`lpplandtl2`.`PID` AS `PID`,`tmrwatch`.`lpplandtl2`.`FBarID` AS `FBarID`,`tmrwatch`.`lpplandtl2`.`LWEIGHT` AS `LWEIGHT`,`tmrwatch`.`lpplandtl2`.`SORT` AS `SORT`,`tmrwatch`.`currentprojinfo`.`downloadedplanid` AS `downloadedplanid` from ((`tmrwatch`.`currentprojinfo` join `tmrwatch`.`lpplandtl2` on(`tmrwatch`.`currentprojinfo`.`Pid` = `tmrwatch`.`lpplandtl2`.`PID`)) join `tmrwatch`.`feedp` on(`tmrwatch`.`lpplandtl2`.`FBarID` = `tmrwatch`.`feedp`.`ID`)) order by `tmrwatch`.`lpplandtl2`.`SORT`,`tmrwatch`.`lpplandtl2`.`FBarID`
- md5=6a460e4d4469f10a0ba62a031110a01a
- updatable=1
- algorithm=0
- definer_user=root
- definer_host=localhost
- suid=1
- with_check_option=0
- timestamp=2021-12-05 04:06:49
- create-version=2
- source=select `feedp`.`BNAME` AS `bNAME`,`lpplandtl2`.`ID` AS `ID`,`lpplandtl2`.`PID` AS `PID`,`lpplandtl2`.`FBarID` AS `FBarID`,`lpplandtl2`.`LWEIGHT` AS `LWEIGHT`,`lpplandtl2`.`SORT` AS `SORT`,`currentprojinfo`.`downloadedplanid` AS `downloadedplanid` from ((`currentprojinfo` join `lpplandtl2` on((`currentprojinfo`.`Pid` = `lpplandtl2`.`PID`))) join `feedp` on((`lpplandtl2`.`FBarID` = `feedp`.`ID`))) order by `lpplandtl2`.`SORT`,`lpplandtl2`.`FBarID`
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `tmrwatch`.`feedp`.`BNAME` AS `bNAME`,`tmrwatch`.`lpplandtl2`.`ID` AS `ID`,`tmrwatch`.`lpplandtl2`.`PID` AS `PID`,`tmrwatch`.`lpplandtl2`.`FBarID` AS `FBarID`,`tmrwatch`.`lpplandtl2`.`LWEIGHT` AS `LWEIGHT`,`tmrwatch`.`lpplandtl2`.`SORT` AS `SORT`,`tmrwatch`.`currentprojinfo`.`downloadedplanid` AS `downloadedplanid` from ((`tmrwatch`.`currentprojinfo` join `tmrwatch`.`lpplandtl2` on(`tmrwatch`.`currentprojinfo`.`Pid` = `tmrwatch`.`lpplandtl2`.`PID`)) join `tmrwatch`.`feedp` on(`tmrwatch`.`lpplandtl2`.`FBarID` = `tmrwatch`.`feedp`.`ID`)) order by `tmrwatch`.`lpplandtl2`.`SORT`,`tmrwatch`.`lpplandtl2`.`FBarID`
- mariadb-version=100511
|
