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 = '687'
group by i.id
Germination: can be sown outdoors in the fall for spring germination, surface sow and keep moist, tamp the soil, keep moist, requires light for germination
Gaultheria shallon, also known as salal or shallon, is a leathery-leaved shrub in the heather family native to western North America. It grows up to 5m tall and is tolerant of both sunny and shady conditions. Salal’s dark blue berries and young leaves are both edible and are efficient appetite suppressants, both with a unique flavor. The shrub has medicinal properties used by local natives for generations, and has a large industry in the Pacific Northwest for supplying cut evergreens worldwide for use in floral arrangements. Salal is not invasive in the regions it inhabits, but it can grow in dense, impenetrable thickets. Its unique properties make it a valuable plant for landscaping and for use in the food and medicine industry.