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 = '424'
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
Introducing the Chaenomeles speciosa Chinese Flowering Quince, also referred to as the Flowering Quince, a hardy deciduous shrub that grows up to 3 meters in height, and 5 meters in width. This shrub is not just aesthetically pleasing; it is also medicinally valuable, with a fruit that has been utilized in traditional Chinese medicine for thousands of years to treat arthritis, leg edema and cramping in the calf muscle.
The Flowering Quince boasts showy flowers that come in various colors such as red, scarlet, white and pink, which usually bloom from February to June, taking center stage in your garden. It's even possible for them to appear in midwinter. It's worth noting that this plant is ideal for wildlife, as it is pollinated by bees. With its twining habit, and numerous cultivars with flowers in shades of white, pink, and red, the Flowering Quince is popularly cultivated across many temperate regions.
This plant can be grown in a variety of soils, including light (sandy), medium (loamy) and heavy (clay) soils, though it requires well-draining soil. It can tolerate atmospheric pollution and can grow in full shade or semi-shade, making it a versatile addition to any outdoor space.
The Flowering Quince is not just great for landscaping; it's also great for cooking. The fruit of the Flowering Quince is a fragrant and hard pome that resembles a quince, and it's a delightful ingredient in recipes.
Experience the natural beauty and healing properties of the Chaenomeles speciosa Chinese Flowering Quince. Get your shrub today and add a touch of elegance and wellness into your outdoor space. For more information, please visit https://plants.usda.gov.