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 = '700'
group by i.id
Stratification: warm stratify for 90 days, cold stratify for 90 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Add a touch of southern beauty to your garden with Halesia diptera, also known as the Two-winged Silverbell or Two-winged Snowdrop Tree. Native to the southeastern United States, this large shrub or small tree produces clusters of refined white flowers and distinctive dry drupes with two wings down the sides. With an arching habit similar to that of H. carolina, it is recommended highly by Dirr and is native to southeast and south-central U.S. and cultivated as an ornamental tree. Don't miss out on this stunning addition to your landscape.