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`,substring_index(group_concat(`heatwatch`.`eventcount`.`todayTotal` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) AS `today_no`,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` = \'兽医\') and (`heatwatch`.`eventcount`.`intPastureId` = 12)) 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=15be228b3c5fb931e7a2a567fd30eb92
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`,substring_index(group_concat(`eventcount`.`todayTotal` order by `eventcount`.`id` DESC separator \',\'),\',\',1) AS `today_no`,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` = \'兽医\' and `eventcount`.`intPastureId` = 12 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`,substring_index(group_concat(`heatwatch`.`eventcount`.`todayTotal` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) AS `today_no`,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` = \'兽医\') and (`heatwatch`.`eventcount`.`intPastureId` = 12)) 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)