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 = '694'
group by i.id
Scarification: Pour boiling water over seed , let stand in water for 24 hours, repeat process on seed that did not imbibe
Stratification: none required
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Other: if boiling water treatment does not allow seed to imbibe, sulfuric acid treatment is required
Looking for a tree that can handle harsh conditions and provide ample shade? Look no further than the Gleditsia triacanthos, commonly known as the Honey Locust. It can grow up to 30 meters tall, with delicate bright green leaves that cast a light shade. The tree produces large pods, which have been used to make tea for the treatment of indigestion and measles, while the juice of the pods is antiseptic. The tree needs full sun and is salt tolerant, making it ideal for city environments. It grows quickly and is parent to many good street trees. It's also a potential source of anticancer compounds, with current research examining the leaves. The pulp of the tree's seedpods is sweet and can be eaten raw or made into sugar, while young seedpods can be cooked and eaten. So why wait? Plant a Honey Locust today and enjoy its benefits for years to come.