TYPE=VIEW
query=select `heatwatch`.`foot`.`intCowId` AS `intCowId`,max(`heatwatch`.`foot`.`FootDate`) AS `foot_date` from `heatwatch`.`foot` where ((to_days(curdate()) - to_days(`heatwatch`.`foot`.`FootDate`)) < 60) group by `heatwatch`.`foot`.`intCowId`
md5=81295255fc8ea496f75c3ac9cbc86015
updatable=0
algorithm=0
definer_user=roo
definer_host=%
suid=1
with_check_option=0
timestamp=2022-12-14 10:07:39
create-version=1
source=select `foot`.`intCowId` AS `intCowId`,max(`foot`.`FootDate`) AS `foot_date` from `foot` where to_days(curdate()) - to_days(`foot`.`FootDate`) < 60 group by `foot`.`intCowId`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `heatwatch`.`foot`.`intCowId` AS `intCowId`,max(`heatwatch`.`foot`.`FootDate`) AS `foot_date` from `heatwatch`.`foot` where ((to_days(curdate()) - to_days(`heatwatch`.`foot`.`FootDate`)) < 60) group by `heatwatch`.`foot`.`intCowId`