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 = '2096'
group by i.id
Austria, Belgium, Bulgaria, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Romania, Slovenia, Spain, Sweden
Scarification: Soak in hot tap water, let stand in water for 24 hours
Stratification: cold stratify for 120 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Crataegus x MARSHALLII Parsley Hawthorn is a stunning native tree that will bring beauty and interest to any landscape. This small deciduous tree is known for its finely dissected, parsley-shaped leaves that provide a lacy, fine textured appearance. In the spring, clusters of pure white blossoms emerge, followed by cherry red fruits in the fall. The bark of the tree is also quite beautiful, adding to its ornamental value.
Growing up to 15-20 feet tall and wide, the Crataegus x MARSHALLII Parsley Hawthorn is the perfect addition to habitat gardens. It thrives in areas subject to flooding, making it a great choice for wetter environments. Throughout the year, this tree will grace your garden with its beauty. From white flowers in the spring to delicate foliage in the summer, vibrant berries in the fall, and interesting bark and form in the winter, there is always something to admire.
Not only is the Crataegus x MARSHALLII Parsley Hawthorn visually appealing, but it also provides value to wildlife. The berries are a valuable food source for songbirds and many mammals. Additionally, the thorny habit of hawthorns makes them excellent nesting sites for songbirds, further enhancing their ecological value.
This native tree is commonly found in swamp forests and drier upland sites along the southeastern coast of the United States. It is well-adapted to various soil types, from fine-textured to medium-textured, as long as they are well-drained. The Crataegus x MARSHALLII Parsley Hawthorn can tolerate both full sun and partial shade, and it can withstand both flooding and drought once established.
With its attractive foliage, beautiful flowers, and vibrant berries, the Crataegus x MARSHALLII Parsley Hawthorn is an excellent choice for anyone looking to enhance their landscape with a native tree. Whether you're looking to attract wildlife or simply add visual interest, this tree is sure to impress. Plant it in your garden and enjoy its beauty year-round.