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 = '700262'
group by i.id
Scarification: Soak in cold water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Looking to add a unique plant species to your garden? Look no further than Chamaecrista nictitans, also known as the Sensitive Partridge Pea. This herbaceous legume boasts impressive rapid plant movement capabilities, with its leaflets folding together at the slightest touch. Widely distributed throughout the Americas, Chamaecrista nictitans is an annual plant with smaller leaves than its cousin, Chamaecrista fasciculata. Add some exciting movement and diversity to your garden by planting Chamaecrista nictitans today.