select last_read.dt, fpm.*
FROM floorplan_machines fpm
LEFT JOIN (SELECT max(mtr.created_date) as dt, mtr.serial_number
           FROM meters mtr
           WHERE `mtr`.`created_date` >= '2023-07-01 00:00:00'
			and `mtr`.`created_date` <= '2023-09-18 00:00:00'
           GROUP BY mtr.serial_number) last_read
ON fpm.proposed_serial_number = last_read.serial_number
WHERE proposed_serial_number IN(SELECT proposed_serial_number
                                FROM floorplan_machines fpm
								INNER JOIN floorplans fp ON fp.fp_id = fpm.floorplans_id
								INNER JOIN buildings bldg ON bldg.bldg_id = fp.buildings_id
                                WHERE bldg.organizations_id = 15)
AND fpm.fyer_groups_id IS NOT NULL
AND (last_read.dt <= '2023-09-02 00:00:00' OR last_read.dt IS NULL);

/*******NOT REPORTING QUERY AS OF 9/18/2023********/
select * from `floorplan_machines` as `fpm`
left join (select max(mtr.created_date) as dt, mtr.serial_number
			from `meters` as `mtr`
			where `mtr`.`created_date` >= '2023-07-01 00:00:00'
			and `mtr`.`created_date` <= '2023-09-18 00:00:00'
			group by `mtr`.`serial_number`) as `lastMeterRead`
on `fpm`.`proposed_serial_number` = `lastMeterRead`.`serial_number`

and `m`.`created_date` = `lastMeterRead`.`dt`

where `fpm`.`proposed_serial_number` in (select `proposed_serial_number`
										from `floorplan_machines` as `fpm`
										inner join `floorplans` as `fp` on `fp`.`fp_id` = `fpm`.`floorplans_id`
										inner join `buildings` as `bldgs` on `bldgs`.`bldg_id` = `fp`.`buildings_id`
										where `bldgs`.`organizations_id` = 15)
and `fpm`.`fyer_groups_id` is not null
and (`lastMeterRead`.`dt` <= '2023-09-02 00:00:00' or `lastMeterRead`.`dt` is null);


/*******NEEDS TONER QUERY AS OF 9/18/2023********/
select * from `floorplan_machines` as `fpm`
inner join `machine_statuses` as `ms` on `ms`.`serial_number` = `fpm`.`proposed_serial_number`
inner join (select max(mstat.created_date) as dt, mstat.serial_number
				from `machine_statuses` as `mstat`
				where `mstat`.`created_date` >= ?
				and `mstat`.`created_date` <= ?
				group by `mstat`.`serial_number`) as `serNumDate`
				on `fpm`.`proposed_serial_number` = `serNumDate`.`serial_number`
where `fpm`.`proposed_serial_number` in (select `proposed_serial_number`
											from `floorplan_machines` as `fpm`
											inner join `floorplans` as `fp`
											on `fp`.`fp_id` = `fpm`.`floorplans_id`
											inner join `buildings` as `bldgs`
											on `bldgs`.`bldg_id` = `fp`.`buildings_id`
											where `bldgs`.`organizations_id` = ?)
and `ms`.`created_date` = ? and `ms`.`toner` = ?



select * from `floorplan_machines` as `fpm`
inner join `machine_statuses` as `ms` on `ms`.`serial_number` = `fpm`.`proposed_serial_number`
inner join (select max(mstat.created_date) as dt, mstat.serial_number
            from `machine_statuses` as `mstat`
            where `mstat`.`created_date` >= '2023-07-01 00:00:00'
            and `mstat`.`created_date` <= '2023-09-18 23:59:59'
            group by `mstat`.`serial_number`) as `serNumDate` on `fpm`.`proposed_serial_number` = `serNumDate`.`serial_number`
where `fpm`.`proposed_serial_number` in (select `proposed_serial_number`
                                         from `floorplan_machines` as `fpm`
                                         inner join `floorplans` as `fp` on `fp`.`fp_id` = `fpm`.`floorplans_id`
                                         inner join `buildings` as `bldgs` on `bldgs`.`bldg_id` = `fp`.`buildings_id`
                                         where `bldgs`.`organizations_id` = 62)
and `ms`.`created_date` = `serNumDate`.dt and `ms`.`toner` = 'Y'