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 = '700055'
group by i.id
Germination: sow seed 1/16" deep , tamp the soil, keep moist
Looking for a striking plant with beautiful flowers and traditional medicinal uses? Look no further than Leonotis nepetifolia, also known as klip dagga, Christmas candlestick, or lion's ear. This species of plant belongs to the mint family and is native to tropical Africa and southern India. It can also be found growing abundantly in much of Latin America and the West Indies. Known to grow up to 3 meters high, it has whorls of striking lipped flowers that are most commonly orange, but can vary to red, white, and purple. Its soft serrated leaves can also grow up to 4 inches wide. In Trinidad, the leaves are brewed as a tea for fever, coughs, womb prolapse, and malaria. Attractive to sunbirds and ants, this plant is sure to add beauty to any garden. Try Leonotis nepetifolia today!