TYPE=VIEW
query=select `b`.`bgId` AS `bgId`,`b`.`intCowId` AS `evtCowId`,`b`.`scoreDate` AS `scoreDate`,substring_index(group_concat(`b`.`score` order by `e`.`dateEvtDate` DESC,`e`.`intEvtId` ASC separator \',\'),\',\',1) AS `score`,`b`.`empId` AS `empId`,`b`.`reproductionStep` AS `reproductionStep`,`b`.`intPastureId` AS `intPastureId` from (`heatwatch`.`bodygrade` `b` join `heatwatch`.`events` `e` on((`b`.`intEvtId` = `e`.`intEvtId`))) group by `e`.`intCowId`
md5=862893bfb2d5d7b1510eeb3b199e1914
updatable=0
algorithm=0
definer_user=roo
definer_host=%
suid=1
with_check_option=0
timestamp=2022-12-14 10:07:38
create-version=1
source=select `b`.`bgId` AS `bgId`,`b`.`intCowId` AS `evtCowId`,`b`.`scoreDate` AS `scoreDate`,substring_index(group_concat(`b`.`score` order by `e`.`dateEvtDate` DESC,`e`.`intEvtId` ASC separator \',\'),\',\',1) AS `score`,`b`.`empId` AS `empId`,`b`.`reproductionStep` AS `reproductionStep`,`b`.`intPastureId` AS `intPastureId` from (`bodygrade` `b` join `events` `e` on(`b`.`intEvtId` = `e`.`intEvtId`)) group by `e`.`intCowId`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `b`.`bgId` AS `bgId`,`b`.`intCowId` AS `evtCowId`,`b`.`scoreDate` AS `scoreDate`,substring_index(group_concat(`b`.`score` order by `e`.`dateEvtDate` DESC,`e`.`intEvtId` ASC separator \',\'),\',\',1) AS `score`,`b`.`empId` AS `empId`,`b`.`reproductionStep` AS `reproductionStep`,`b`.`intPastureId` AS `intPastureId` from (`heatwatch`.`bodygrade` `b` join `heatwatch`.`events` `e` on((`b`.`intEvtId` = `e`.`intEvtId`))) group by `e`.`intCowId`
