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