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