SELECT DISTINCT id cid, org_name oName
FROM `organization` WHERE `Status` = 'Active Client'
AND org_type_id != 7 ORDER BY org_name;
                
SELECT mac_id, mac_serial_number, mac_date, mac_complaint, `Initials`, mac_remarks
FROM machine_analysis_complaints WHERE mac_id = 7660; #no recs
                
SELECT `SerialNumber` serNum, id sid FROM current_devices WHERE org_id_ma = 18 ORDER BY `SerialNumber`;

SELECT mc.org_id_ma, org.org_name, mc.`ID`, mc.building_id_ma, bldgs.building_name,
	mc.dept_id_ma, mc.room_name, mc.vendor_id_ma, (mc.`End` - mc.`Begin`) AS calc_bk,
	mc.`MstrEnd` - mc.`MstrBegin` calc_col, mc.`Storage` mc_storage, mc.`Traded` traded,
	mc.`Moved` moved, mc.`txtReplacedMachine` repl_mach, mc.`Meter Reset` m_reset,
	mc.`Features` mc_features, mc.model_id, mc.`SerialNumber` mc_ser_num, mc.`VendorMachID`
    mc_v_mach_id, mc.`Condition` mc_condition, mc.lease mc_lease
					
FROM current_devices mc
INNER JOIN buildings bldgs ON bldgs.id = mc.building_id_ma
INNER JOIN organization org ON org.id = mc.org_id_ma
WHERE mc.`ID` = 7660;

SELECT id bid, building_name bName FROM buildings WHERE org_id = 18 ORDER BY building_name;

SELECT id deptid, dept_name dName FROM department WHERE org_id = 18 ORDER BY dept_name;

SELECT `ID` mac_id, `SerialNumber` serlNum FROM current_devices
WHERE org_id_ma = 18 ORDER BY `SerialNumber`;

SELECT `Install` inst_dt, `EndContractDate` end_cont_dt, `ContractExpDate` cont_exp_dt,
`EndServiceYear` end_svc_yr FROM current_devices WHERE `ID` = 7660;

SELECT `Anticipated` projBkVol, `CostCopy` curBkCpc, `NewCostCopy` newYrCpc,
	`Black_Vendor_cpc` bkVendCpc, `New_Blk_Ven_cpc` newBkVendCpc, `ProjColorVol` projColVol,
	`Mstrcpc` curColCpc, `NewColorCPC` newColCpc, `Color_Vendor_cpc` colVendCpc,
	`New_Color_Ven_cpc` newColVendCpc, DATE_FORMAT(`BDate`, '%Y-%m-%d') beginDt, `Begin`
    	beginBkMtr, `MstrBegin` beginColMtr, DATE_FORMAT(`EDate`, '%Y-%m-%d') endDt, `End`
        endBkMtr, `MstrEnd` endColMtr
FROM current_devices WHERE `ID` = 7660;

SELECT mc.`ID`, mc.model_id, ms.make, ms.model,
    ms.model_type, mt.type_name, mt.type, mc.lease mc_lease, mc.`Condition` mc_condition
FROM current_devices mc
INNER JOIN machines ms ON ms.id = mc.model_id
INNER JOIN machine_types mt ON mt.id = ms.model_type
WHERE mc.`ID` = 7660;

SELECT DISTINCT make FROM machines WHERE auto_created = 'N' ORDER BY make;

SELECT DISTINCT id mid, model model_name FROM machines
WHERE make = 'HP' AND auto_created = "N" ORDER BY model_name;