TYPE=VIEW
query=select `evtblindbubby`.`intPastureId` AS `intPastureId`,`evtblindbubby`.`intEvtId` AS `intEvtId`,`evtblindbubby`.`intCowId` AS `evtCowId`,`evtblindbubby`.`dateEvtDate` AS `evtblindbubbyDate`,`heatwatch`.`employee`.`varEmployeeName` AS `blindbubbyPersoner`,`evtblindbubby`.`varNotes` AS `varblindbubbyNotes`,`heatwatch`.`blindbubby`.`BlindBubbyCount` AS `BlindBubbyCount` from ((`heatwatch`.`events` `evtblindbubby` join `heatwatch`.`blindbubby` on(((`heatwatch`.`blindbubby`.`intEvtId` = `evtblindbubby`.`intEvtId`) and (`heatwatch`.`blindbubby`.`intPastureId` = `evtblindbubby`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtblindbubby`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtblindbubby`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))
md5=dfffb8768b5db3c3eef2c85dcd075e1f
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 `evtblindbubby`.`intPastureId` AS `intPastureId`,`evtblindbubby`.`intEvtId` AS `intEvtId`,`evtblindbubby`.`intCowId` AS `evtCowId`,`evtblindbubby`.`dateEvtDate` AS `evtblindbubbyDate`,`employee`.`varEmployeeName` AS `blindbubbyPersoner`,`evtblindbubby`.`varNotes` AS `varblindbubbyNotes`,`blindbubby`.`BlindBubbyCount` AS `BlindBubbyCount` from ((`events` `evtblindbubby` join `blindbubby` on(`blindbubby`.`intEvtId` = `evtblindbubby`.`intEvtId` and `blindbubby`.`intPastureId` = `evtblindbubby`.`intPastureId`)) left join `employee` on(`evtblindbubby`.`intPersoner` = `employee`.`intEmployeeId` and `evtblindbubby`.`intPastureId` = `employee`.`intPastureId`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `evtblindbubby`.`intPastureId` AS `intPastureId`,`evtblindbubby`.`intEvtId` AS `intEvtId`,`evtblindbubby`.`intCowId` AS `evtCowId`,`evtblindbubby`.`dateEvtDate` AS `evtblindbubbyDate`,`heatwatch`.`employee`.`varEmployeeName` AS `blindbubbyPersoner`,`evtblindbubby`.`varNotes` AS `varblindbubbyNotes`,`heatwatch`.`blindbubby`.`BlindBubbyCount` AS `BlindBubbyCount` from ((`heatwatch`.`events` `evtblindbubby` join `heatwatch`.`blindbubby` on(((`heatwatch`.`blindbubby`.`intEvtId` = `evtblindbubby`.`intEvtId`) and (`heatwatch`.`blindbubby`.`intPastureId` = `evtblindbubby`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtblindbubby`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtblindbubby`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))