TYPE=VIEW
query=select `evtquarantine`.`intPastureId` AS `intPastureId`,`evtquarantine`.`intEvtId` AS `intEvtId`,`evtquarantine`.`intCowId` AS `evtCowId`,`evtquarantine`.`dateEvtDate` AS `evtquarantineDate`,`heatwatch`.`quarantine`.`intClass` AS `qintClass`,(case when (`heatwatch`.`quarantine`.`bitResult` = 0) then \'阴性\' else \'阳性\' end) AS `qbitResult`,`heatwatch`.`classlist`.`varName` AS `qvarName`,`heatwatch`.`quarantine`.`varBatch` AS `varBatch`,`heatwatch`.`employee`.`varEmployeeName` AS `qPersoner`,`evtquarantine`.`varNotes` AS `varqNotes` from (((`heatwatch`.`events` `evtquarantine` join `heatwatch`.`quarantine` on(((`heatwatch`.`quarantine`.`intEvtId` = `evtquarantine`.`intEvtId`) and (`heatwatch`.`quarantine`.`intPastureId` = `evtquarantine`.`intPastureId`)))) left join `heatwatch`.`classlist` on(((`heatwatch`.`quarantine`.`intBacterin` = `heatwatch`.`classlist`.`intClassListId`) and (`heatwatch`.`quarantine`.`intPastureId` = `heatwatch`.`classlist`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtquarantine`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtquarantine`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))
md5=4526904be057c4512c4dd1d41030c0c4
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 `evtquarantine`.`intPastureId` AS `intPastureId`,`evtquarantine`.`intEvtId` AS `intEvtId`,`evtquarantine`.`intCowId` AS `evtCowId`,`evtquarantine`.`dateEvtDate` AS `evtquarantineDate`,`quarantine`.`intClass` AS `qintClass`,case when `quarantine`.`bitResult` = 0 then \'阴性\' else \'阳性\' end AS `qbitResult`,`classlist`.`varName` AS `qvarName`,`quarantine`.`varBatch` AS `varBatch`,`employee`.`varEmployeeName` AS `qPersoner`,`evtquarantine`.`varNotes` AS `varqNotes` from (((`events` `evtquarantine` join `quarantine` on(`quarantine`.`intEvtId` = `evtquarantine`.`intEvtId` and `quarantine`.`intPastureId` = `evtquarantine`.`intPastureId`)) left join `classlist` on(`quarantine`.`intBacterin` = `classlist`.`intClassListId` and `quarantine`.`intPastureId` = `classlist`.`intPastureId`)) left join `employee` on(`evtquarantine`.`intPersoner` = `employee`.`intEmployeeId` and `evtquarantine`.`intPastureId` = `employee`.`intPastureId`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `evtquarantine`.`intPastureId` AS `intPastureId`,`evtquarantine`.`intEvtId` AS `intEvtId`,`evtquarantine`.`intCowId` AS `evtCowId`,`evtquarantine`.`dateEvtDate` AS `evtquarantineDate`,`heatwatch`.`quarantine`.`intClass` AS `qintClass`,(case when (`heatwatch`.`quarantine`.`bitResult` = 0) then \'阴性\' else \'阳性\' end) AS `qbitResult`,`heatwatch`.`classlist`.`varName` AS `qvarName`,`heatwatch`.`quarantine`.`varBatch` AS `varBatch`,`heatwatch`.`employee`.`varEmployeeName` AS `qPersoner`,`evtquarantine`.`varNotes` AS `varqNotes` from (((`heatwatch`.`events` `evtquarantine` join `heatwatch`.`quarantine` on(((`heatwatch`.`quarantine`.`intEvtId` = `evtquarantine`.`intEvtId`) and (`heatwatch`.`quarantine`.`intPastureId` = `evtquarantine`.`intPastureId`)))) left join `heatwatch`.`classlist` on(((`heatwatch`.`quarantine`.`intBacterin` = `heatwatch`.`classlist`.`intClassListId`) and (`heatwatch`.`quarantine`.`intPastureId` = `heatwatch`.`classlist`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtquarantine`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtquarantine`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))