| 123456789101112131415 |
- TYPE=VIEW
- query=select cast(substring_index(group_concat(`heatwatch`.`eventcount`.`id` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) as signed) AS `stid`,`heatwatch`.`eventcount`.`name` AS `name`,ifnull(substring_index(group_concat(`heatwatch`.`eventcount`.`todayTotal` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1),\'\') AS `today_no`,ifnull(substring_index(group_concat(`heatwatch`.`eventcount`.`monthTotal` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1),\'\') AS `month_no`,`heatwatch`.`eventcount`.`intPastureId` AS `intpastureid` from `heatwatch`.`eventcount` where (`heatwatch`.`eventcount`.`type` = \'奶量\') group by `heatwatch`.`eventcount`.`name`,`heatwatch`.`eventcount`.`intPastureId` order by cast(substring_index(group_concat(`heatwatch`.`eventcount`.`id` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) as signed)
- md5=d5dd8819bbeb0f90840cf45e5ac4e324
- updatable=0
- algorithm=0
- definer_user=root
- definer_host=localhost
- suid=1
- with_check_option=0
- timestamp=2022-12-14 10:07:38
- create-version=1
- source=select cast(substring_index(group_concat(`eventcount`.`id` order by `eventcount`.`id` DESC separator \',\'),\',\',1) as signed) AS `stid`,`eventcount`.`name` AS `name`,ifnull(substring_index(group_concat(`eventcount`.`todayTotal` order by `eventcount`.`id` DESC separator \',\'),\',\',1),\'\') AS `today_no`,ifnull(substring_index(group_concat(`eventcount`.`monthTotal` order by `eventcount`.`id` DESC separator \',\'),\',\',1),\'\') AS `month_no`,`eventcount`.`intPastureId` AS `intpastureid` from `eventcount` where `eventcount`.`type` = \'奶量\' group by `eventcount`.`name`,`eventcount`.`intPastureId` order by cast(substring_index(group_concat(`eventcount`.`id` order by `eventcount`.`id` DESC separator \',\'),\',\',1) as signed)
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select cast(substring_index(group_concat(`heatwatch`.`eventcount`.`id` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) as signed) AS `stid`,`heatwatch`.`eventcount`.`name` AS `name`,ifnull(substring_index(group_concat(`heatwatch`.`eventcount`.`todayTotal` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1),\'\') AS `today_no`,ifnull(substring_index(group_concat(`heatwatch`.`eventcount`.`monthTotal` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1),\'\') AS `month_no`,`heatwatch`.`eventcount`.`intPastureId` AS `intpastureid` from `heatwatch`.`eventcount` where (`heatwatch`.`eventcount`.`type` = \'奶量\') group by `heatwatch`.`eventcount`.`name`,`heatwatch`.`eventcount`.`intPastureId` order by cast(substring_index(group_concat(`heatwatch`.`eventcount`.`id` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) as signed)
|
