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 = '2219'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 30 days, cold stratify for 120 days
Germination: sow seed 1/8" deep , tamp the soil, mulch the seed bed
Explore the wonders of the Amelanchier arborea, commonly known as Downy Serviceberry. This North American native can reach up to 40 ft high, flaunting a robust bark that's smooth and gray, setting an impressive backdrop for its white blossoming flowers. Enjoy its distinct display of orange-yellow to reddish hues during the fall season. Its extensive root system plays a crucial role in erosion control, making it an ideal choice for planting on banks. Its wood, one of the heaviest in North America, is renowned for its close-grained, hard, tough, and highly elastic characteristics, making it perfect for crafting durable handles. Experience the allure of its ovate or elliptical leaves that emerge downy on the underside. Witness a stunning flower show that announces the arrival of spring; the Serviceberry impresses with white, monoecious flowers attracting bees for efficient pollination. Its summer-loving fruits, that resemble small apples, are a sweet treat for the local bird population.