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