@bozana Both queries resulted in publication_id = null:
±--------------±---------------±---------+
| submission_id | publication_id | decision |
±--------------±---------------±---------+
| 11579 | NULL | 8 |
| 11674 | NULL | 8 |
| 11677 | NULL | 8 |
| 11727 | NULL | 8 |
| 11746 | NULL | 8 |
| 11757 | NULL | 8 |
| 11882 | NULL | 8 |
| 12047 | NULL | 8 |
| 12052 | NULL | 8 |
| 12055 | NULL | 8 |
| 13216 | NULL | 8 |
| 13273 | NULL | 8 |
| 13339 | NULL | 8 |
| 13370 | NULL | 8 |
| 13380 | NULL | 8 |
| 13383 | NULL | 8 |
| 13414 | NULL | 8 |
| 13442 | NULL | 8 |
| 13463 | NULL | 8 |
| 13465 | NULL | 8 |
| 13473 | NULL | 8 |
| 13482 | NULL | 8 |
| 13560 | NULL | 8 |
| 13631 | NULL | 8 |
| 13643 | NULL | 8 |
| 13648 | NULL | 8 |
| 13678 | NULL | 8 |
| 13682 | NULL | 8 |
| 13685 | NULL | 8 |
| 13717 | NULL | 8 |
| 13732 | NULL | 8 |
| 13733 | NULL | 8 |
| 13790 | NULL | 8 |
| 13796 | NULL | 8 |
| 13823 | NULL | 8 |
| 13860 | NULL | 8 |
| 13879 | NULL | 8 |
| 14546 | NULL | 8 |
| 14550 | NULL | 8 |
| 14552 | NULL | 8 |
| 14598 | NULL | 8 |
| 14624 | NULL | 8 |
| 14636 | NULL | 8 |
| 14650 | NULL | 8 |
| 14668 | NULL | 8 |
| 14687 | NULL | 8 |
| 14750 | NULL | 8 |
| 14825 | NULL | 8 |
| 14833 | NULL | 8 |
| 14834 | NULL | 8 |
| 15000 | NULL | 8 |
| 15088 | NULL | 8 |
| 15165 | NULL | 8 |
| 15240 | NULL | 8 |
| 15242 | NULL | 8 |
| 15279 | NULL | 8 |
| 15280 | NULL | 8 |
| 15384 | NULL | 8 |
| 15395 | NULL | 8 |
| 15401 | NULL | 8 |
| 15412 | NULL | 8 |
| 15420 | NULL | 8 |
| 15427 | NULL | 8 |
| 15498 | NULL | 8 |
| 15510 | NULL | 8 |
| 15580 | NULL | 8 |
| 15582 | NULL | 8 |
| 15605 | NULL | 8 |
| 15664 | NULL | 8 |
| 15685 | NULL | 8 |
| 15736 | NULL | 8 |
| 15800 | NULL | 8 |
| 15810 | NULL | 8 |
| 15815 | NULL | 8 |
| 15865 | NULL | 8 |
| 15867 | NULL | 8 |
| 15877 | NULL | 8 |
| 15887 | NULL | 8 |
| 15896 | NULL | 8 |
| 15898 | NULL | 8 |
| 15907 | NULL | 8 |
| 15926 | NULL | 8 |
| 15959 | NULL | 8 |
| 16001 | NULL | 8 |
| 16163 | NULL | 8 |
| 16282 | NULL | 8 |
| 16287 | NULL | 8 |
| 16344 | NULL | 8 |
| 16391 | NULL | 8 |
| 16394 | NULL | 8 |
| 16455 | NULL | 8 |
| 16495 | NULL | 8 |
| 16586 | NULL | 8 |
| 16761 | NULL | 8 |
| 16954 | NULL | 8 |
| 17004 | NULL | 8 |
| 17007 | NULL | 8 |
| 17008 | NULL | 8 |
| 17034 | NULL | 8 |
| 17039 | NULL | 8 |
| 17601 | NULL | 8 |
| 17907 | NULL | 8 |
| 17925 | NULL | 8 |
| 17934 | NULL | 8 |
| 18103 | NULL | 8 |
| 18215 | NULL | 8 |
| 18220 | NULL | 8 |
| 18233 | NULL | 8 |
| 18234 | NULL | 8 |
| 18235 | NULL | 8 |
| 18279 | NULL | 8 |
| 18346 | NULL | 8 |
| 18390 | NULL | 8 |
| 18425 | NULL | 8 |
| 18483 | NULL | 8 |
| 18484 | NULL | 8 |
| 18536 | NULL | 8 |
| 18537 | NULL | 8 |
| 18539 | NULL | 8 |
| 18576 | NULL | 8 |
| 18586 | NULL | 8 |
| 18620 | NULL | 8 |
| 18623 | NULL | 8 |
| 18737 | NULL | 8 |
| 18749 | NULL | 8 |
| 18954 | NULL | 8 |
| 18957 | NULL | 8 |
| 18974 | NULL | 8 |
| 18980 | NULL | 8 |
| 19497 | NULL | 8 |
| 19504 | NULL | 8 |
| 19519 | NULL | 8 |
| 19539 | NULL | 8 |
| 19666 | NULL | 8 |
| 19740 | NULL | 8 |
| 20033 | NULL | 8 |
| 20038 | NULL | 8 |
| 20272 | NULL | 8 |
| 20341 | NULL | 8 |
| 20353 | NULL | 8 |
| 20358 | NULL | 8 |
| 20359 | NULL | 8 |
| 20488 | NULL | 8 |
| 20578 | NULL | 8 |
| 20946 | NULL | 8 |
| 20951 | NULL | 8 |
| 20955 | NULL | 8 |
| 20968 | NULL | 8 |
| 21019 | NULL | 8 |
| 21044 | NULL | 8 |
| 21192 | NULL | 8 |
| 21213 | NULL | 8 |
| 21247 | NULL | 8 |
| 21267 | NULL | 8 |
| 21291 | NULL | 8 |
| 21306 | NULL | 8 |
| 21318 | NULL | 8 |
| 21402 | NULL | 8 |
| 21447 | NULL | 8 |
| 21449 | NULL | 8 |
| 21451 | NULL | 8 |
| 21475 | NULL | 8 |
| 21476 | NULL | 8 |
| 21519 | NULL | 8 |
| 21538 | NULL | 8 |
| 21639 | NULL | 8 |
| 21668 | NULL | 8 |
| 21677 | NULL | 8 |
| 21835 | NULL | 8 |
| 21858 | NULL | 8 |
| 21869 | NULL | 8 |
| 21906 | NULL | 8 |
| 22151 | NULL | 8 |
| 22183 | NULL | 8 |
| 22184 | NULL | 8 |
| 22235 | NULL | 8 |
| 22237 | NULL | 8 |
| 22334 | NULL | 8 |
| 22365 | NULL | 8 |
| 22393 | NULL | 8 |
| 22500 | NULL | 8 |
| 22901 | NULL | 8 |
| 22974 | NULL | 8 |
| 23029 | NULL | 8 |
| 23051 | NULL | 8 |
| 23204 | NULL | 8 |
| 23273 | NULL | 8 |
| 23308 | NULL | 8 |
| 23316 | NULL | 8 |
| 23336 | NULL | 8 |
| 23667 | NULL | 8 |
| 23788 | NULL | 8 |
| 23820 | NULL | 8 |
| 23842 | NULL | 8 |
| 23886 | NULL | 8 |
±--------------±---------------±---------+
195 rows in set (0.047 sec)
±--------------±---------------±---------+
| submission_id | publication_id | decision |
±--------------±---------------±---------+
| 11579 | NULL | 6 |
| 11674 | NULL | 6 |
| 11677 | NULL | 6 |
| 11727 | NULL | 6 |
| 11746 | NULL | 6 |
| 11757 | NULL | 6 |
| 12047 | NULL | 6 |
| 12055 | NULL | 6 |
| 13216 | NULL | 6 |
| 13273 | NULL | 6 |
| 13339 | NULL | 6 |
| 13370 | NULL | 6 |
| 13380 | NULL | 6 |
| 13383 | NULL | 6 |
| 13465 | NULL | 6 |
| 13473 | NULL | 6 |
| 13482 | NULL | 6 |
| 13560 | NULL | 6 |
| 13631 | NULL | 6 |
| 13648 | NULL | 6 |
| 13678 | NULL | 6 |
| 13682 | NULL | 6 |
| 13685 | NULL | 6 |
| 13732 | NULL | 6 |
| 13790 | NULL | 6 |
| 13823 | NULL | 6 |
| 13860 | NULL | 6 |
| 13879 | NULL | 6 |
| 14546 | NULL | 6 |
| 14550 | NULL | 6 |
| 14552 | NULL | 6 |
| 14624 | NULL | 6 |
| 14636 | NULL | 6 |
| 14687 | NULL | 6 |
| 14750 | NULL | 6 |
| 14825 | NULL | 6 |
| 14833 | NULL | 6 |
| 15165 | NULL | 6 |
| 15240 | NULL | 6 |
| 15242 | NULL | 6 |
| 15280 | NULL | 6 |
| 15401 | NULL | 6 |
| 15412 | NULL | 6 |
| 15420 | NULL | 6 |
| 15427 | NULL | 6 |
| 15498 | NULL | 6 |
| 15510 | NULL | 6 |
| 15580 | NULL | 6 |
| 15664 | NULL | 6 |
| 15685 | NULL | 6 |
| 15736 | NULL | 6 |
| 15800 | NULL | 6 |
| 15810 | NULL | 6 |
| 15865 | NULL | 6 |
| 15867 | NULL | 6 |
| 15877 | NULL | 6 |
| 15896 | NULL | 6 |
| 15898 | NULL | 6 |
| 15959 | NULL | 6 |
| 16163 | NULL | 6 |
| 16282 | NULL | 6 |
| 16287 | NULL | 6 |
| 16344 | NULL | 6 |
| 16391 | NULL | 6 |
| 16394 | NULL | 6 |
| 16455 | NULL | 6 |
| 16495 | NULL | 6 |
| 16586 | NULL | 6 |
| 16761 | NULL | 6 |
| 16954 | NULL | 6 |
| 17004 | NULL | 6 |
| 17008 | NULL | 6 |
| 17039 | NULL | 6 |
| 17601 | NULL | 6 |
| 17907 | NULL | 6 |
| 17925 | NULL | 6 |
| 17934 | NULL | 6 |
| 18215 | NULL | 6 |
| 18220 | NULL | 6 |
| 18233 | NULL | 6 |
| 18234 | NULL | 6 |
| 18425 | NULL | 6 |
| 18483 | NULL | 6 |
| 18537 | NULL | 6 |
| 18539 | NULL | 6 |
| 18576 | NULL | 6 |
| 18623 | NULL | 6 |
| 18737 | NULL | 6 |
| 18749 | NULL | 6 |
| 18954 | NULL | 6 |
| 19497 | NULL | 6 |
| 19539 | NULL | 6 |
| 19666 | NULL | 6 |
| 20033 | NULL | 6 |
| 20341 | NULL | 6 |
| 20353 | NULL | 6 |
| 20358 | NULL | 6 |
| 20578 | NULL | 6 |
| 20955 | NULL | 6 |
| 20968 | NULL | 6 |
| 21192 | NULL | 6 |
| 21306 | NULL | 6 |
| 21402 | NULL | 6 |
| 21449 | NULL | 6 |
| 21451 | NULL | 6 |
| 21538 | NULL | 6 |
| 21639 | NULL | 6 |
| 21677 | NULL | 6 |
| 21832 | NULL | 6 |
| 22105 | NULL | 6 |
| 22160 | NULL | 6 |
| 22243 | NULL | 6 |
| 22317 | NULL | 6 |
| 22345 | NULL | 6 |
| 22488 | NULL | 6 |
| 22814 | NULL | 6 |
| 22999 | NULL | 6 |
| 23217 | NULL | 6 |
| 23323 | NULL | 6 |
| 23326 | NULL | 6 |
| 23351 | NULL | 6 |
| 23682 | NULL | 6 |
| 23795 | NULL | 6 |
±--------------±---------------±---------+
123 rows in set (0.050 sec)