TYPE=VIEW
query=select `heatwatch`.`milksale`.`intPastureId` AS `intPastureId`,`heatwatch`.`milksale`.`dateOddDate` AS `dateOddDate`,sum(`heatwatch`.`milksale`.`decWeight`) AS `sale_wt` from `heatwatch`.`milksale` group by `heatwatch`.`milksale`.`intPastureId`,`heatwatch`.`milksale`.`dateOddDate`
md5=ab6b337d267c92bcebde97b856d44014
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 `milksale`.`intPastureId` AS `intPastureId`,`milksale`.`dateOddDate` AS `dateOddDate`,sum(`milksale`.`decWeight`) AS `sale_wt` from `milksale` group by `milksale`.`intPastureId`,`milksale`.`dateOddDate`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `heatwatch`.`milksale`.`intPastureId` AS `intPastureId`,`heatwatch`.`milksale`.`dateOddDate` AS `dateOddDate`,sum(`heatwatch`.`milksale`.`decWeight`) AS `sale_wt` from `heatwatch`.`milksale` group by `heatwatch`.`milksale`.`intPastureId`,`heatwatch`.`milksale`.`dateOddDate`