aboutsummaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/dump_reingest_spn.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/dump_reingest_spn.sql b/sql/dump_reingest_spn.sql
index a8ed72f..6ef08c1 100644
--- a/sql/dump_reingest_spn.sql
+++ b/sql/dump_reingest_spn.sql
@@ -4,8 +4,8 @@ COPY (
LEFT JOIN ingest_file_result ON ingest_file_result.base_url = ingest_request.base_url
WHERE ingest_request.ingest_type = 'pdf'
AND ingest_file_result.hit = false
- AND ingest_request.created < NOW() - '2 hour'::INTERVAL
- AND ingest_request.created > NOW() - '31 day'::INTERVAL
+ AND ingest_request.created < NOW() - '6 hour'::INTERVAL
+ AND ingest_request.created > NOW() - '180 day'::INTERVAL
AND ingest_request.ingest_request_source = 'savepapernow-web'
AND (
ingest_file_result.status like 'spn2-%'