SELECT teachers.*, sent_match.*, school_jobs.*                                                                          
                       FROM school_jobs,teachers,sent_match                                                                                    
                       WHERE teachers.arrival BETWEEN school_jobs.arrival -2                                                                   
                              AND school_jobs.arrival +2                                                                                       
                              AND ( teachers.location = school_jobs.city OR teachers.location = '1' )                                          
                              AND teachers.status != -1                                                                                        
                              AND school_jobs.status != -1                                                                                     
                              AND ( teachers.teacher_id != sent_match.teacher_id OR sent_match.teacher_id IS NULL)                             
                              AND (school_jobs.school_jobs_id != sent_match.job_id OR sent_match.job_id IS NULL)                               
                              AND sent_match.job_id = ''                                                                                       
                              AND sent_match.teacher_id = ''