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 = '4219'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 180 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Discover the beauty of the Liriodendron chinense, also known as the Chinese Tulip Tree. This majestic tree is native to central and southern China, as well as northern Vietnam, and can reach up to 40 meters in height. Protected populations of this species can be found in national reserves, including the Tianmushan National Reserve and Badagongshan Nature Reserve. Though it resembles the American species, Liriodendron tulipifera, the Chinese Tulip Tree can be distinguished by its slightly larger and more deeply-lobed leaves, and shorter inner petals that lack the orange pigment of the former. While it may not be as hardy as the American species, it is still commonly cultivated in England, Belgium, the Netherlands, Germany, and even North America. See for yourself why the Liriodendron chinense is truly a gem of Asia's native flora.