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`
       ,@rownum := @rownum + 1 AS rank


    from `mydb`.`company`
      join `mydb`.`donation`
      on `mydb`.`company`.`id` = `mydb`.`donation`.`companyid`
      join      (SELECT @rownum := 0 order by @rownum ) r
where       `mydb`.`company`.`id`=18

     group by `mydb`.`company`.`id`,`mydb`.`donation`.`date`
         --  HAVING `MAXDATE` = max(`mydb`.`donation`.`date`)
          order by rank desc