Anonymous

                  SELECT sent_match.teacher_id, sent_match.job_id,                                                           
                         sent_match.teacher_notes, sent_match.job_notes,                                                     
                         sent_match.teacher_response, sent_match.job_response                                                
                         FROM sent_match RIGHT JOIN teachers ON sent_match.teacher_id = teachers.teacher_id                  
                         WHERE ( sent_match.success = 1                                                                      
                         OR sent_match.teacher_response = 1                                                                  
                         OR sent_match.teacher_response = 0                                                                  
                         OR sent_match.job_response = 1                                                                      
                         OR sent_match.job_response = 0                                                                      
                         )                                                                                                   
                         AND sent_match.deleted != 1 AND teachers.status != -1