Cacher is the code snippet organizer for pro developers

SELECT request_hash.status,slave.email,request_hash.request_time from slave 
INNER JOIN request_hash  on slave.slave_id= request_hash.slave_id
where request_hash.request_time<NOW() and request_hash.status=1 
ORDER BY `request_hash`.`request_time` DESC