CREATE VIEW `fermentables_short` AS select `fermentables`.`id` AS `id`,`fermentables`.`name` AS `name`,`fermentables`.`category` AS `category`,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`.`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`)) where `fermentables`.`checked` = 1 group by `fermentables`.`name`