select * from `Y2019_machine_status` as `ms` inner join (select max(created_date) as dt, serial_number from `Y2019_machine_status` group by `serial_number`) as `serNumDate` on `ms`.`serial_number` = `serNumDate`.`serial_number` and `ms`.`created_date` = `serNumDate`.`dt` where `ms`.`serial_number` in (select `serial_number` from `machine_archive` where `org_id` = ? and `school_year` = ?)