SELECT * FROM saved_searches AS saved_searches JOIN system_users as sys_users ON saved_searches.system_user_id = sys_users.system_user_id WHERE saved_searches.email_changes = 1 AND (1508659438-saved_searches.last_email_ts) > (sys_users.email_frequency * 86400)

NEw query
SELECT * FROM listing_headers AS hdr JOIN trailers_residential as tr ON hdr.listing_header_id = tr.listing_header_id WHERE 1 AND status = 'Active' AND (flexiss_status != 'oe' OR listing_office_id = '600' OR listing_agent_id = '2838') AND hdr.list_price >= 0 AND hdr.list_price <= 999999999 AND tr.number_bedrooms >= 0 AND tr.number_bedrooms <= 999999999 AND tr.number_bathrooms >= 5 AND tr.number_bathrooms <= 7 AND tr.approximate_total_sf >= 0 AND tr.approximate_total_sf <= 999999999 AND tr.approximate_total_acres >= 0 AND tr.approximate_total_acres <= 999999999 AND ( hdr.zip = '81420' OR hdr.zip = '81401' OR hdr.zip = '81402' OR hdr.zip = '81422' OR hdr.zip = '81423' OR hdr.zip = '81424' OR hdr.zip = '81425' OR hdr.zip = '81427' OR hdr.zip = '81428' OR hdr.zip = '81430' OR hdr.zip = '81432' OR hdr.zip = '81433' OR hdr.zip = '81434' OR hdr.zip = '81435' ) AND board_name = 'cren' AND (hdr.doa_ts > 1405944805) AND (hdr.doa_ts < 1508659438) ORDER BY hdr.list_price DESC


NEw query
SELECT * FROM listing_headers AS hdr JOIN trailers_residential as tr ON hdr.listing_header_id = tr.listing_header_id WHERE 1 AND status = 'Active' AND (flexiss_status != 'oe' OR listing_office_id = '1026' OR listing_agent_id = '1108') AND hdr.list_price >= 300000 AND hdr.list_price <= 500000 AND tr.number_bedrooms >= 4 AND tr.number_bedrooms <= 999999999 AND tr.number_bathrooms >= 3 AND tr.number_bathrooms <= 999999999 AND tr.approximate_total_sf >= 2500 AND tr.approximate_total_sf <= 999999999 AND tr.approximate_total_acres >= .5 AND tr.approximate_total_acres <= 999999999 AND ( hdr.zip = '81520' OR hdr.zip = '81624' OR hdr.zip = '81630' OR hdr.zip = '81521' OR hdr.zip = '81523' OR hdr.zip = '81501' OR hdr.zip = '81502' OR hdr.zip = '81503' OR hdr.zip = '81504' OR hdr.zip = '81505' OR hdr.zip = '81506' OR hdr.zip = '81524' OR hdr.zip = '81525' OR hdr.zip = '81641' OR hdr.zip = '81643' OR hdr.zip = '81646' OR hdr.zip = '81526' OR hdr.zip = '81635' OR hdr.zip = '81648' OR hdr.zip = '81527' ) AND board_name = 'cren' AND (hdr.doa_ts > 1399991900) AND (hdr.doa_ts < 1508659438) ORDER BY hdr.list_price DESC


NEw query
SELECT * FROM listing_headers AS hdr JOIN trailers_residential as tr ON hdr.listing_header_id = tr.listing_header_id WHERE 1 AND status = 'Active' AND (flexiss_status != 'oe' OR listing_office_id = '1026' OR listing_agent_id = '1108') AND hdr.list_price >= 100000 AND hdr.list_price <= 500000 AND tr.number_bedrooms >= 4 AND tr.number_bedrooms <= 6 AND tr.number_bathrooms >= 0 AND tr.number_bathrooms <= 999999999 AND tr.approximate_total_sf >= 0 AND tr.approximate_total_sf <= 999999999 AND tr.approximate_total_acres >= 0 AND tr.approximate_total_acres <= 999999999 AND ( hdr.zip = '81520' OR hdr.zip = '81624' OR hdr.zip = '81630' OR hdr.zip = '81521' OR hdr.zip = '81523' OR hdr.zip = '81501' OR hdr.zip = '81502' OR hdr.zip = '81503' OR hdr.zip = '81504' OR hdr.zip = '81505' OR hdr.zip = '81506' OR hdr.zip = '81524' OR hdr.zip = '81525' OR hdr.zip = '81641' OR hdr.zip = '81643' OR hdr.zip = '81646' OR hdr.zip = '81526' OR hdr.zip = '81635' OR hdr.zip = '81648' OR hdr.zip = '81527' ) AND ( hdr.area = 'Redlands') AND board_name = 'cren' AND (hdr.doa_ts > 0) AND (hdr.doa_ts < 1508659438) ORDER BY hdr.list_price DESC


NEw query
AND (hdr.doa_ts > 0) AND (hdr.doa_ts < 1508659438) ORDER BY

Couldn't process query: AND (hdr.doa_ts > 0) AND (hdr.doa_ts < 1508659438) ORDER BY