CREATE VIEW `yeasts_full` AS select `yeasts`.`id` AS `id`,`yeasts`.`checked` AS `checked`,`yeasts`.`name` AS `name`,`yeasts`.`category` AS `category`,`yeasts`.`sub_category` AS `sub_category`,`yeasts`.`laboratory` AS `laboratory`,`yeasts`.`product_id` AS `product_id`,`yeasts`.`origin` AS `origin`,`yeasts`.`link` AS `link`,`yeasts`.`shortdesc` AS `shortdesc`,`yeasts`.`temperature_min` AS `temperature_min`,`yeasts`.`temperature_max` AS `temperature_max`,`yeasts`.`temperature` AS `temperature`,`yeasts`.`attenuation_min` AS `attenuation_min`,`yeasts`.`attenuation_max` AS `attenuation_max`,`yeasts`.`attenuation` AS `attenuation`,`yeasts`.`flocculation` AS `flocculation`,`yeasts`.`acohol_tolerance` AS `acohol_tolerance`,(select group_concat(`styles_to_yeasts`.`styles_id` separator ',') from `styles_to_yeasts` where `styles_to_yeasts`.`yeasts_id` = `yeasts`.`id`) AS `use_for_ids`,(select group_concat(`styles`.`name` order by `styles`.`name` ASC separator ', ') from (`styles` join `styles_to_yeasts` on(`styles_to_yeasts`.`styles_id` = `styles`.`id`)) where `styles_to_yeasts`.`yeasts_id` = `yeasts`.`id`) AS `use_for`,(select group_concat(`y2`.`name` separator ', ') from (`yeasts` `y2` join `yeasts_to_yeasts` on(`yeasts_to_yeasts`.`replacements_id` = `y2`.`id`)) where `yeasts_to_yeasts`.`yeasts_id` = `yeasts`.`id`) AS `replacement`,(select group_concat(`yeasts_to_yeasts`.`replacements_id` separator ',') from `yeasts_to_yeasts` where `yeasts_to_yeasts`.`yeasts_id` = `yeasts`.`id`) AS `replacement_ids`,`yeasts`.`notes` AS `notes` from `yeasts`