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 = '248'
group by i.id
Scarification: Soak in water, let stand in water for 48 hours
Stratification: cold stratify for 90 days
Germination: sow 1" deep, tamp the soil, mulch the seed bed
Asimina triloba, also known as the Common Pawpaw, is a unique tropical-looking fruit native to the eastern United States and Canada. It holds the title of the largest edible fruit indigenous to the United States. The fruit is typically harvested in September through October and can be eaten raw or used for making preserves, pies, ice cream, and other sweet desserts. The tree produces droopy long leaves, providing a 'sleepy' aura to the summer landscape. Growing up to 30 ft in height, it is easy to cultivate from seed in the spring in an area with part shade and sun. This small deciduous tree belongs to the same plant family as the custard-apple, cherimoya, sweetsop, ylang-ylang, and soursop. The pawpaw is a patch-forming understory tree found in well-drained, deep, fertile bottom-land and hilly upland habitat. The fruit has a sweet, custardish flavor similar to banana, mango, and cantaloupe. Try growing the Common Pawpaw in your garden and enjoy a taste of uniquely American fruit!