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 = '1014'
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
Other: will germinate in 14-60 days
Experience the beauty of southeastern Europe's Bosnian Pine, also known as Pinus heldreichii or Heldrich Pine. This evergreen tree can grow up to 25-35 meters in height with a trunk diameter of 2 meters. It is popular in parks and large gardens due to its neat and conical crown. The Bosnian Pine is reliable and steady in growth, adapting well to a wide range of sites. This species often reaches the alpine tree line, growing at altitudes of 900-2500 meters in Bulgaria, Bosnia, Albania, Macedonia, Serbia, and Greece, and even in southern Italy where it symbolizes the Pollino National Park. A notable specimen in Bulgaria dubbed Baikushev's pine is estimated to be over 1300 years old. Appreciate the timeless elegance of the Bosnian Pine and add it to your garden.