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 = '5171'
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 2 weeks
Germination: sow seed 3/8 deep, tamp the soil, mulch the seed bed
Pinus radiata, also known as Monterey Pine, Insignis Pine or Radiata Pine, is a fast-growing softwood tree that is native to the Central Coast of California and Mexico. It is suitable for a range of uses, and its unique silviculture techniques have made it a model for growers of other plantation species. It is considered one of the most widely planted pines in the world, prized for its desirable lumber and pulp qualities. This adaptable tree is known for its bright green needles and quickly growing height, making it an excellent choice for shelterbelt planting. While it is considered a noxious weed in California, it is often used ornamentally in southern California, especially along the coast. In addition, it is extensively cultivated in many parts of the world, notably Australia, New Zealand, Chile and South Africa. Despite being closely related to other Californian pines, this versatile tree is widely recognized as a distinct species and is appreciated around the world for its many positive attributes.