| 123456789101112131415 |
- TYPE=VIEW
- query=select `heatwatch`.`milk`.`intPastureId` AS `intPastureId`,`heatwatch`.`milk`.`milkDate` AS `milkDate`,sum(if((`heatwatch`.`milk`.`intClass` = 0),`heatwatch`.`milk`.`decWeight`,0)) AS `xh_wt`,sum(ifnull(`heatwatch`.`milk`.`decWeight`,0)) AS `day_milk` from `heatwatch`.`milk` group by `heatwatch`.`milk`.`intPastureId`,`heatwatch`.`milk`.`milkDate`
- md5=c89fe08e3325c55aeffd3bf151402ef9
- updatable=0
- algorithm=0
- definer_user=roo
- definer_host=%
- suid=1
- with_check_option=0
- timestamp=2022-12-14 10:07:38
- create-version=1
- source=select `milk`.`intPastureId` AS `intPastureId`,`milk`.`milkDate` AS `milkDate`,sum(if(`milk`.`intClass` = 0,`milk`.`decWeight`,0)) AS `xh_wt`,sum(ifnull(`milk`.`decWeight`,0)) AS `day_milk` from `milk` group by `milk`.`intPastureId`,`milk`.`milkDate`
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `heatwatch`.`milk`.`intPastureId` AS `intPastureId`,`heatwatch`.`milk`.`milkDate` AS `milkDate`,sum(if((`heatwatch`.`milk`.`intClass` = 0),`heatwatch`.`milk`.`decWeight`,0)) AS `xh_wt`,sum(ifnull(`heatwatch`.`milk`.`decWeight`,0)) AS `day_milk` from `heatwatch`.`milk` group by `heatwatch`.`milk`.`intPastureId`,`heatwatch`.`milk`.`milkDate`
|
