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 = '423'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Looking for a beautiful and low-maintenance ornamental plant? Look no further than Chaenomeles japonica, also known as Dwarf Flowering Quince, Dwarf Quince, Japanese Flowering Quince, Maule's Quince, or simply Flowering Quince. This deciduous shrub is native to Japan and produces stunning, colorful spring flowers in shades of red, white, pink, or multi. Its apple-shaped fruit is edible, but not typically used for jelly or pie making like its cousin Cydonia. Instead, the fruit can be eaten raw or cooked and is especially delicious when cooked with apples in a pie. C. japonica is also popular for bonsai growing due to its hardy nature. This plant is highly adaptable to different soil types and can be grown in full or partial shade. Give your garden a pop of color and add Chaenomeles japonica to your collection today!