| 12345678910111213141516 |
- TYPE=VIEW
- query=select `tmrwatch`.`downloadplandtl1_exec`.`ID` AS `ID`,`tmrwatch`.`downloadplandtl1_exec`.`PID` AS `PID` from (`tmrwatch`.`downloadplandtl1_exec` join `tmrwatch`.`feed` on(`tmrwatch`.`downloadplandtl1_exec`.`Fid` = `tmrwatch`.`feed`.`ID` and abs(`tmrwatch`.`downloadplandtl1_exec`.`ActualWeightMinus` - `tmrwatch`.`downloadplandtl1_exec`.`LWEIGHT`) > `tmrwatch`.`feed`.`AllowRatio`)) where `tmrwatch`.`downloadplandtl1_exec`.`ButtonSucc` = 1 and `tmrwatch`.`downloadplandtl1_exec`.`Fid` is not null
- md5=243c2d70d5543a7614fe8fbfeda657ab
- 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 `downloadplandtl1_exec`.`ID` AS `ID`,`downloadplandtl1_exec`.`PID` AS `PID` from (`downloadplandtl1_exec` join `feed` on(((`downloadplandtl1_exec`.`Fid` = `feed`.`ID`) and (abs((`downloadplandtl1_exec`.`ActualWeightMinus` - `downloadplandtl1_exec`.`LWEIGHT`)) > `feed`.`AllowRatio`)))) where ((`downloadplandtl1_exec`.`ButtonSucc` = 1) and (`downloadplandtl1_exec`.`Fid` is not null))
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `tmrwatch`.`downloadplandtl1_exec`.`ID` AS `ID`,`tmrwatch`.`downloadplandtl1_exec`.`PID` AS `PID` from (`tmrwatch`.`downloadplandtl1_exec` join `tmrwatch`.`feed` on(`tmrwatch`.`downloadplandtl1_exec`.`Fid` = `tmrwatch`.`feed`.`ID` and abs(`tmrwatch`.`downloadplandtl1_exec`.`ActualWeightMinus` - `tmrwatch`.`downloadplandtl1_exec`.`LWEIGHT`) > `tmrwatch`.`feed`.`AllowRatio`)) where `tmrwatch`.`downloadplandtl1_exec`.`ButtonSucc` = 1 and `tmrwatch`.`downloadplandtl1_exec`.`Fid` is not null
- mariadb-version=100511
|
