Hi @asmecher, I have a problem with a sentence in MySQL. I update OJS from 3.1.1.4 to 3.3.0.8 and I saw that the new database structure does not have a published_article or published_submissions table or I don’t know how can I will retrieve it. or I have a problem because don’t have this table in my new ojs 3.3.0.8.
I need to know how can I retrieve the list and count how many articles for sections has an issue from a journal, how can I do it?
I tried to do a query when Use the tables: issues, submissions, journals, publications but I don’t know where can I find a table or field where I have the relation between publication,issues and submission for example: How can I have a query the table content from an issue published?
for example the list in this area from issue
Thanks in advance,