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 = '1018'
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: none required
Germination: sow seed 1/8" deep , tamp the soil, mulch the seed bed
Introducing the Mountain Pine or Mugo Pine (Pinus mugo var. mughus), a stunning high-altitude European pine tree found in the majestic Pyrenees, Alps, Erzgebirge, Carpathians, northern Apennines, and Balkan Peninsula mountains. This resilient tree thrives at altitudes ranging from 1,000m to 2,200m, with some specimens found as low as 200m in Germany and Poland, and as high as 2,700m in Bulgaria or the Pyrenees.
Unlike most species of pine, the Mountain Pine can be easily transplanted and adapts well to different environments. It flourishes in well-drained sandy or gravelly loamy soil, while disliking poorly drained moorland soils. Even in challenging conditions, established plants showcase their resilience by tolerating drought and strong winds, including maritime exposure. It even thrives in the poorest of soils, making it an ideal choice for a variety of landscapes.
This polymorphic species offers a diverse range of named varieties, each with its own ornamental value. While self-fertilized seed growth is generally poor, these trees freely hybridize with other members of the genus, showcasing their adaptability and genetic diversity. Plant enthusiasts are sure to be captivated by the variety of options available.
Adding beauty to any landscape, the Mugo Pine boasts small, dark green evergreen needles that maintain their charm year-round. Its low-maintenance nature and slow growth make it an excellent choice for beginners in bonsai cultivation. With a sturdy frame and resistance to extreme heat, cold, diseases, and insects, this outdoor tree can be enjoyed outdoors throughout the year with the right protection.
To cultivate the Mugo Pine, simply plant the seeds in well-drained soil during the fall season, keeping the soil evenly moist. As the tree matures, its growth can be gradually reduced, allowing for styling and repotting during the summer months and early fall.
Experience the beauty and resilience of the Mountain Pine or Mugo Pine (Pinus mugo var. mughus) in your own landscape. Visit our website for more information on this exceptional species and to discover the diverse range of named varieties available.