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 = '5699'
group by i.id
Germination: requires light for germination, surface sow and keep moist
Nicotiana glauca, also known as tree tobacco, is a unique and fascinating plant species with a rich history of medicinal and cultural uses. Native to South America but now found on other continents as an introduced species, it grows to heights of more than two meters and has large blue-green leaves attached to the stalk by petioles. While highly toxic if ingested, the plant has been used by Native American groups as a poultice to treat various ailments. It is now being investigated for use as a biofuel. If you're interested in growing this hardy plant, it prefers a well-drained deep rich moist soil in a sunny position and requires more than 14 hours daylight per day in order to induce flowering. Get your seeds and start growing now!