SELECT serial_number, budgeted_blk, cpc_black, budgeted_color, cpc_color,
commencement_date, commencement_black_meter, commencement_color_meter
FROM Y2020_floorplan_machines WHERE serial_number 


SELECT proposed_serial_number, budgeted_black, cpc_black, budgeted_color, cpc_color, commencement_date, commencement_black_meter, commencement_color_meter
FROM y2020_floorplan_machines WHERE proposed_serial_number IN('A79K011017075',
'A79K011024934',
'A79K011024886',
'A8KN011010939',
'AA6R011005213',
'PHB5F56905',
'PHB5D59369',
'PHB5F56903',
'PHB5D59380',
'PHB5D59366',
'PHB5D59372',
'PHB5F56831',
'PHB5707030',
'PHB5F56900',
'PHB5D59364',
'PHB5F56901',
'PHB5D59362',
'PHB5D59367',
'PHB5D59375',
'PHB5D59370',
'PHB5F56904',
'JPCCM8D171',
'VNB3B74407',
'VNB3B74409',
'VNG3M10739')

'460083810DX7N',
'CN442GK05F',
'CN93N7Q5HF06VZ',
'H8Z158046',
'J9Z930337',
'U62674G1N425710',
'U64180E8N115292',
'U64203D8N723380',
'VMBE002770',
'X4DQ218801',
'Y947R800002')
 /**************GOOD*********************/
select * from y2020_meters mtr
where (mtr.created_date, mtr.serial_number) IN(						   
select max(created_date) as dt, serial_number from `y2020_meters`
where `created_date` >= '2019-07-01 00:00:00' and `created_date` <= '2020-06-30 23:59:59' group by `serial_number`)

AND serial_number IN('A79K011017075', 'A79K011024934', 'A79K011024886', 'A8KN011010939', 'AA6R011005213',
'PHB5F56905', 'PHB5D59369', 'PHB5F56903', 'PHB5D59380', 'PHB5D59366', 'PHB5D59372', 'PHB5F56831', 'PHB5707030',
'PHB5F56900', 'PHB5D59364', 'PHB5F56901', 'PHB5D59362', 'PHB5D59367', 'PHB5D59375', 'PHB5D59370', 'PHB5F56904',
'JPCCM8D171', 'VNB3B74407', 'VNB3B74409', 'VNG3M10739');
/**************END GOOD*********************/

select * from y2020_meters
INNER JOIN (select max(created_date) dt, serial_number FROM y2020_meters
WHERE created_date <= '2020-06-30 23:59:59' AND created_date >= '2019-07-01 00:00:00'
AND serial_number IN('A79K011017075', 'A79K011024934', 'A79K011024886', 'A8KN011010939', 'AA6R011005213',
'PHB5F56905', 'PHB5D59369', 'PHB5F56903', 'PHB5D59380', 'PHB5D59366', 'PHB5D59372', 'PHB5F56831', 'PHB5707030',
'PHB5F56900', 'PHB5D59364', 'PHB5F56901', 'PHB5D59362', 'PHB5D59367', 'PHB5D59375', 'PHB5D59370', 'PHB5F56904',
'JPCCM8D171', 'VNB3B74407', 'VNB3B74409', 'VNG3M10739')
GROUP BY serial_number) max_dt ON max_dt.serial_number = mtr.serial_number;


/*$serNumDateMetersMax = DB::table($yearTab . 'meters')
                           ->select(DB::raw('max(created_date) as dt, serial_number'))
                           ->where('created_date', '>=', $startingDateFormat)
                           ->where('created_date', '<=', $endingDateFormat)
                           //->where('black_meter', '!=',  0)
                           ->groupBy('serial_number');*/
						   
						   
select * from y2020_meters mtr
where (mtr.created_date, mtr.serial_number) IN(						   
select max(created_date) as dt, serial_number from `y2020_meters`
where `created_date` >= '2019-07-01 00:00:00' and `created_date` <= '2020-06-30 23:59:59' group by `serial_number`);