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 = '3450'
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/4" deep, tamp the soil, keep moist, mulch the seed bed
Pinus greggii, also known as Gregg's Pine, is a small to medium-sized pine tree native to eastern Mexico. It can be found in two distinct regions and has a unique appearance characterized by an open crown and long, slender branches. The needles are bundled in groups of three and are approximately 11 cm in length. The cones are clustered in groups of 5-10 and the branches and upper trunk have smooth bark. Pinus greggii has been introduced in several countries and is closely related to Pinus patula. It grows in cool highland areas at altitudes between 1300-2600m and prefers slightly alkaline or acid soils. This pine tree is not frost-resistant but can tolerate sporadic light frosts. It usually grows mixed with other tree species like Quercus, Platanus, and Liquidambar. Pinus greggii has been cultivated in various subtropical countries, including Brazil, Colombia, New Zealand, and South Africa. Overall, it is a unique and attractive tree that adds beauty to any landscape.