There was a similar question here:
Do you have SQL access to your database? If so, can you answer the same questions asked there to help us debug? Especially:
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?