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 = '826'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 180 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
The tulip poplar (Liriodendron tulipifera) is a majestic tree that is native to eastern North America. It is known for its large, tulip-shaped leaves, fragrant white flowers, and straight, tall trunk. Tulip poplars can grow to be over 100 feet tall, and they have a lifespan of up to 400 years. Tulip poplars are a popular choice for landscaping because they are fast-growing, tolerant of a wide range of soils, and relatively pest- and disease-free. They are also very wind-resistant, making them a good choice for areas that are prone to storms.