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 = '1191'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Introducing the Pyrus calleryana, also known as the Callery Pear. This stunning deciduous tree is native to China and can grow to heights of 15-20 meters with a conical to rounded crown. Its oval, glossy dark green leaves are 4-7 cm long and slightly paler underneath. The Callery Pear is most striking in early spring when its white flowers bloom in abundance, measuring 2-3 cm in diameter. The trees produce a unique scent some find distasteful, but its wood is highly prized for its fine texture and is used in the production of woodwind instruments and furniture veneers. In autumn, the foliage turns brilliant colors ranging from yellow and orange to red, pink, purple, and bronze. Widely used as rootstock for grafting Bradford and other pear varieties, the Callery Pear is an ideal choice for those seeking an elegant and unique addition to their garden. Learn more about this fascinating tree at http://plants.usda.gov.