| 123456789101112131415 |
- TYPE=VIEW
- query=select substring_index(group_concat(`heatwatch`.`messageoverview`.`id` order by `heatwatch`.`messageoverview`.`id` DESC separator \',\'),\',\',1) AS `id`,`heatwatch`.`messageoverview`.`intPastureid` AS `intPastureid`,substring_index(group_concat(`heatwatch`.`messageoverview`.`code` order by `heatwatch`.`messageoverview`.`id` DESC separator \',\'),\',\',1) AS `code`,`heatwatch`.`messageoverview`.`name` AS `name`,substring_index(group_concat(`heatwatch`.`messageoverview`.`value` order by `heatwatch`.`messageoverview`.`id` DESC separator \',\'),\',\',1) AS `value`,substring_index(group_concat(`heatwatch`.`messageoverview`.`created` order by `heatwatch`.`messageoverview`.`id` DESC separator \',\'),\',\',1) AS `created` from `heatwatch`.`messageoverview` where ((`heatwatch`.`messageoverview`.`name` in (\'泌乳天数\',\'产后180天未孕头数\',\'产后90天未配头数\',\'产后120天未配头数\',\'产犊头数\',\'流产头数\',\'产犊间隔\',\'投产月龄\',\'后备牛15月龄未配牛头数\',\'后备牛18月龄未孕牛头数\',\'超22月龄未孕头数\',\'18月怀孕率\',\'配种头数\',\'报孕头数\',\'配孕天数\')) and `heatwatch`.`messageoverview`.`intPastureid` in (select `heatwatch`.`pasture`.`intPastureId` from `heatwatch`.`pasture`)) group by `heatwatch`.`messageoverview`.`intPastureid`,`heatwatch`.`messageoverview`.`name` order by `heatwatch`.`messageoverview`.`intPastureid`,`heatwatch`.`messageoverview`.`created` desc
- md5=29c30e4c9e0dd6f2cec222c0c76861e3
- 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 substring_index(group_concat(`messageoverview`.`id` order by `messageoverview`.`id` DESC separator \',\'),\',\',1) AS `id`,`messageoverview`.`intPastureid` AS `intPastureid`,substring_index(group_concat(`messageoverview`.`code` order by `messageoverview`.`id` DESC separator \',\'),\',\',1) AS `code`,`messageoverview`.`name` AS `name`,substring_index(group_concat(`messageoverview`.`value` order by `messageoverview`.`id` DESC separator \',\'),\',\',1) AS `value`,substring_index(group_concat(`messageoverview`.`created` order by `messageoverview`.`id` DESC separator \',\'),\',\',1) AS `created` from `messageoverview` where `messageoverview`.`name` in (\'泌乳天数\',\'产后180天未孕头数\',\'产后90天未配头数\',\'产后120天未配头数\',\'产犊头数\',\'流产头数\',\'产犊间隔\',\'投产月龄\',\'后备牛15月龄未配牛头数\',\'后备牛18月龄未孕牛头数\',\'超22月龄未孕头数\',\'18月怀孕率\',\'配种头数\',\'报孕头数\',\'配孕天数\') and `messageoverview`.`intPastureid` in (select `pasture`.`intPastureId` from `pasture`) group by `messageoverview`.`intPastureid`,`messageoverview`.`name` order by `messageoverview`.`intPastureid`,`messageoverview`.`created` desc
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select substring_index(group_concat(`heatwatch`.`messageoverview`.`id` order by `heatwatch`.`messageoverview`.`id` DESC separator \',\'),\',\',1) AS `id`,`heatwatch`.`messageoverview`.`intPastureid` AS `intPastureid`,substring_index(group_concat(`heatwatch`.`messageoverview`.`code` order by `heatwatch`.`messageoverview`.`id` DESC separator \',\'),\',\',1) AS `code`,`heatwatch`.`messageoverview`.`name` AS `name`,substring_index(group_concat(`heatwatch`.`messageoverview`.`value` order by `heatwatch`.`messageoverview`.`id` DESC separator \',\'),\',\',1) AS `value`,substring_index(group_concat(`heatwatch`.`messageoverview`.`created` order by `heatwatch`.`messageoverview`.`id` DESC separator \',\'),\',\',1) AS `created` from `heatwatch`.`messageoverview` where ((`heatwatch`.`messageoverview`.`name` in (\'泌乳天数\',\'产后180天未孕头数\',\'产后90天未配头数\',\'产后120天未配头数\',\'产犊头数\',\'流产头数\',\'产犊间隔\',\'投产月龄\',\'后备牛15月龄未配牛头数\',\'后备牛18月龄未孕牛头数\',\'超22月龄未孕头数\',\'18月怀孕率\',\'配种头数\',\'报孕头数\',\'配孕天数\')) and `heatwatch`.`messageoverview`.`intPastureid` in (select `heatwatch`.`pasture`.`intPastureId` from `heatwatch`.`pasture`)) group by `heatwatch`.`messageoverview`.`intPastureid`,`heatwatch`.`messageoverview`.`name` order by `heatwatch`.`messageoverview`.`intPastureid`,`heatwatch`.`messageoverview`.`created` desc
|
