TYPE=VIEW
query=select `evtill`.`intPastureId` AS `intPastureId`,`evtill`.`intEvtId` AS `intEvtId`,`evtill`.`intCowId` AS `evtCowId`,`evtill`.`dateEvtDate` AS `evtillDate`,`heatwatch`.`classlist`.`varName` AS `illvarName`,`heatwatch`.`illnotify`.`intSymptom` AS `intSymptom`,`heatwatch`.`illnotify`.`varReason` AS `varReason`,`heatwatch`.`employee`.`varEmployeeName` AS `illPersoner`,`evtill`.`varNotes` AS `varillNotes` from (((`heatwatch`.`events` `evtill` join `heatwatch`.`illnotify` on(((`heatwatch`.`illnotify`.`intEvtId` = `evtill`.`intEvtId`) and (`heatwatch`.`illnotify`.`intPastureId` = `evtill`.`intPastureId`)))) left join `heatwatch`.`classlist` on(((`heatwatch`.`illnotify`.`intClass` = `heatwatch`.`classlist`.`intClassListId`) and (`heatwatch`.`illnotify`.`intPastureId` = `heatwatch`.`classlist`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtill`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtill`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))
md5=1a3bda37742fbe568469d2840c07c923
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 `evtill`.`intPastureId` AS `intPastureId`,`evtill`.`intEvtId` AS `intEvtId`,`evtill`.`intCowId` AS `evtCowId`,`evtill`.`dateEvtDate` AS `evtillDate`,`classlist`.`varName` AS `illvarName`,`illnotify`.`intSymptom` AS `intSymptom`,`illnotify`.`varReason` AS `varReason`,`employee`.`varEmployeeName` AS `illPersoner`,`evtill`.`varNotes` AS `varillNotes` from (((`events` `evtill` join `illnotify` on(`illnotify`.`intEvtId` = `evtill`.`intEvtId` and `illnotify`.`intPastureId` = `evtill`.`intPastureId`)) left join `classlist` on(`illnotify`.`intClass` = `classlist`.`intClassListId` and `illnotify`.`intPastureId` = `classlist`.`intPastureId`)) left join `employee` on(`evtill`.`intPersoner` = `employee`.`intEmployeeId` and `evtill`.`intPastureId` = `employee`.`intPastureId`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `evtill`.`intPastureId` AS `intPastureId`,`evtill`.`intEvtId` AS `intEvtId`,`evtill`.`intCowId` AS `evtCowId`,`evtill`.`dateEvtDate` AS `evtillDate`,`heatwatch`.`classlist`.`varName` AS `illvarName`,`heatwatch`.`illnotify`.`intSymptom` AS `intSymptom`,`heatwatch`.`illnotify`.`varReason` AS `varReason`,`heatwatch`.`employee`.`varEmployeeName` AS `illPersoner`,`evtill`.`varNotes` AS `varillNotes` from (((`heatwatch`.`events` `evtill` join `heatwatch`.`illnotify` on(((`heatwatch`.`illnotify`.`intEvtId` = `evtill`.`intEvtId`) and (`heatwatch`.`illnotify`.`intPastureId` = `evtill`.`intPastureId`)))) left join `heatwatch`.`classlist` on(((`heatwatch`.`illnotify`.`intClass` = `heatwatch`.`classlist`.`intClassListId`) and (`heatwatch`.`illnotify`.`intPastureId` = `heatwatch`.`classlist`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtill`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtill`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))