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 = '1063'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Scotch Pine, also known as Scots Pine or Pinus sylvestris, is a versatile and important tree in forestry. Originally native to northern Europe and Asia, it has since been introduced to North America and has become a popular choice for commercial tree farms in the United States. Scotch Pine is an evergreen coniferous tree that can grow up to 25 meters in height with a distinctive straight trunk topped by a rounded or flat-topped mass of foliage. It is known for its blue-green needles and orange-red bark. The wood of this tree is commonly used for pulp and sawn timber products. It is highly adaptable and can thrive in a variety of soils. Scotch Pine is well-suited for use as a Christmas tree due to its irregular pyramid shape when young, and as it matures, it opens up with widespreading branches. Enjoy the beauty of the Scotch Pine in your own home or yard.