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 = '820'
group by i.id
Germination: surface sow and keep moist, tamp the soil, requires light for germination
Other: can be spring or fall sown
Looking for a beautiful and versatile plant to add to your garden? Consider Linaria vulgaris, also known as Common Toadflax, Yellow Toadflax, or Butter-and-eggs. This species of toadflax is native to most of Europe and northern Asia, as well as the United Kingdom and Spain. It has also been introduced and is now common in North America, though it is considered a noxious weed in some areas. Despite its reputation, Linaria vulgaris has a range of uses. A yellow dye can be obtained from the whole plant or just the flowers. A tea made from the plant is an effective insecticide. Additionally, the plant has been used in folk medicine to treat a variety of ailments. As a perennial plant with short spreading roots, it's perfect for a range of growing conditions and can grow up to 90 cm tall. Its threadlike, glaucous blue-green leaves and pale yellow flowers make for a striking addition to any garden or landscape.