select
  `mydb`.`company`.`id`,
  `mydb`.`company`.`name`,
  `mydb`.`company`.`address`,
  `mydb`.`company`.`details`,
  `mydb`.`company`.`company_status`,
  `nested1`.`id`,
  `nested1`.`name`,
  `nested1`.`address`,
  `nested1`.`details`,
  `nested1`.`company_status`,
  `nested1`.`MAXDATE`,
  `nested1`.`donationValue`
from `mydb`.`company`
  left outer join `mydb`.`donation`
  on `mydb`.`company`.`id` = `mydb`.`donation`.`companyid`
  join (
    select
      `mydb`.`company`.`id`,
      `mydb`.`company`.`name`,
      `mydb`.`company`.`address`,
      `mydb`.`company`.`details`,
      `mydb`.`company`.`company_status`,
      max(`mydb`.`donation`.`date`) as `MAXDATE`,
      `mydb`.`donation`.`value` as `donationValue`
    from `mydb`.`company`
      join `mydb`.`donation`
      on `mydb`.`company`.`id` = `mydb`.`donation`.`companyid`
      join `mydb`.`company_process`
      on `mydb`.`company`.`id` = `mydb`.`company_process`.`companyid`
    group by `mydb`.`company`.`id`
  --  order by `mydb`.`donation`.`companyid`,`mydb`.`donation`.`date` desc,`mydb`.`donation`.`value`
  ) as `nested1`
  on `mydb`.`company`.`id` = `nested1`.`id` and `mydb`.`donation`.`date` = `nested1`.`MAXDATE`
where (
  `nested1`.`MAXDATE` >= {ts '2017-01-01 02:00:00.0'}
  and `nested1`.`MAXDATE` <= {ts '2017-12-31 02:00:00.0'}
)
order by `mydb`.`company`.`name`
limit 80