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