Hi,
How can I list submission IDs for all submissions belonging to a specific journal using SQL query as it is shown via GUI(Journalxx → Submission [My Queue | Unassigned | All Active | Archives]? I can’t find the relationship between submission_id and journal_id in the tables. Any help?