| 123456789101112131415 |
- 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`))))
|
