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 = '1407'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 120 days, cold stratify for 90 days
Germination: sow seed 1/8" deep , tamp the soil, mulch the seed bed
Stewartia pseudocamellia, also known as Japanese Stewartia or Deciduous Camellia, is an attractive ornamental tree native to Japan and Korea. With a height of 10-15m, it features beautiful white flowers with orange centers in July, exfoliating bark in patches of orangy brown, gray, and brown, and fall colors of yellow, red, and dark reddish purple. It has a pyramidal or oval habit and is probably the best garden Stewartia, as noted by Dirr. Growing best in rich organic soils, this tree requires consistent moisture and some light shade in the afternoon to avoid the hot sun. It can be used as a specimen in shrub borders or as a specimen lawn planting with year-round interest. When grown with single trunks, it forms taller pyramidal-shaped trees, and when having multiple trunks, plants tend to grow shorter and spread out wider. This beautiful tree was introduced to the Western cultivation in 1874, and it can tolerate winters as cold as -30°C.