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 = '5179'
group by i.id
Scarification: Soak in water, let stand in water for 12 hours.
Stratification: none required
Germination: sow seed 3/4" deep, tamp the soil, mulch the seed bed
Looking for a unique addition to your garden? Consider the Lithocarpus edulis, also known as the Japanese Stone Oak. This evergreen tree, native to Japan, can grow up to 15 meters tall and produces edible nuts. While the nuts have a bitter taste, they can be made palatable by soaking them in water for a few days or grinding them into a powder prior to soaking. The tree is also cultivated as an ornamental plant and makes for a stunning addition to any landscape. Add the Lithocarpus edulis to your garden today and enjoy the unique beauty and flavor it has to offer.