TYPE=VIEW
query=select `evtfoot`.`intPastureId` AS `intPastureId`,`evtfoot`.`intEvtId` AS `intEvtId`,`evtfoot`.`intCowId` AS `evtCowId`,`evtfoot`.`dateEvtDate` AS `evtfootDate`,`heatwatch`.`employee`.`varEmployeeName` AS `footPersoner`,`evtfoot`.`varNotes` AS `varfootNotes`,(case when (`heatwatch`.`foot`.`IsRepaired` = 0) then \'否\' else \'是\' end) AS `footIsRepaired`,`heatwatch`.`foot`.`footCount` AS `footCount`,`heatwatch`.`foot`.`IntervalDays` AS `footIntervalDays` from ((`heatwatch`.`events` `evtfoot` join `heatwatch`.`foot` on(((`heatwatch`.`foot`.`intEvtId` = `evtfoot`.`intEvtId`) and (`heatwatch`.`foot`.`intPastureId` = `evtfoot`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtfoot`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtfoot`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))
md5=620e7d4f037e4b90198757287a23e9ef
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 `evtfoot`.`intPastureId` AS `intPastureId`,`evtfoot`.`intEvtId` AS `intEvtId`,`evtfoot`.`intCowId` AS `evtCowId`,`evtfoot`.`dateEvtDate` AS `evtfootDate`,`employee`.`varEmployeeName` AS `footPersoner`,`evtfoot`.`varNotes` AS `varfootNotes`,case when `foot`.`IsRepaired` = 0 then \'否\' else \'是\' end AS `footIsRepaired`,`foot`.`footCount` AS `footCount`,`foot`.`IntervalDays` AS `footIntervalDays` from ((`events` `evtfoot` join `foot` on(`foot`.`intEvtId` = `evtfoot`.`intEvtId` and `foot`.`intPastureId` = `evtfoot`.`intPastureId`)) left join `employee` on(`evtfoot`.`intPersoner` = `employee`.`intEmployeeId` and `evtfoot`.`intPastureId` = `employee`.`intPastureId`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `evtfoot`.`intPastureId` AS `intPastureId`,`evtfoot`.`intEvtId` AS `intEvtId`,`evtfoot`.`intCowId` AS `evtCowId`,`evtfoot`.`dateEvtDate` AS `evtfootDate`,`heatwatch`.`employee`.`varEmployeeName` AS `footPersoner`,`evtfoot`.`varNotes` AS `varfootNotes`,(case when (`heatwatch`.`foot`.`IsRepaired` = 0) then \'否\' else \'是\' end) AS `footIsRepaired`,`heatwatch`.`foot`.`footCount` AS `footCount`,`heatwatch`.`foot`.`IntervalDays` AS `footIntervalDays` from ((`heatwatch`.`events` `evtfoot` join `heatwatch`.`foot` on(((`heatwatch`.`foot`.`intEvtId` = `evtfoot`.`intEvtId`) and (`heatwatch`.`foot`.`intPastureId` = `evtfoot`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtfoot`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtfoot`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))
