| 12345678910111213141516 |
- TYPE=VIEW
- query=select count(`tmrwatch`.`recbutton`.`ID`) AS `mycount`,`tmrwatch`.`recbutton`.`ID` AS `id`,avg(`tmrwatch`.`recweight`.`Weight`) AS `ActualWeight` from (`tmrwatch`.`recbutton` left join `tmrwatch`.`recweight` on(`tmrwatch`.`recweight`.`SrcAddr` = `tmrwatch`.`recbutton`.`SrcAddr` and abs(time_to_sec(timediff(`tmrwatch`.`recbutton`.`InTime`,`tmrwatch`.`recweight`.`MTime`))) < 14)) group by `tmrwatch`.`recbutton`.`ID`
- md5=7cdeab2e50b96384abc8bf3adf4410b7
- updatable=0
- 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 count(`recbutton`.`ID`) AS `mycount`,`recbutton`.`ID` AS `id`,avg(`recweight`.`Weight`) AS `ActualWeight` from (`recbutton` left join `recweight` on(((`recweight`.`SrcAddr` = `recbutton`.`SrcAddr`) and (abs(time_to_sec(timediff(`recbutton`.`InTime`,`recweight`.`MTime`))) < 14)))) group by `recbutton`.`ID`
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select count(`tmrwatch`.`recbutton`.`ID`) AS `mycount`,`tmrwatch`.`recbutton`.`ID` AS `id`,avg(`tmrwatch`.`recweight`.`Weight`) AS `ActualWeight` from (`tmrwatch`.`recbutton` left join `tmrwatch`.`recweight` on(`tmrwatch`.`recweight`.`SrcAddr` = `tmrwatch`.`recbutton`.`SrcAddr` and abs(time_to_sec(timediff(`tmrwatch`.`recbutton`.`InTime`,`tmrwatch`.`recweight`.`MTime`))) < 14)) group by `tmrwatch`.`recbutton`.`ID`
- mariadb-version=100511
|
