/*SELECT * FROM billing_data_archive WHERE org_id_ma = 96 AND school_year = 21
AND billing_type = "Client"
AND billing_cycle != 10;*/

SELECT * #mtp.type_name, cd.building_id_ma, SUM(cd.`End` - cd.`Begin`) fy_blk_vol, cd.SerialNumber
			FROM  current_devices cd
			INNER JOIN machines mach ON mach.id = cd.model_id
			INNER JOIN machine_types mtp ON mtp.id = mach.model_type
            WHERE SerialNumber IN('CFDG61928',
'CFDG61930',
'CFDG61934',
'CHEG18488',
'CIAG15904',
'CIAG15905',
'CIAG15908',
'CIAG15910',
'CIAG16050',
'CICG17086',
'CICG17106',
'CICG17114',
'CICG17115',
'CIFG20420');

/*SELECT serial_number, org_id_ma, projected_volume_black, projected_volume_color, billing_cycle, date_created, billing_type 
FROM  billing_data_archive
			
 WHERE serial_number IN('CFDG61928',
'CFDG61930',
'CFDG61934',
'CHEG18488',
'CIAG15904',
'CIAG15905',
'CIAG15908',
'CIAG15910',
'CIAG16050',
'CICG17086',
'CICG17106',
'CICG17114',
'CICG17115',
'CIFG20420')
AND school_year = 21
AND billing_type = "Client"
#AND billing_cycle != 10
ORDER By serial_number;*/

SELECT SerialNumber, org_id_ma FROM current_devices WHERE SerialNumber IN(SELECT SerialNumber from current_devices where org_id_ma = 96);

/*SELECT cda.building_name,          
       
       SUM(cda.fy_bk_vol) fy_bk_vol,
       SUM(bda.billed_projected_volume_black) bpv_blk,
       bda.cpc_black,
       SUM(bda.billed_projected_volume_black * cpc_black) pb_blk_cost,
       SUM(cda.fy_col_vol) fy_col_vol,
       SUM(bda.billed_projected_volume_color) bpv_col,
       bda.cpc_color,
       SUM(bda.billed_projected_volume_color * cpc_color) pb_col_cost,
       bda.vendor_cpc_black,
       bda.vendor_cpc_color,
       cda.`Begin` begin_meter_black,
       cda.`End` end_meter_black,
       cda.`MstrBegin` begin_meter_color,
       cda.`MstrEnd` end_meter_color
       
       
      FROM billing_data_archive bda 
      
      INNER JOIN (SELECT bldg.building_name, cd.org_id_ma, mach.Make, mach.model, cd.`Begin`, cd.`End`,
                  	cd.`MstrBegin`, cd.`MstrEnd`, SUM(cd.`End` - cd.`Begin`) fy_bk_vol,
                	SUM(cd.`MstrEnd` - cd.`MstrBegin`) fy_col_vol, cd.SerialNumber,
                	UPPER(cd.Traded) traded, UPPER(cd.Moved) moved, UPPER(`Meter Reset`) meter_reset,
                	cd.`EDate` end_dt, cd.`Storage` in_storage
                
    				FROM  current_devices cd
    				INNER JOIN machines mach ON mach.id = cd.model_id 
    				INNER JOIN buildings bldg ON bldg.id = cd.building_id_ma
                 	GROUP BY cd.SerialNumber, cd.`EDate`) cda ON cda.SerialNumber = bda.serial_number AND cda.org_id_ma = bda.org_id_ma
        
      WHERE bda.org_id_ma = 96 AND bda.billing_cycle != 10
      AND bda.school_year = 21 AND bda.billing_type = "Client"  
      GROUP BY cda.org_id_ma ORDER BY cda.building_name, bda.room_name;*/