Negative Review Process Quartz Jobs

select application.id, person.name, campus.description, state.simple_name, job_name, qjd.description
from application,state,campus,office, qrtz_job_details qjd, person,application_role ar where 
state_id in (111,112) and year=2020 and 
application.state_id=state.id and
application.office_id=office.id and
office.campus_id=campus.id and 
application.id=ar.application_id and 
ar.role_id=1 and 
ar.person_id=person.id and 
(qjd.description like (concat('Job%',application.id)) or
qjd.description like (concat('Rebuttal%',application.id))) order by application.id;