SELECT jb.company_id from job_post as jb LEFT JOIN employer_sign_up as es ON es.employer_id = jb.employer_id where jb.job_post_id='1187' AND jb.status='active'