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
