SELECT job,time_stamp,host_name,ip_address,server 
FROM cf_status_log WHERE job LIKE 'trans01' ESCAPE '!' 
AND host_name LIKE '%' ESCAPE '!' 
AND ip_address LIKE '%' ESCAPE '!' 
AND server LIKE '%' ESCAPE '!'  AND time_stamp > '2014-03-12 19:00:12-0400'::timestamp 
AND time_stamp < ( '2014-03-12 19:00:12-0400'::timestamp 
+ interval '60 minute' ) 
ORDER BY job desc,time_stamp desc 
LIMIT 1000 ;