SELECT ma.is_color, fp.id, fpm.*, bldg.id FROM floorplan_machines fpm
INNER JOIN floorplans fp ON fp.id = fpm.floorplan_id
INNER JOIN buildings bldg ON bldg.id = fp.building_id
INNER JOIN machines ma ON ma.id = fpm.model_id
WHERE bldg.org_id = 4
ORDER BY fp.id, ma.is_color; #202


SELECT ma.is_color, fp.id fp_id, fpm.x_position, fpm.y_position,
fpm.serial_number, bldg.id bldg_id, fpm.budgeted_blk,
fpm.budgeted_color,  fpm.commencement_date
FROM Y2019_floorplan_machines fpm
INNER JOIN Y2019_floorplans fp ON fp.id = fpm.floorplan_id
INNER JOIN Y2019_buildings bldg ON bldg.id = fp.building_id
INNER JOIN Y2019_machines ma ON ma.id = fpm.model_id
WHERE bldg.org_id = 4
AND fpm.x_position is not null
AND commencement_date is not null
GROUP BY bldg_id, Is_color
ORDER BY fp.id, fpm.serial_number,ma.is_color;


SELECT SUM(fpm.budgeted_blk), SUM(fpm.budgeted_color), bldg.building_name
FROM Y2019_floorplan_machines fpm
INNER JOIN Y2019_floorplans fp ON fp.id = fpm.floorplan_id
INNER JOIN Y2019_buildings bldg ON bldg.id = fp.building_id
INNER JOIN Y2019_machines ma ON ma.id = fpm.model_id
WHERE bldg.org_id = 4
AND fpm.x_position is not null
AND commencement_date is not null
AND bldg.id = 179
#AND ma.is_color = 0

#ORDER BY fp.id, fpm.serial_number,ma.is_color;