OJS data export for ojs 3

I would like to run an select statement on the ojs databases.
Do anyone know the basic syntax examples to run on my databases.
any examples statement would be helpful.

[Journal Title] [Volume #] ([Issue #]), [Pub. Year]


[Article Title]

[Author first name] [AUTHOR LASTNAME], [2nd Author first name] [2nd AUTHOR LASTNAME]



[Abstract] [R]

Hi @jmacgillivray,

Here is an example of a select statement: Database upgrade problem for 2.4.8-2 to 3.1.0-1 - #16 by bozana

Amanda Stevens
Public Knowledge Project Team