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 = '1030'
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
Discover the beauty of Pinus patula, also known as Mexican Weeping Pine, Mexican Yellow Pine, Patula Pine, Jelecote Pine or Spreading-Leaved Pine. This striking tree is native to Mexico and can grow up to 100 ft tall. While it cannot withstand long periods of temperatures below 15°F, it can resist occasional brief dips below zero. It is moderately drought-tolerant, making it a great addition to warm temperate areas. The grass-green needles, slender and gracefully hanging leaves, and cones up to 4.5" make it a stunning tree to behold. It is often multitrunked and sometimes used in Southern California. Pinus patula is cultivated for its timber in many areas of the world, including South Africa, India, and the United Kingdom, where it is widely used as an ornamental tree. Experience the beauty and versatility of Pinus patula for yourself.