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 = '422'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 60-90 days
Germination: sow seed 1/4" deep, tamp the soil
Other: The seed usually germinates in 2 - 4 weeks.
Discover the enchanting charms of the Chaenomeles cathayensis (Chinese Quince, Flowering Quince, and Cathay Quince), a species of quince that's native to China, Bhutan, and Myanmar. This majestic deciduous shrub can grow up to 20 ft tall and is adorned with pink to white bell-shaped flowers that are a favorite among early native pollinators. Its leaves are distinct – pointed, oval to lance-shaped with woolly hair on the undersides. During spring, its branches radiate a vibrant white-with-pink hue that can be brought indoors for a touch of cheery late winter blooms!
But what truly sets this plant apart is its notably large, fragrant yellow-red pome that can reach up to 2.5-3 inches wide. These fruits are edible once cooked and can be used in making pies, jellies, and even as an herbal medicine for rheumatic pain, nausea, and diarrhea. It's also a beautiful ornamental tree fit for bonsai.
This adaptable plant can grow as a single-trunk standard or as a fearsome shrub with long thorns. Although it can tolerate partial shade, it thrives best in sunny conditions for optimum fruit production. Experience the alluring aesthetics and practicality of the Chaenomeles cathayensis – a fantastic addition to any garden space.