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 = '700243'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 60 days
Germination: sow seed 3/4" deep, tamp the soil, mulch the seed bed
Quercus palmeri, also known as Dunn oak or Palmer's oak is native to California, Baja California, New Mexico, and Arizona. It is an oak species that thrives in varied settings including canyons, mountain slopes, washes, and other dry habitats. Witness its versatility as it grows from a shrub into a small tree that can reach heights of up to 20 feet. The Palmer's oak flaunts angular twigs adorned with stiff, leathery leaves measuring between 0.4 to 1.2 inches in size. These leaves display an intricate texture having wavy edges with sharp spine-teeth, and a captivating color play of shiny olive-green on the upper surface and a gray-green underside coated with glandular hairs. The tree also bears unique fruits - acorns with a 1 inch wide hairy cap and a blunt-ended nut that's 0.8-1.2 inches long. Unveil its mystery as it usually grows in small, cloned populations. One extraordinary clone titled Jurupa Oak found in the Jurupa Mountains of Riverside County, California is estimated to be over 13K years old. This plant, a living relic from the Pleistocene, is one of the world's oldest living plants.