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 = '1006'
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 30 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Pinus gerardiana, also known as Chilghoza Pine or Chilgoza Nut Pine, is a pine tree native to the northwestern Himalayas in eastern Afghanistan, Pakistan, and northwest India. It grows at elevations between 1800-3350 meters in association with Blue Pine and Deodar Cedar. The tree can reach 10-25 meters tall, with a characteristic flaky bark, blue-green needles, and 9-inch cones that contain edible seeds. Rich in oil and with a pleasant resin-like flavor, the Chilgoza Pine nuts are used as a staple food, similar to pistachio nuts, and are considered a delicacy thanks to their high quality. However, the species is at risk due to overcutting and poor regeneration, which could result in its extinction. Chilgoza Pine seeds are an important cash crop for locals in the Kinnaur district of Himachal Pradesh, India, where they fetch good money, with prices ranging from PKR 2500-4500 INR 1800-2400 ($20-$53) per kilogram.