| 123456789101112131415 |
- TYPE=VIEW
- query=select `evtfd`.`intPastureId` AS `intPastureId`,`evtfd`.`intEvtId` AS `intEvtId`,`evtfd`.`intCowId` AS `evtCowId`,`evtfd`.`dateEvtDate` AS `evtfdDate`,(case when (`heatwatch`.`footdisease`.`IsRepaired` = 0) then \'否\' else \'是\' end) AS `fdIsRepaired`,(case when (`heatwatch`.`footdisease`.`IsFootDisease` = 0) then \'否\' else \'是\' end) AS `fdIsFootDisease`,`fdemployee`.`varEmployeeName` AS `fdPersoner`,`evtfd`.`varNotes` AS `varfdNotes`,`heatwatch`.`footdiseasecure`.`CureDate` AS `fdcCureDate`,`heatwatch`.`footdiseasecure`.`footCount` AS `fdcCount`,`heatwatch`.`footdiseasecure`.`IntervalDays` AS `fdcIntervalDays`,`fdcemployee`.`varEmployeeName` AS `fdcPersoner`,`evtfdc`.`varNotes` AS `varfdcNotes` from (((((`heatwatch`.`events` `evtfd` join `heatwatch`.`footdisease` on(((`heatwatch`.`footdisease`.`intEvtId` = `evtfd`.`intEvtId`) and (`heatwatch`.`footdisease`.`intPastureId` = `evtfd`.`intPastureId`)))) left join `heatwatch`.`employee` `fdemployee` on(((`evtfd`.`intPersoner` = `fdemployee`.`intEmployeeId`) and (`evtfd`.`intPastureId` = `fdemployee`.`intPastureId`)))) left join `heatwatch`.`footdiseasecure` on(((`heatwatch`.`footdisease`.`intFoofDiseaseId` = `heatwatch`.`footdiseasecure`.`intFoofDiseaseId`) and (`heatwatch`.`footdisease`.`intPastureId` = `heatwatch`.`footdiseasecure`.`intPastureId`)))) left join `heatwatch`.`events` `evtfdc` on(((`heatwatch`.`footdiseasecure`.`intEvtId` = `evtfdc`.`intEvtId`) and (`heatwatch`.`footdiseasecure`.`intPastureId` = `evtfdc`.`intPastureId`)))) left join `heatwatch`.`employee` `fdcemployee` on(((`evtfdc`.`intPersoner` = `fdcemployee`.`intEmployeeId`) and (`evtfdc`.`intPastureId` = `fdcemployee`.`intPastureId`))))
- md5=d3acb526a66c895589596bc64b08dedf
- 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 `evtfd`.`intPastureId` AS `intPastureId`,`evtfd`.`intEvtId` AS `intEvtId`,`evtfd`.`intCowId` AS `evtCowId`,`evtfd`.`dateEvtDate` AS `evtfdDate`,case when `footdisease`.`IsRepaired` = 0 then \'否\' else \'是\' end AS `fdIsRepaired`,case when `footdisease`.`IsFootDisease` = 0 then \'否\' else \'是\' end AS `fdIsFootDisease`,`fdemployee`.`varEmployeeName` AS `fdPersoner`,`evtfd`.`varNotes` AS `varfdNotes`,`footdiseasecure`.`CureDate` AS `fdcCureDate`,`footdiseasecure`.`footCount` AS `fdcCount`,`footdiseasecure`.`IntervalDays` AS `fdcIntervalDays`,`fdcemployee`.`varEmployeeName` AS `fdcPersoner`,`evtfdc`.`varNotes` AS `varfdcNotes` from (((((`events` `evtfd` join `footdisease` on(`footdisease`.`intEvtId` = `evtfd`.`intEvtId` and `footdisease`.`intPastureId` = `evtfd`.`intPastureId`)) left join `employee` `fdemployee` on(`evtfd`.`intPersoner` = `fdemployee`.`intEmployeeId` and `evtfd`.`intPastureId` = `fdemployee`.`intPastureId`)) left join `footdiseasecure` on(`footdisease`.`intFoofDiseaseId` = `footdiseasecure`.`intFoofDiseaseId` and `footdisease`.`intPastureId` = `footdiseasecure`.`intPastureId`)) left join `events` `evtfdc` on(`footdiseasecure`.`intEvtId` = `evtfdc`.`intEvtId` and `footdiseasecure`.`intPastureId` = `evtfdc`.`intPastureId`)) left join `employee` `fdcemployee` on(`evtfdc`.`intPersoner` = `fdcemployee`.`intEmployeeId` and `evtfdc`.`intPastureId` = `fdcemployee`.`intPastureId`))
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `evtfd`.`intPastureId` AS `intPastureId`,`evtfd`.`intEvtId` AS `intEvtId`,`evtfd`.`intCowId` AS `evtCowId`,`evtfd`.`dateEvtDate` AS `evtfdDate`,(case when (`heatwatch`.`footdisease`.`IsRepaired` = 0) then \'否\' else \'是\' end) AS `fdIsRepaired`,(case when (`heatwatch`.`footdisease`.`IsFootDisease` = 0) then \'否\' else \'是\' end) AS `fdIsFootDisease`,`fdemployee`.`varEmployeeName` AS `fdPersoner`,`evtfd`.`varNotes` AS `varfdNotes`,`heatwatch`.`footdiseasecure`.`CureDate` AS `fdcCureDate`,`heatwatch`.`footdiseasecure`.`footCount` AS `fdcCount`,`heatwatch`.`footdiseasecure`.`IntervalDays` AS `fdcIntervalDays`,`fdcemployee`.`varEmployeeName` AS `fdcPersoner`,`evtfdc`.`varNotes` AS `varfdcNotes` from (((((`heatwatch`.`events` `evtfd` join `heatwatch`.`footdisease` on(((`heatwatch`.`footdisease`.`intEvtId` = `evtfd`.`intEvtId`) and (`heatwatch`.`footdisease`.`intPastureId` = `evtfd`.`intPastureId`)))) left join `heatwatch`.`employee` `fdemployee` on(((`evtfd`.`intPersoner` = `fdemployee`.`intEmployeeId`) and (`evtfd`.`intPastureId` = `fdemployee`.`intPastureId`)))) left join `heatwatch`.`footdiseasecure` on(((`heatwatch`.`footdisease`.`intFoofDiseaseId` = `heatwatch`.`footdiseasecure`.`intFoofDiseaseId`) and (`heatwatch`.`footdisease`.`intPastureId` = `heatwatch`.`footdiseasecure`.`intPastureId`)))) left join `heatwatch`.`events` `evtfdc` on(((`heatwatch`.`footdiseasecure`.`intEvtId` = `evtfdc`.`intEvtId`) and (`heatwatch`.`footdiseasecure`.`intPastureId` = `evtfdc`.`intPastureId`)))) left join `heatwatch`.`employee` `fdcemployee` on(((`evtfdc`.`intPersoner` = `fdcemployee`.`intEmployeeId`) and (`evtfdc`.`intPastureId` = `fdcemployee`.`intPastureId`))))
|
