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 = '5127'
group by i.id
Scarification: Pour boiling water over seed , let cool in water for 24 hours
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Acacia farnesiana, also known as Mealy Wattle, Needle Bush, or Sweet Acacia, is a versatile and aromatic plant with a pantropical distribution, originating from Mexico and Central America. One of its unique features is the numerous thorns along its branches. The plant produces deliciously scented essential oil, Cassie, with a fragrance of violets. The oil is widely used in European perfumery and employed for preparing violet bouquets. A mature plant can produce up to 9 kg of flowers each year. The flowers yield the oil in form of concrete or pomade, used as a perfume or in pomades. In addition to being grown for perfumery, this species is used for erosion control, and the bark and fruit are a source of tannin, used in making dyes and inks, and the woody branches are used in India as toothbrushes. With a life span of 25-50 years and growing up to a height of 8 meters, Acacia farnesiana is a unique and versatile addition to any garden.