TYPE=VIEW
query=select `tmrwatch`.`downloadplandtl2`.`ID` AS `ID`,`tmrwatch`.`downloadplandtl2`.`PID` AS `PID` from (`tmrwatch`.`downloadplandtl2` join `tmrwatch`.`feedp` on(`tmrwatch`.`downloadplandtl2`.`FBarID` = `tmrwatch`.`feedp`.`ID` and abs(`tmrwatch`.`downloadplandtl2`.`ActualWeightMinus` - `tmrwatch`.`downloadplandtl2`.`LWEIGHT`) > `tmrwatch`.`feedp`.`AllowRatio`)) where `tmrwatch`.`downloadplandtl2`.`ButtonSucc` = 1 and `tmrwatch`.`downloadplandtl2`.`FBarID` <> 0
md5=b812194222b4b318a0506b41ebe1a674
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-12-05 04:06:50
create-version=2
source=select `downloadplandtl2`.`ID` AS `ID`,`downloadplandtl2`.`PID` AS `PID` from (`downloadplandtl2` join `feedp` on(((`downloadplandtl2`.`FBarID` = `feedp`.`ID`) and (abs((`downloadplandtl2`.`ActualWeightMinus` - `downloadplandtl2`.`LWEIGHT`)) > `feedp`.`AllowRatio`)))) where ((`downloadplandtl2`.`ButtonSucc` = 1) and (`downloadplandtl2`.`FBarID` <> 0))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `tmrwatch`.`downloadplandtl2`.`ID` AS `ID`,`tmrwatch`.`downloadplandtl2`.`PID` AS `PID` from (`tmrwatch`.`downloadplandtl2` join `tmrwatch`.`feedp` on(`tmrwatch`.`downloadplandtl2`.`FBarID` = `tmrwatch`.`feedp`.`ID` and abs(`tmrwatch`.`downloadplandtl2`.`ActualWeightMinus` - `tmrwatch`.`downloadplandtl2`.`LWEIGHT`) > `tmrwatch`.`feedp`.`AllowRatio`)) where `tmrwatch`.`downloadplandtl2`.`ButtonSucc` = 1 and `tmrwatch`.`downloadplandtl2`.`FBarID` <> 0
mariadb-version=100511