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 = '256'
group by i.id
Germination: surface sow and keep moist, tamp the soil. Cover to keep light out. Remove cover after germination.
Other: seeds normally germinate in 7-30 days at diurnally alternating temperatures of 86 and 68 degrees F.
Looking for a fast-growing hedge? Consider the Baccharis halimifolia, also known as Groundsel Tree, Eastern Baccharis, or Cotton-seed Tree. This evergreen perennial plant is native to the southeastern United States, but can be found as far north as Maine. It's a great choice for exposed maritime conditions, as its extensive root system can bind the soil and it grows well on sand or thin coastal soils. Eastern Baccharis is also unusual in its salt-tolerance; it can thrive along salty or brackish shores of marshes and estuaries and provide food and cover for wildlife. Although the plant's seeds are toxic to humans, it has been traditionally used as a medicine to treat inflamed kidneys and fever in southern Louisiana. Eastern Baccharis is occasionally cultivated and is useful as a hedge or border, as well as a specimen plant. Germination usually takes place within 1-2 weeks, making it a relatively quick and easy addition to any landscape.