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 = '698898'
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. Another Method: file or sand through the outer seedcoat, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/8" deep , tamp the soil, mulch the seed bed
Other: germination may be delayed for up to 90 days
Psidium guajava, commonly known as the common guava, yellow guava or lemon guava, is a versatile plant native to the Caribbean, Central America, and South America. It is an evergreen shrub or small tree that can be easily pollinated by insects. The fruit can range in size from as small as an apricot to as large as a grapefruit, with various cultivars having white, pink or red flesh and red, green or yellow skin. Guava is an edible fruit and can be eaten raw or cooked. When cultivated from seed, guavas show a slow growth rate before rapidly accelerating in growth. The plant's leaves and fruits have traditional medicinal uses in many cultures throughout Central America, the Caribbean, Africa, and Asia, for inflammation, diabetes, hypertension, and other ailments. The plant is also used in many shampoo products for its scent. With its ability to adapt to different soils and conditions, guava is a versatile plant ideal for growing in tropical and subtropical regions. Be sure to try guava and enjoy its many benefits!