TYPE=VIEW
query=select `evtptest`.`intPastureId` AS `intPastureId`,`evtptest`.`intEvtId` AS `intEvtId`,`evtptest`.`intCowId` AS `evtCowId`,`evtptest`.`dateEvtDate` AS `evtptestDate`,`heatwatch`.`producetest`.`intProduceDay` AS `intProduceDay`,`heatwatch`.`producetest`.`intDairySpeed` AS `intDairySpeed`,`heatwatch`.`producetest`.`decFat` AS `decFat`,`heatwatch`.`producetest`.`decPro` AS `decPro`,`heatwatch`.`producetest`.`intBodyCell` AS `intBodyCell`,`heatwatch`.`producetest`.`decP305P` AS `decP305P`,`heatwatch`.`producetest`.`decP305F` AS `decP305F`,`heatwatch`.`producetest`.`decP305M` AS `decP305M`,`heatwatch`.`producetest`.`gaugeProduce` AS `gaugeProduce`,`heatwatch`.`producetest`.`fatProRatio` AS `fatProRatio`,`heatwatch`.`producetest`.`intCurFetalProduce` AS `intCurFetalProduce`,`heatwatch`.`producetest`.`fatProRatio305` AS `fatProRatio305`,`evtptest`.`varNotes` AS `varptestNotes`,`heatwatch`.`employee`.`varEmployeeName` AS `ptestPersoner` from ((`heatwatch`.`events` `evtptest` join `heatwatch`.`producetest` on(((`heatwatch`.`producetest`.`intEvtId` = `evtptest`.`intEvtId`) and (`heatwatch`.`producetest`.`intPastureId` = `evtptest`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtptest`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtptest`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))
md5=0c65a7fe9477b3bfe0c99354f7bb026d
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 `evtptest`.`intPastureId` AS `intPastureId`,`evtptest`.`intEvtId` AS `intEvtId`,`evtptest`.`intCowId` AS `evtCowId`,`evtptest`.`dateEvtDate` AS `evtptestDate`,`producetest`.`intProduceDay` AS `intProduceDay`,`producetest`.`intDairySpeed` AS `intDairySpeed`,`producetest`.`decFat` AS `decFat`,`producetest`.`decPro` AS `decPro`,`producetest`.`intBodyCell` AS `intBodyCell`,`producetest`.`decP305P` AS `decP305P`,`producetest`.`decP305F` AS `decP305F`,`producetest`.`decP305M` AS `decP305M`,`producetest`.`gaugeProduce` AS `gaugeProduce`,`producetest`.`fatProRatio` AS `fatProRatio`,`producetest`.`intCurFetalProduce` AS `intCurFetalProduce`,`producetest`.`fatProRatio305` AS `fatProRatio305`,`evtptest`.`varNotes` AS `varptestNotes`,`employee`.`varEmployeeName` AS `ptestPersoner` from ((`events` `evtptest` join `producetest` on(`producetest`.`intEvtId` = `evtptest`.`intEvtId` and `producetest`.`intPastureId` = `evtptest`.`intPastureId`)) left join `employee` on(`evtptest`.`intPersoner` = `employee`.`intEmployeeId` and `evtptest`.`intPastureId` = `employee`.`intPastureId`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `evtptest`.`intPastureId` AS `intPastureId`,`evtptest`.`intEvtId` AS `intEvtId`,`evtptest`.`intCowId` AS `evtCowId`,`evtptest`.`dateEvtDate` AS `evtptestDate`,`heatwatch`.`producetest`.`intProduceDay` AS `intProduceDay`,`heatwatch`.`producetest`.`intDairySpeed` AS `intDairySpeed`,`heatwatch`.`producetest`.`decFat` AS `decFat`,`heatwatch`.`producetest`.`decPro` AS `decPro`,`heatwatch`.`producetest`.`intBodyCell` AS `intBodyCell`,`heatwatch`.`producetest`.`decP305P` AS `decP305P`,`heatwatch`.`producetest`.`decP305F` AS `decP305F`,`heatwatch`.`producetest`.`decP305M` AS `decP305M`,`heatwatch`.`producetest`.`gaugeProduce` AS `gaugeProduce`,`heatwatch`.`producetest`.`fatProRatio` AS `fatProRatio`,`heatwatch`.`producetest`.`intCurFetalProduce` AS `intCurFetalProduce`,`heatwatch`.`producetest`.`fatProRatio305` AS `fatProRatio305`,`evtptest`.`varNotes` AS `varptestNotes`,`heatwatch`.`employee`.`varEmployeeName` AS `ptestPersoner` from ((`heatwatch`.`events` `evtptest` join `heatwatch`.`producetest` on(((`heatwatch`.`producetest`.`intEvtId` = `evtptest`.`intEvtId`) and (`heatwatch`.`producetest`.`intPastureId` = `evtptest`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtptest`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtptest`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))