To verify contracted machines
select * from y2019_floorplan_machines fpm
INNER JOIN y2019_floorplans fp ON fp.fp_id = fpm.floorplans_id
INNER JOIN y2019_buildings bldgs ON bldgs.bldg_id = fp.buildings_id
WHERE bldgs.organizations_id = 1781
AND fpm.proposed_serial_number is not null;

contract devices reporting
This query returns 23 results (same as StarDoc)
SELECT MAX(created_date), serial_number
FROM y2019_meters
WHERE serial_number IN(

select proposed_serial_number from y2019_floorplan_machines fpm
INNER JOIN y2019_floorplans fp ON fp.fp_id = fpm.floorplans_id
INNER JOIN y2019_buildings bldgs ON bldgs.bldg_id = fp.buildings_id
WHERE bldgs.organizations_id = 1781
AND fpm.proposed_serial_number is not null)
AND created_date > '2019-06-15 00:00:00'
GROUP BY serial_number
ORDER BY serial_number;