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 = '985'
group by i.id
Australia, Austria, Belgium, Bulgaria, Colombia, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Netherlands, New Zealand, Poland, Portugal, Romania, Slovak Republic, Slovenia, Spain, Sweden, Switzerland, Turkey, United Kingdom
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 60 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Introducing the Pinus attenuata var. X radiata Knobcone X Monterey Pine – a unique tree known for its knobby cones that can remain closed for many years. When exposed to fire, the cones open and allow for reseeding. These rare California cones are popular for jewelry making due to their extreme density and beautiful lines when cut open. They are also perfect for home decor and bring the outdoors in. The cones are naturally imperfect, crafted by nature, and made in the USA. The Knobcone Pine is a well-adapted species to fire, making them durable with tough outer spines that withstand fire. These medium-sized cones are easy to work with and cut, and are available in new good quality. They have no chemicals or preservatives applied, making them natural from the forest. Purchase more and get a discount on the cones. Keep out of the hands of small children. Learn more about these unique cones on our website.