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 = '698701'
group by i.id
Scarification: file or sand through the outer seed coat, or Soak in sulfuric or nitric acid for 25 minutes and wash under cold water for 10-15 minutes.
Stratification: none required
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Other: Needs hot temperature to germinate. 85 degrees F recommended.
Adenanthera pavonina, also called Red Lucky Seed, is a fast-growing, non-climbing species of leguminous tree that has multiple uses, including nitrogen fixation, forage cultivation and as an ornamental plant. This tree is highly valued for its spreading canopy and ability to provide shade, making it ideal for large gardens or parks. The hard, scarlet seeds of Adenanthera pavonina are known for their use as beads in jewelry and for their almost identical weight, which historically made them an ideal unit of weight for fine measures. The seeds also have medicinal uses, with extracts having antibacterial and anti-inflammatory effects according to preliminary scientific studies. Additionally, the wood of this tree is extremely hard and is used in boat-building, making furniture and as firewood. Adenanthera pavonina is a versatile and beautiful addition to any garden or landscape and is sure to impress.