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 = '699022'
group by i.id
Germination: sow seed 1/8" deep , tamp the soil, mulch the seed bed
The "Phacelia tanacetifolia Lacy Phacelia" is a species of phacelia known by the common names lacy phacelia, blue tansy or purple tansy. It is an annual herb that grows erect to a maximum height of about 100 centimeters. This plant is originally native to the Southwestern United States and northern Mexico, but it is now widely used in agriculture for various purposes. It is known as a cover crop, a bee plant, an attractant for other beneficial insects, and a green manure. It is also used as an ornamental plant in vineyards and alongside crop fields. The long, coiling inflorescences of nectar-rich flowers attract pollinators such as honey bees and hoverflies, which are useful for biological pest control. The plant can thrive in any moderately fertile, well-drained soil in a sunny position, although it prefers moist soil. The flowers are a rich source of nectar and can be commercially grown as a crop for bees. The seeds of Phacelia tanacetifolia are "negatively photoblastic" and will only germinate in darkness. This plant is easy to propagate by sowing the seeds in late spring or late summer, and it often self-sows. Overall, the "Phacelia tanacetifolia Lacy Phacelia" is a versatile and beneficial plant for both agriculture and attracting beneficial insects.