| 123456789101112131415 |
- TYPE=VIEW
- query=select `e1`.`varcowcode` AS `varcowcode`,round(timestampdiff(HOUR,substring_index(group_concat(`e1`.`actdatetime` order by `e1`.`actdatetime` DESC separator \',\'),\',\',1),now()),0) AS `afterwarn`,substring_index(group_concat(`e1`.`actdatetime` order by `e1`.`actdatetime` DESC separator \',\'),\',\',1) AS `datetime`,if((substring_index(group_concat(`e1`.`second_filter` order by `e1`.`actdatetime` DESC separator \',\'),\',\',1) = 1),1,substring_index(group_concat(`e1`.`actlevel` order by `e1`.`actdatetime` DESC separator \',\'),\',\',1)) AS `actlevel` from `heatwatch`.`estrusact` `e1` where (((to_days(curdate()) - to_days(`e1`.`actdatetime`)) < 2) and (`e1`.`result` = 0) and (ifnull(`e1`.`falsedel`,0) = 0)) group by `e1`.`varcowcode`
- md5=dbe87c8084e7c753853bc0d3132557ac
- updatable=0
- algorithm=0
- definer_user=root
- definer_host=localhost
- suid=1
- with_check_option=0
- timestamp=2022-12-14 10:07:39
- create-version=1
- source=select `e1`.`varcowcode` AS `varcowcode`,round(timestampdiff(HOUR,substring_index(group_concat(`e1`.`actdatetime` order by `e1`.`actdatetime` DESC separator \',\'),\',\',1),current_timestamp()),0) AS `afterwarn`,substring_index(group_concat(`e1`.`actdatetime` order by `e1`.`actdatetime` DESC separator \',\'),\',\',1) AS `datetime`,if(substring_index(group_concat(`e1`.`second_filter` order by `e1`.`actdatetime` DESC separator \',\'),\',\',1) = 1,1,substring_index(group_concat(`e1`.`actlevel` order by `e1`.`actdatetime` DESC separator \',\'),\',\',1)) AS `actlevel` from `estrusact` `e1` where to_days(curdate()) - to_days(`e1`.`actdatetime`) < 2 and `e1`.`result` = 0 and ifnull(`e1`.`falsedel`,0) = 0 group by `e1`.`varcowcode`
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `e1`.`varcowcode` AS `varcowcode`,round(timestampdiff(HOUR,substring_index(group_concat(`e1`.`actdatetime` order by `e1`.`actdatetime` DESC separator \',\'),\',\',1),now()),0) AS `afterwarn`,substring_index(group_concat(`e1`.`actdatetime` order by `e1`.`actdatetime` DESC separator \',\'),\',\',1) AS `datetime`,if((substring_index(group_concat(`e1`.`second_filter` order by `e1`.`actdatetime` DESC separator \',\'),\',\',1) = 1),1,substring_index(group_concat(`e1`.`actlevel` order by `e1`.`actdatetime` DESC separator \',\'),\',\',1)) AS `actlevel` from `heatwatch`.`estrusact` `e1` where (((to_days(curdate()) - to_days(`e1`.`actdatetime`)) < 2) and (`e1`.`result` = 0) and (ifnull(`e1`.`falsedel`,0) = 0)) group by `e1`.`varcowcode`
|
