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