select *
from ENTRIES as e
JOIN SUBMISSIONS as s on e.ENTRY_ID = s.ENTRY_ID and s.ENTRY_ID is not null
where s.STATUS = 'AC'
and s.SUBMITTED_AT between '2022-07-20 17:00:00' and '2022-07-20 18:00:00'
order by e.ENTRY_ID