CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`museum-three-thirty-eight.mit.edu` SQL SECURITY DEFINER VIEW `v_asb_samples` ASselect `asb_samples`.`sample_id` AS `sample_id`, `asb_samples`.`job_id` AS `job_id`, `asb_samples`.`sample_number` AS `sample_number`, `asb_samples`.`sample_by` AS `sample_by`, `asb_samples`.`sample_date` AS `sample_date`, `asb_samples`.`sample_location_building_number` AS `sample_location_building_number`, `asb_samples`.`sample_location_room_number` AS `sample_location_room_number`, `asb_samples`.`sample_type_id` AS `sample_type_id`, `asb_samples`.`sample_matertial_type_id` AS `sample_matertial_type_id`, `asb_samples`.`sample_color_id` AS `sample_color_id`, `asb_samples`.`sample_texture_id` AS `sample_texture_id`, `asb_samples`.`sample_friability_id` AS `sample_friability_id`, `asb_samples`.`sample_asbestos_assumed` AS `sample_asbestos_assumed`, `asb_samples`.`sample_analysis_lab_id` AS `sample_analysis_lab_id`, `asb_samples`.`sample_microscope_id` AS `sample_microscope_id`, `asb_samples`.`sample_analysis_by` AS `sample_analysis_by`, `asb_samples`.`sample_analysis_date` AS `sample_analysis_date`, `asb_samples`.`sample_comments` AS `sample_comments`, `asb_samples`.`sample_self_percentage` AS `sample_self_percentage`, `asb_samples`.`sample_magnification` AS `sample_magnification`, max(`asb_sample_composition`.`asbestos_material`) AS `asbestos_material_total`, `asb_samples`.`date_created` AS `date_created`from `asb_samples`left join `asb_analyses` on `asb_analyses`.`sample_id` = `asb_samples`.`sample_id`left join `asb_sample_composition` on `asb_sample_composition`.`composition_id` = `asb_analyses`.`composition_id`group by `asb_samples`.`sample_id`,`asb_samples`.`job_id`,`asb_samples`.`sample_number`,`asb_samples`.`sample_by`,`asb_samples`.`sample_date`,`asb_samples`.`sample_location_building_number`,`asb_samples`.`sample_location_room_number`,`asb_samples`.`sample_type_id`,`asb_samples`.`sample_matertial_type_id`,`asb_samples`.`sample_color_id`,`asb_samples`.`sample_texture_id`,`asb_samples`.`sample_friability_id`,`asb_samples`.`sample_asbestos_assumed`,`asb_samples`.`sample_analysis_lab_id`,`asb_samples`.`sample_microscope_id`,`asb_samples`.`sample_analysis_by`,`asb_samples`.`sample_analysis_date`,`asb_samples`.`sample_comments`,`asb_samples`.`sample_self_percentage`,`asb_samples`.`sample_magnification`,`asb_samples`.`date_created`