TYPE=VIEW
query=select `tmrwatch`.`downloadplandtl2`.`FBarID` AS `FBarID`,count(`tmrwatch`.`downloadplandtl2`.`ID`) AS `Count_havebutton_ID` from (`tmrwatch`.`downloadedplan` join `tmrwatch`.`downloadplandtl2` on(`tmrwatch`.`downloadedplan`.`id` = `tmrwatch`.`downloadplandtl2`.`PID`)) where `tmrwatch`.`downloadedplan`.`Mydate` < current_timestamp() and `tmrwatch`.`downloadplandtl2`.`HaveButtom` = 1 group by `tmrwatch`.`downloadplandtl2`.`FBarID`
md5=13a73de8a314d0e4717b30a1f3534509
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_havebutton_ID` from (`downloadedplan` join `downloadplandtl2` on((`downloadedplan`.`id` = `downloadplandtl2`.`PID`))) where ((`downloadedplan`.`Mydate` < now()) and (`downloadplandtl2`.`HaveButtom` = 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_havebutton_ID` from (`tmrwatch`.`downloadedplan` join `tmrwatch`.`downloadplandtl2` on(`tmrwatch`.`downloadedplan`.`id` = `tmrwatch`.`downloadplandtl2`.`PID`)) where `tmrwatch`.`downloadedplan`.`Mydate` < current_timestamp() and `tmrwatch`.`downloadplandtl2`.`HaveButtom` = 1 group by `tmrwatch`.`downloadplandtl2`.`FBarID`
mariadb-version=100511