select i.*, substring_index(group_concat(distinct pa.country order by rsi.date_added desc),',',-1) as source_country
from inventory_item_manage i
left outer join sheffields_2017.receiving_shipments_item_has_inventory_item hrsi on i.id = hrsi.inventory_item_id
left outer join sheffields_2017.receiving_shipments_item rsi on rsi.id = hrsi.receiving_shipments_item_id
left outer join sheffields_2017.po on rsi.po_id = po.id
left outer join sheffields_2017.po_address pa on pa.po_id = po.id
where i.inventory_id = '863'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 120 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: can be fall sown without stratification.
Magnolia virginiana, commonly known as Sweetbay or Sweetbay Magnolia, is a versatile and attractive tree that is native to the U.S. Coastal Plain. It is often planted for its beautiful flowers, but it has many other benefits as well. The leaves of the tree can be used as a condiment in gravies and a tea can be made from them. In addition, the leaves or bark can be inhaled for their mild hallucinogenic properties.
Sweetbay is the type species of the genus Magnolia and is considered to typify all flowering plants. It is a slender tree with elegant, dark green leaves that have a pale underside, providing a pleasing contrast. While the deciduous sweetbays are not as desirable due to their dull fall color, the evergreen specimens are highly sought after for their cheerful winter greenery. The flowers of the Sweetbay are creamy-white, lemony or rose-scented, and appear from May to September, making it a long-lasting source of beauty in the garden.
One of the best qualities of Sweetbay is its ability to grow in a variety of soil conditions. It can tolerate both wet and dry soils, making it a versatile choice for different garden landscapes. It is also resistant to verticillium wilt fungal disease, unlike many other magnolias. Sweetbay can be pruned and easily kept in line, making it suitable for smaller residential gardens.
Sweetbay is a slow-growing tree that can reach heights of up to 60 feet. It can be either a tree or a shrub, depending on the growing conditions. Evergreen sweetbays are more abundant in the wild and are often larger trees, while deciduous sweetbays are usually shrubbier and more cold-hardy.
Overall, Magnolia virginiana, or Sweetbay Magnolia, is a valuable ornamental tree for its beautiful foliage, fragrant flowers, and adaptability to various soil conditions. It is a stunning addition to any garden, providing year-round greenery and long-lasting beauty.