TYPE=VIEW
query=select `evtmove`.`intPastureId` AS `intPastureId`,`evtmove`.`intEvtId` AS `intEvtId`,`evtmove`.`intCowId` AS `evtCowId`,`evtmove`.`dateEvtDate` AS `evtmoveDate`,`heatwatch`.`classlist`.`varName` AS `intMoveClass`,`heatwatch`.`movebar`.`intNewBarName` AS `intNewBarName`,`heatwatch`.`employee`.`varEmployeeName` AS `movePersoner`,`evtmove`.`varNotes` AS `moveNotes` from (((`heatwatch`.`events` `evtmove` join `heatwatch`.`movebar` on(((`heatwatch`.`movebar`.`intEvtId` = `evtmove`.`intEvtId`) and (`heatwatch`.`movebar`.`intPastureId` = `evtmove`.`intPastureId`)))) left join `heatwatch`.`classlist` on(((`heatwatch`.`movebar`.`intMoveClass` = `heatwatch`.`classlist`.`intClassListId`) and (`heatwatch`.`movebar`.`intPastureId` = `heatwatch`.`classlist`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtmove`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtmove`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))
md5=88730bf6062c9905c1763759a0230076
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-12-14 10:07:39
create-version=1
source=select `evtmove`.`intPastureId` AS `intPastureId`,`evtmove`.`intEvtId` AS `intEvtId`,`evtmove`.`intCowId` AS `evtCowId`,`evtmove`.`dateEvtDate` AS `evtmoveDate`,`classlist`.`varName` AS `intMoveClass`,`movebar`.`intNewBarName` AS `intNewBarName`,`employee`.`varEmployeeName` AS `movePersoner`,`evtmove`.`varNotes` AS `moveNotes` from (((`events` `evtmove` join `movebar` on(`movebar`.`intEvtId` = `evtmove`.`intEvtId` and `movebar`.`intPastureId` = `evtmove`.`intPastureId`)) left join `classlist` on(`movebar`.`intMoveClass` = `classlist`.`intClassListId` and `movebar`.`intPastureId` = `classlist`.`intPastureId`)) left join `employee` on(`evtmove`.`intPersoner` = `employee`.`intEmployeeId` and `evtmove`.`intPastureId` = `employee`.`intPastureId`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `evtmove`.`intPastureId` AS `intPastureId`,`evtmove`.`intEvtId` AS `intEvtId`,`evtmove`.`intCowId` AS `evtCowId`,`evtmove`.`dateEvtDate` AS `evtmoveDate`,`heatwatch`.`classlist`.`varName` AS `intMoveClass`,`heatwatch`.`movebar`.`intNewBarName` AS `intNewBarName`,`heatwatch`.`employee`.`varEmployeeName` AS `movePersoner`,`evtmove`.`varNotes` AS `moveNotes` from (((`heatwatch`.`events` `evtmove` join `heatwatch`.`movebar` on(((`heatwatch`.`movebar`.`intEvtId` = `evtmove`.`intEvtId`) and (`heatwatch`.`movebar`.`intPastureId` = `evtmove`.`intPastureId`)))) left join `heatwatch`.`classlist` on(((`heatwatch`.`movebar`.`intMoveClass` = `heatwatch`.`classlist`.`intClassListId`) and (`heatwatch`.`movebar`.`intPastureId` = `heatwatch`.`classlist`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtmove`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtmove`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))
