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 = '700411'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Fraxinus Texensis, commonly known as the Texas Ash, is a small deciduous tree that is native to North America. It grows up to 10 meters tall with a trunk diameter of up to 30 centimeters. It is found in dry, rocky slopes over limestone in eastern Texas and southern Oklahoma in the United States, and Durango in Mexico. The Texas Ash is drought tolerant and can even survive in alkaline and exposed positions. Its small and rounded features differentiate it from its close relative, the white ash. The Texas Ash produces purple flowers in clusters during the early spring, and its fruit is a samara with an apical wing. It is long-lived and fast-growing, making it an excellent choice for landscaping in woodland gardens, as a street tree, or for fuel and forestry purposes. It prefers well-draining soil, although it can tolerate acidic and alkaline soils, semi-shade, and is even capable of withstanding atmospheric pollution and strong winds. For those interested in growing the Texas Ash, it requires planting both male and female trees for pollination.