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 = '329'
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
Introducing the stunning Christmas Camellia, also known as the Sasanqua Camellia or Yuletide Camellia. Native to southern Japan, this evergreen shrub boasts glossy green foliage and fragrant, single white flowers that blossom extremely early in the season, often as early as Christmas. With a long history of cultivation in Japan for practical purposes, the leaves can be used to make tea while the seeds or nuts are used to make tea seed oil, which is edible if refined and said to be as good as olive oil. Various cultivars have been selected, some of which have earned the Royal Horticultural Society's Award of Garden Merit. Easy to care for and adaptable to different soils and levels of sunlight, this ornamental plant is perfect for any garden or landscape. Order yours today and enjoy the beauty and practical benefits of the Christmas Camellia.