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 = '327'
group by i.id
Scarification: Soak in hot tap 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
Discover the beauty of the Japanese Camellia, also known as Camellia japonica or “rose of winter”. A flowering shrub or small tree, it is native to Japan, Korea, and China and is the official state flower of Alabama. With shiny dark green leaves, the flowers of this plant can come in red, white, or pink shades, sometimes with stripes or specks. Camellia japonica wants to grow in a rich, acid soil with part shade or full sun and can be cultivated as both a shrub or small tree. In addition to its aesthetic appeal, an edible oil called “tsubaki oil” can be obtained from the seeds. Explore the thousands of cultivars available and bring the beauty of this graceful plant into your home garden.