CREATE VIEW `fermentables_full` AS select `fermentables`.`id` AS `id`,`fermentables`.`checked` AS `checked`,`fermentables`.`name` AS `name`,`fermentables`.`alias_name` AS `alias_name`,`fermentables`.`category` AS `category`,`fermentables`.`origin` AS `origin`,`fermentables`.`supplier` AS `supplier`,`fermentables`.`max_in_batch` AS `max_in_batch`,`fermentables`.`recommend_mash` AS `recommend_mash`,`fermentables`.`notes` AS `notes`,`fermentables`.`source` AS `source`,`fermentables`.`link` AS `link`,cast(avg(`fermentables_analysis`.`color`) as decimal(4,0)) AS `color`,cast(avg(`fermentables_analysis`.`potential`) as decimal(4,3)) AS `potential`,cast(avg(`fermentables_analysis`.`moisture`) as decimal(4,1)) AS `moisture`,cast(avg(`fermentables_analysis`.`protein`) as decimal(4,1)) AS `protein`,cast(avg(`fermentables_analysis`.`soluble_nitrogen_ratio`) as decimal(4,1)) AS `soluble_nitrogen_ratio`,cast(avg(`fermentables_analysis`.`fine_grind`) as decimal(4,1)) AS `fine_grind`,cast(avg(`fermentables_analysis`.`coarse_grind`) as decimal(4,1)) AS `coarse_grind`,cast(avg(`fermentables_analysis`.`coarse_fine_difference`) as decimal(4,1)) AS `coarse_fine_difference`,cast(avg(`fermentables_analysis`.`diastatic_power`) as decimal(4,1)) AS `diastatic_power`,cast(avg(`fermentables_analysis`.`ibu_gal_per_lb`) as decimal(4,1)) AS `ibu_gal_per_lb`,cast(avg(`fermentables_analysis`.`extract`) as decimal(4,1)) AS `extract`,cast(avg(`fermentables_analysis`.`evg`) as decimal(4,1)) AS `evg` from (`fermentables` left join `fermentables_analysis` on(`fermentables_analysis`.`fermentable` = `fermentables`.`id`)) group by `fermentables`.`name`