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 = '1032'
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: stratification may be replaced by a 24 hour cold water soak (40 degrees Fahrenheit)
Pinus pinaster, also known as the Maritime Pine or Cluster Pine, is a fast-growing pine tree native to the western Mediterranean region. It is widely planted for timber in its native area, making it a vital tree in forestry in France, Spain, and Portugal. It is also a popular ornamental tree, often found in parks and gardens in warm temperate climates. This tree is highly tolerant of maritime exposure, making it an ideal choice for shelterbelts along exposed coasts and for stabilizing sandy soils. Its large wings containing small seeds make it a successful invasive species in areas like South Africa, where it has caused a decrease in biodiversity. Despite its invasiveness, Pinus pinaster remains a valuable resource for timber and as a source of turpentine and rosin. It is also commonly used in dietary supplements due to the presence of flavonoids, catechins, proanthocyanidins, and phenolic acids.