select * from university where id IN (select university_id from university_major where major_id='33') AND status=1