TYPE=VIEW
query=select `evtleave`.`intPastureId` AS `intPastureId`,`evtleave`.`intEvtId` AS `intEvtId`,`evtleave`.`intCowId` AS `evtCowId`,`evtleave`.`dateEvtDate` AS `evtleaveDate`,`evtleave`.`varNotes` AS `evtleaveNotes`,`heatwatch`.`employee`.`varEmployeeName` AS `leavePersoner`,`c1`.`varName` AS `intLeaveClass`,`c2`.`varName` AS `intReason`,`heatwatch`.`custom`.`varCustomName` AS `varCustomName`,`heatwatch`.`leave`.`decWeight` AS `decWeight`,`heatwatch`.`leave`.`mPrice` AS `mPrice`,`heatwatch`.`leave`.`milkDays` AS `milkDays`,`heatwatch`.`leave`.`DaysAge` AS `DaysAge` from (((((`heatwatch`.`events` `evtleave` join `heatwatch`.`leave` on(((`evtleave`.`intEvtId` = `heatwatch`.`leave`.`intEvtId`) and (`evtleave`.`intPastureId` = `heatwatch`.`leave`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtleave`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtleave`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`)))) left join `heatwatch`.`classlist` `c1` on(((`heatwatch`.`leave`.`intLeaveClass` = `c1`.`intClassListId`) and (`heatwatch`.`leave`.`intPastureId` = `c1`.`intPastureId`)))) left join `heatwatch`.`classlist` `c2` on(((`heatwatch`.`leave`.`intReason` = `c2`.`intClassListId`) and (`heatwatch`.`leave`.`intPastureId` = `c2`.`intPastureId`)))) left join `heatwatch`.`custom` on(((`heatwatch`.`leave`.`varGoWhere` = `heatwatch`.`custom`.`intCustomId`) and (`heatwatch`.`leave`.`intPastureId` = `heatwatch`.`custom`.`intPastureId`))))
md5=e56d8a2589601c704cfe56b6b2d36c69
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 `evtleave`.`intPastureId` AS `intPastureId`,`evtleave`.`intEvtId` AS `intEvtId`,`evtleave`.`intCowId` AS `evtCowId`,`evtleave`.`dateEvtDate` AS `evtleaveDate`,`evtleave`.`varNotes` AS `evtleaveNotes`,`employee`.`varEmployeeName` AS `leavePersoner`,`c1`.`varName` AS `intLeaveClass`,`c2`.`varName` AS `intReason`,`custom`.`varCustomName` AS `varCustomName`,`leave`.`decWeight` AS `decWeight`,`leave`.`mPrice` AS `mPrice`,`leave`.`milkDays` AS `milkDays`,`leave`.`DaysAge` AS `DaysAge` from (((((`events` `evtleave` join `leave` on(`evtleave`.`intEvtId` = `leave`.`intEvtId` and `evtleave`.`intPastureId` = `leave`.`intPastureId`)) left join `employee` on(`evtleave`.`intPersoner` = `employee`.`intEmployeeId` and `evtleave`.`intPastureId` = `employee`.`intPastureId`)) left join `classlist` `c1` on(`leave`.`intLeaveClass` = `c1`.`intClassListId` and `leave`.`intPastureId` = `c1`.`intPastureId`)) left join `classlist` `c2` on(`leave`.`intReason` = `c2`.`intClassListId` and `leave`.`intPastureId` = `c2`.`intPastureId`)) left join `custom` on(`leave`.`varGoWhere` = `custom`.`intCustomId` and `leave`.`intPastureId` = `custom`.`intPastureId`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `evtleave`.`intPastureId` AS `intPastureId`,`evtleave`.`intEvtId` AS `intEvtId`,`evtleave`.`intCowId` AS `evtCowId`,`evtleave`.`dateEvtDate` AS `evtleaveDate`,`evtleave`.`varNotes` AS `evtleaveNotes`,`heatwatch`.`employee`.`varEmployeeName` AS `leavePersoner`,`c1`.`varName` AS `intLeaveClass`,`c2`.`varName` AS `intReason`,`heatwatch`.`custom`.`varCustomName` AS `varCustomName`,`heatwatch`.`leave`.`decWeight` AS `decWeight`,`heatwatch`.`leave`.`mPrice` AS `mPrice`,`heatwatch`.`leave`.`milkDays` AS `milkDays`,`heatwatch`.`leave`.`DaysAge` AS `DaysAge` from (((((`heatwatch`.`events` `evtleave` join `heatwatch`.`leave` on(((`evtleave`.`intEvtId` = `heatwatch`.`leave`.`intEvtId`) and (`evtleave`.`intPastureId` = `heatwatch`.`leave`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtleave`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtleave`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`)))) left join `heatwatch`.`classlist` `c1` on(((`heatwatch`.`leave`.`intLeaveClass` = `c1`.`intClassListId`) and (`heatwatch`.`leave`.`intPastureId` = `c1`.`intPastureId`)))) left join `heatwatch`.`classlist` `c2` on(((`heatwatch`.`leave`.`intReason` = `c2`.`intClassListId`) and (`heatwatch`.`leave`.`intPastureId` = `c2`.`intPastureId`)))) left join `heatwatch`.`custom` on(((`heatwatch`.`leave`.`varGoWhere` = `heatwatch`.`custom`.`intCustomId`) and (`heatwatch`.`leave`.`intPastureId` = `heatwatch`.`custom`.`intPastureId`))))