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 = '5208'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Experience the beauty and fragrance of the Gardenia jasminoides, also known as common gardenia, cape jasmine, or cape jessamine. This evergreen flowering plant, native to Asia, boasts shiny green leaves and highly fragrant white flowers that bloom in spring and summer. Widely used in warm temperate and subtropical gardens and as a houseplant in temperate regions, it has been in cultivation in China for at least a thousand years. The fruit is used as a yellow dye and in traditional Chinese medicine to treat certain febrile conditions. Cultivars such as 'Magnifica', 'Radicans', and 'Chuck Hayes' offer a range of sizes and cold-hardiness for gardeners. Discover why the Gardenia jasminoides has gained the Royal Horticultural Society's Award of Garden Merit. Try growing this shrub for yourself in a warm, humid environment with acidic soil and bright, indirect sunlight.