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:39
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`