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 = '698787'
group by i.id
Scarification: Nick or file through seed coat. Soak in water 24 hours or until seed has expanded considerably.
Stratification: none required
Germination: sow seed 1/4 deep, keep moist
Other: The seed usually germinates in 2 - 4 weeks.|Seed needs warm temperatures after sowing to germinate (75 degrees F +).
Clitoria ternatea, also known as Asian pigeonwings, bluebellvine, blue pea, butterfly pea, cordofan pea, and Darwin pea, is a beautiful blue variety of the pea plant species belonging to the Fabaceae family. Its flowers are known for their unique shape, resembling that of human female genitals, hence its Latin name "Clitoria". This plant is native to tropical Asia, and is widely cultivated as an ornamental plant for its stunning flowers. It is also used in traditional medicine, with various properties including memory-enhancing and antistress. In Southeast Asia, the flower is used as a natural food coloring and used to color food like glutinous rice for kuih ketan/pulut tai tai or pulut tekan in Peranakan/Nyonya cooking, and is also used to make a syrupy blue drink called nam dok anchan in Thailand. Overall, Clitoria ternatea is a versatile and aesthetically pleasing plant species with a rich cultural and medicinal history.