select u.email, concat(u.first_name,' ',u.last_name) as name, c.name as course, b.batch_active_status as batch_status from student_enroll as se left join users as u on se.users_id = u.id left join course as c on se.course_id = c.id left join student_batch_assigned as sba on se.id = sba.enroll_id left join batch as b on sba.batch_id = b.id where se.enroll_status = 'success' and se.course_id in (4,43,331) and sba.status = 'active' and b.batch_active_status = 'completed'