select * from operator where operatorid in (select distinct operatorid from tour where vacationtype='1' ) order by location LIMIT 0,20