| 123456789101112131415 |
- TYPE=VIEW
- query=select `evtweight`.`intPastureId` AS `intPastureId`,`evtweight`.`intEvtId` AS `intEvtId`,`evtweight`.`intCowId` AS `evtCowId`,`evtweight`.`dateEvtDate` AS `evtweightDate`,`heatwatch`.`weighttarget`.`varDiscribe` AS `intWeightClass`,`heatwatch`.`weight`.`decHigh` AS `decHigh`,`heatwatch`.`employee`.`varEmployeeName` AS `weightPersoner`,`evtweight`.`varNotes` AS `weightNotes`,`heatwatch`.`weight`.`decCir` AS `decCir`,`heatwatch`.`weight`.`decLength` AS `decLength`,`heatwatch`.`weight`.`decWeight` AS `czdecWeight`,`heatwatch`.`weight`.`decInferWeight` AS `decInferWeight` from (((`heatwatch`.`events` `evtweight` join `heatwatch`.`weight` on(((`heatwatch`.`weight`.`intEvtId` = `evtweight`.`intEvtId`) and (`heatwatch`.`weight`.`intPastureId` = `evtweight`.`intPastureId`)))) left join `heatwatch`.`weighttarget` on(((`heatwatch`.`weight`.`intWeightClass` = `heatwatch`.`weighttarget`.`intId`) and (`heatwatch`.`weight`.`intPastureId` = `heatwatch`.`weighttarget`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtweight`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtweight`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))
- md5=3eec77fe57ef8f863e9f0fbbec41fa5b
- 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 `evtweight`.`intPastureId` AS `intPastureId`,`evtweight`.`intEvtId` AS `intEvtId`,`evtweight`.`intCowId` AS `evtCowId`,`evtweight`.`dateEvtDate` AS `evtweightDate`,`weighttarget`.`varDiscribe` AS `intWeightClass`,`weight`.`decHigh` AS `decHigh`,`employee`.`varEmployeeName` AS `weightPersoner`,`evtweight`.`varNotes` AS `weightNotes`,`weight`.`decCir` AS `decCir`,`weight`.`decLength` AS `decLength`,`weight`.`decWeight` AS `czdecWeight`,`weight`.`decInferWeight` AS `decInferWeight` from (((`events` `evtweight` join `weight` on(`weight`.`intEvtId` = `evtweight`.`intEvtId` and `weight`.`intPastureId` = `evtweight`.`intPastureId`)) left join `weighttarget` on(`weight`.`intWeightClass` = `weighttarget`.`intId` and `weight`.`intPastureId` = `weighttarget`.`intPastureId`)) left join `employee` on(`evtweight`.`intPersoner` = `employee`.`intEmployeeId` and `evtweight`.`intPastureId` = `employee`.`intPastureId`))
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `evtweight`.`intPastureId` AS `intPastureId`,`evtweight`.`intEvtId` AS `intEvtId`,`evtweight`.`intCowId` AS `evtCowId`,`evtweight`.`dateEvtDate` AS `evtweightDate`,`heatwatch`.`weighttarget`.`varDiscribe` AS `intWeightClass`,`heatwatch`.`weight`.`decHigh` AS `decHigh`,`heatwatch`.`employee`.`varEmployeeName` AS `weightPersoner`,`evtweight`.`varNotes` AS `weightNotes`,`heatwatch`.`weight`.`decCir` AS `decCir`,`heatwatch`.`weight`.`decLength` AS `decLength`,`heatwatch`.`weight`.`decWeight` AS `czdecWeight`,`heatwatch`.`weight`.`decInferWeight` AS `decInferWeight` from (((`heatwatch`.`events` `evtweight` join `heatwatch`.`weight` on(((`heatwatch`.`weight`.`intEvtId` = `evtweight`.`intEvtId`) and (`heatwatch`.`weight`.`intPastureId` = `evtweight`.`intPastureId`)))) left join `heatwatch`.`weighttarget` on(((`heatwatch`.`weight`.`intWeightClass` = `heatwatch`.`weighttarget`.`intId`) and (`heatwatch`.`weight`.`intPastureId` = `heatwatch`.`weighttarget`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtweight`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtweight`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))
|
