CREATE VIEW `updates` AS select (select max(`fermentables`.`timestamp`) from `fermentables` where `fermentables`.`checked` = 1) AS `fermentables`,(select max(`hops`.`timestamp`) from `hops` where `hops`.`checked` = 1) AS `hops`,(select max(`yeasts`.`timestamp`) from `yeasts` where `yeasts`.`checked` = 1) AS `yeasts`,(select max(`adjuncts`.`timestamp`) from `adjuncts` where `adjuncts`.`checked` = 1) AS `adjuncts`,(select max(`aromas`.`timestamp`) from `aromas` where `aromas`.`checked` = 1) AS `aromas`,(select max(`styles`.`timestamp`) from `styles`) AS `styles`,(select max(`hops_analysis`.`timestamp`) from `hops_analysis` where `hops_analysis`.`checked` = 1) AS `hops_analysis`,(select max(`fermentables_analysis`.`timestamp`) from `fermentables_analysis` where `fermentables_analysis`.`checked` = 1) AS `fermentables_analysis`,(select max(`waters_analysis`.`timestamp`) from `waters_analysis` where `waters_analysis`.`checked` = 1) AS `waters_analysis`