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 = '697595'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/8" deep, tamp the soil, mulch the seed bed
In a Nutshell:
* Picea glauca ( White Spruce ) is a species of spruce native to the north of North America , from central Alaska east to Newfoundland , and south to northern Montana , Michigan , Maine and Wisconsin.
* Needles to 3/4", shiny green or blue green, cones to 2 1/2", green when young, in habit broadly conical when young, later more vertical, widely planted in the U.S., where it is used for hedges, windbreaks, and specimen trees, likes full sun, much grown in the Midwest because of its tolerance and adaptability, native to northern North America.
* The crushed leaves are quite aromatic. more...
* White spruce is the state tree of South Dakota. more...