select ProductID , GroupID,PreOrder,0 as LC,(select top 1 TypeID from mss_Types where TypeID in (select typeid from mss_types where [sign]='DESIGNERS') and TypeID in (select TypeID from mss_Index where ProductID=cache_products.ProductID)) AS DesignerID from cache_Products where (publishdate < getdate() or publishdate is null) and 1=1 and exists (select top 1 1 from mss_index where typeid=2 and productid=cache_Products.productid and cache_products.GroupID <> 5433) and exists (select top 1 1 from mss_index where typeid=1390 and productid=cache_Products.productid) and ( ( [Keywords] like '%Wilder%' and [Keywords] like '%Magazine%' ) or productname like '%Wilder Magazine%' or productID in (select distinct ProductID from msS_Index where TypeID in (select TypeID from mss_Types where TypeName like '%Wilder Magazine%' or Remark='Wilder Magazine'))) and GroupID <> 5433 order by PublishDate desc
This issue takes us to Norway’s Svalbard Global Seed Vault and then coasts all the way down to Mexico to check out Xochemilco’s floating garden district with Maureen Gilmer. Renaissance rooftop gardener and Atlantic writer, Annie Novak, shows us how field-to-fork stays alive in the colder months and Portland chef Aaron Woo tell us how he is revolutionizing the vegetarian plate. We wander through the garden with Beginners director Mike Mills' and take a tour of Austin-based musician, Martin Perna's gardens. Before heading inside for the season, we check in with famed horticulturist Yvonne Savio in Los Angeles and two different types of farmers surviving these cold winter months.