diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dump_reingest_spn.sql | 4 |
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-%' |