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 = '904'
group by i.id
Germination: sow indoors 2 months before the date of the last frost
Other: Sow seeds in the spring inside a greenhouse - said to germinate easily.
Nicotiana alata, also known as Jasmine Tobacco, Winged Tobacco, or Persian Tobacco, is a species of tobacco native to South America. It is mainly grown as an ornamental plant with numerous cultivars and hybrids derived from it. This plant produces beautiful, fragrant 2-inch-wide, trumpet-shaped flowers that vary in color from greenish to white to pinks, reds, and purples. It blooms from summer to fall in sun to partial shade. The plant reaches a height of 12 to 24 inches and needs to be spaced at 12 to 14 inches. Self-sowing is common in mature plants, and deadheading spent flower stalks is recommended for best blooming results. Although all parts of the plant contain nicotine, it has been extracted and used as an insecticide. Nicotiana alata is a stunning addition to any garden with its lovely fragrance in the evening to night. It is highly recommended for those gardening in the northern U.S. as an annual, and as a perennial in the south.