CREATE VIEW `yeasts_short` AS select `yeasts`.`id` AS `id`,`yeasts`.`name` AS `name`,`yeasts`.`laboratory` AS `laboratory`,`yeasts`.`category` AS `category`,`yeasts`.`temperature` AS `temperature`,`yeasts`.`attenuation` AS `attenuation`,`yeasts`.`shortdesc` AS `description` from `yeasts` where `yeasts`.`checked` = 1