| 123456789101112131415 |
- 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`
|
