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 = '698207'
group by i.id
Other: Germination should occur in 10-21 days.|Does not require stratification. However, a brief cold period seems to induce germination.
Monarda didyma, commonly known as Scarlet Beebalm, is a hardy perennial plant native to eastern North America. It produces square stems growing up to 3 ft in height, with opposite dark green leaves bearing reddish leaf veins and a coarsely toothed margin. The plant bears flowers in dense clusters, with ragged, bright red tubular flowers growing up to 1.5 in long that bloom from mid- to late summer. The plant is extensively grown as an ornamental plant due to its vibrant colors and strong resemblance to the Bergamot orange, which is the source of Earl Grey tea's flavoring. Besides its ornamental use, Monarda didyma has a long history of use as a medicinal plant, particularly by Native Americans. It has also been used as a natural source of the antiseptic thymol, the primary active ingredient in many modern mouthwash formulas. Monarda didyma is easy to grow, thriving in full sun and any well-drained soil. It is available in several cultivars, which range from white through pink to dark red and purple.