SELECT DISTINCT `Condition` FROM Machine_Archive; SELECT * FROM machines WHERE id IN(292, 100, 99, 684, 669); select COUNT(SerialNumber) from Machine_Archive; #WHERE org_id_ma = 19 AND school_year = 19; SELECT id FROM FYER_Group WHERE `FyerOrg_id` = 19 AND FyerFinal = 'Final'; SELECT * FROM floorplans WHERE id IN(1125, 437, 434); SELECT * FROM buildings WHERE id IN(74, 76, 71); SELECT * FROM `Y2019_floorplan_machines` WHERE serial_number IN('A32R012001506', 'A32R012009424', 'A5AY011013876', 'A5AY011013899'); SELECT * FROM tblWhatIf Where save_name_id = 1354;