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 = '697749'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: fall sowing in mulched beds is prefered to artificial stratification
Looking for a plant that can survive in cold arid zones and help stabilize soil? Consider Caragana korshinskii Korshinsk Peashrub! Native to semiconsolidated sand dunes in regions such as Gansu, Qinghai, and Xinjiang, this shrub is an excellent choice for soil revitalization and stabilization. Its ability to improve the soil, provide fodder for animals, and prevent erosion by wind and rain make it a valuable addition to any landscape. With lanceolate leaflet blades and a flat legume, Caragana korshinskii is also a visually appealing plant. Learn more about this species on USDA's website and consider adding it to your garden or landscape for its outstanding soil-stabilizing properties.