migrating oracle query to mysql query

[Adi Manohar]

please any one help to converting this oracle query to mysql


SELECT e.emp_id,e.user_id,e.firstname,e.qualification,e.phone FROM employee_tbl e, users_tbl u WHERE e.user_id=u.user_id AND u.activeflag=1 AND to_number(e.emp_id) IN (SELECT to_number(emp_id) FROM subjecttime_tbl WHERE end_time BETWEEN ? AND ? AND weekday = ? AND activeflag=1
MINUS SELECT to_number(emp_id) FROM subjecttime_tbl
WHERE end_time IN (?) AND weekday = ? AND activeflag=1
UNION "
SELECT to_number(emp_id) FROM subjecttime_tbl
WHERE start_time BETWEEN ? AND ? AND weekday = ? AND activeflag=1
MINUS SELECT to_number(emp_id) FROM subjecttime_tbl
WHERE start_time IN (?)AND weekday = ? AND activeflag=1);

thanks