| 123456789101112131415 |
- 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`
|
