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 = '570'
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 cold water, let stand in water for 24 hours|
Stratification: warm stratify for 120 days, cold stratify for 90 days|
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: Spring sowing of unstratified seed will produce germination the next spring
Discover the rare and beautiful Crataegus vulsa, also known as the Alabama Hawthorn. It is a unique species of hawthorn that is only found in northeastern Alabama and northwestern Georgia. This exquisite tree boasts beautiful pink and white flowers that bloom in the springtime, followed by vibrant red fruit in the fall. It is a great addition to any landscape and is an excellent choice for those who want to add an interesting plant to their garden. Learn more about Crataegus vulsa and add this special plant to your collection today! More information can be found on the USDA website.