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