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 = '700358'
group by i.id
Other: expect germination in 10 days @ 70-85 degrees F, it will take longer if cooler
In a Nutshell:
* Nicotiana tabacum, or cultivated tobacco, is an annually-grown herbaceous plant. It is found only in cultivation, where it is the most commonly grown of all plants in the Nicotiana genus, and its leaves are commercially grown in many countries to be processed into tobacco.
* N. tabacum is sensitive to temperature, air, ground humidity and the type of land. Temperatures of 20–30 °C (68–86 °F) are best for adequate growth; an atmospheric humidity of 80 to 85% and soil without a high level of nitrogen are also optimal.
* In their great first voyage to the New World, Christopher Columbus and his expedition were introduced to a plant whose smoke was called tobacco by the natives of Hispaniola. more...
* All parts of the plant contain nicotine, this has been extracted and used as an insecticide. The dried leaves can also be used, they remain effective for 6 months after drying. more...