| 12345678910111213141516 |
- TYPE=VIEW
- query=select `tmrwatch`.`downloadplandtl2`.`FBarID` AS `FBarID`,count(`tmrwatch`.`downloadplandtl2`.`ID`) AS `Count_ID`,avg(`tmrwatch`.`downloadplandtl2`.`ActualWeightMinus` / if(`tmrwatch`.`downloadplandtl2`.`LWEIGHT` = 0 or `tmrwatch`.`downloadplandtl2`.`LWEIGHT` is null,9999999999999999,`tmrwatch`.`downloadplandtl2`.`LWEIGHT`)) AS `Avg_Err` from (`tmrwatch`.`downloadedplan` join `tmrwatch`.`downloadplandtl2` on(`tmrwatch`.`downloadedplan`.`id` = `tmrwatch`.`downloadplandtl2`.`PID`)) where `tmrwatch`.`downloadedplan`.`Mydate` < current_timestamp() and `tmrwatch`.`downloadplandtl2`.`ButtonSucc` = 1 group by `tmrwatch`.`downloadplandtl2`.`FBarID`
- md5=d93399dca450ac3f14556bb05ffe2b94
- updatable=0
- 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 `downloadplandtl2`.`FBarID` AS `FBarID`,count(`downloadplandtl2`.`ID`) AS `Count_ID`,avg((`downloadplandtl2`.`ActualWeightMinus` / if(((`downloadplandtl2`.`LWEIGHT` = 0) or isnull(`downloadplandtl2`.`LWEIGHT`)),9999999999999999,`downloadplandtl2`.`LWEIGHT`))) AS `Avg_Err` from (`downloadedplan` join `downloadplandtl2` on((`downloadedplan`.`id` = `downloadplandtl2`.`PID`))) where ((`downloadedplan`.`Mydate` < now()) and (`downloadplandtl2`.`ButtonSucc` = 1)) group by `downloadplandtl2`.`FBarID`
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `tmrwatch`.`downloadplandtl2`.`FBarID` AS `FBarID`,count(`tmrwatch`.`downloadplandtl2`.`ID`) AS `Count_ID`,avg(`tmrwatch`.`downloadplandtl2`.`ActualWeightMinus` / if(`tmrwatch`.`downloadplandtl2`.`LWEIGHT` = 0 or `tmrwatch`.`downloadplandtl2`.`LWEIGHT` is null,9999999999999999,`tmrwatch`.`downloadplandtl2`.`LWEIGHT`)) AS `Avg_Err` from (`tmrwatch`.`downloadedplan` join `tmrwatch`.`downloadplandtl2` on(`tmrwatch`.`downloadedplan`.`id` = `tmrwatch`.`downloadplandtl2`.`PID`)) where `tmrwatch`.`downloadedplan`.`Mydate` < current_timestamp() and `tmrwatch`.`downloadplandtl2`.`ButtonSucc` = 1 group by `tmrwatch`.`downloadplandtl2`.`FBarID`
- mariadb-version=100511
|
