| 12345678910111213141516 |
- TYPE=VIEW
- query=select `tmrwatch`.`feed`.`FNAME` AS `FNAME`,`tmrwatch`.`lpplandtl1`.`ID` AS `ID`,`tmrwatch`.`lpplandtl1`.`PID` AS `PID`,`tmrwatch`.`lpplandtl1`.`FPointID` AS `FPointID`,`tmrwatch`.`lpplandtl1`.`FID` AS `FID`,`tmrwatch`.`lpplandtl1`.`LWEIGHT` AS `LWEIGHT`,`tmrwatch`.`lpplandtl1`.`SORT` AS `SORT`,`tmrwatch`.`currentprojinfo`.`downloadedplanid` AS `downloadedplanid` from ((`tmrwatch`.`currentprojinfo` join `tmrwatch`.`lpplandtl1` on(`tmrwatch`.`currentprojinfo`.`Pid` = `tmrwatch`.`lpplandtl1`.`PID`)) join `tmrwatch`.`feed` on(`tmrwatch`.`lpplandtl1`.`FID` = `tmrwatch`.`feed`.`ID`)) order by `tmrwatch`.`lpplandtl1`.`SORT`,`tmrwatch`.`lpplandtl1`.`FID`
- md5=854d7b34c2690eeede4df02c4caab6b0
- 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 `feed`.`FNAME` AS `FNAME`,`lpplandtl1`.`ID` AS `ID`,`lpplandtl1`.`PID` AS `PID`,`lpplandtl1`.`FPointID` AS `FPointID`,`lpplandtl1`.`FID` AS `FID`,`lpplandtl1`.`LWEIGHT` AS `LWEIGHT`,`lpplandtl1`.`SORT` AS `SORT`,`currentprojinfo`.`downloadedplanid` AS `downloadedplanid` from ((`currentprojinfo` join `lpplandtl1` on((`currentprojinfo`.`Pid` = `lpplandtl1`.`PID`))) join `feed` on((`lpplandtl1`.`FID` = `feed`.`ID`))) order by `lpplandtl1`.`SORT`,`lpplandtl1`.`FID`
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `tmrwatch`.`feed`.`FNAME` AS `FNAME`,`tmrwatch`.`lpplandtl1`.`ID` AS `ID`,`tmrwatch`.`lpplandtl1`.`PID` AS `PID`,`tmrwatch`.`lpplandtl1`.`FPointID` AS `FPointID`,`tmrwatch`.`lpplandtl1`.`FID` AS `FID`,`tmrwatch`.`lpplandtl1`.`LWEIGHT` AS `LWEIGHT`,`tmrwatch`.`lpplandtl1`.`SORT` AS `SORT`,`tmrwatch`.`currentprojinfo`.`downloadedplanid` AS `downloadedplanid` from ((`tmrwatch`.`currentprojinfo` join `tmrwatch`.`lpplandtl1` on(`tmrwatch`.`currentprojinfo`.`Pid` = `tmrwatch`.`lpplandtl1`.`PID`)) join `tmrwatch`.`feed` on(`tmrwatch`.`lpplandtl1`.`FID` = `tmrwatch`.`feed`.`ID`)) order by `tmrwatch`.`lpplandtl1`.`SORT`,`tmrwatch`.`lpplandtl1`.`FID`
- mariadb-version=100511
|
