Export DOIs with corresponding URLs OJS 3.1.X

How to create list of DOIs with corresponding URLs so cleaning the list of DOIS with CRoss ref can be performed?

Thanks

Hi @vvucic,

I hope you have some SQL knowledge and access to the DB. If you do

SELECT * FROM submission_settings WHERE setting_name = ‘pub-id::doi’

You get the list of submissions that have DOI. With the submission ID you can generate URL to that submission.

Best regards, Primož

I can do that, but my question was about possible more elegant way.
I do have more than 2500 submissions in that installation of OJS.