Hi @graupp
Hmmm… strange…
Could you maybe investigate the values in the DB from that SQL statement, e.g.:
- What is the value of the journal setting_name = ‘publishingMode’ in the DB table journal_settings?
- What is the status value of those articles that are not listed, e.g. article with the id = 216?
To double check: you have changed the X at the end with the real journal ID, right?
Hmmm… 
Bozana