From b8db6fb555b8d29900015d9829bce1c372b8b1b9 Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@archive.org>
Date: Thu, 25 Jun 2020 18:18:39 -0700
Subject: commented special modes for dump_unextracted_pdf.sql

---
 sql/dump_unextracted_pdf.sql | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'sql/dump_unextracted_pdf.sql')

diff --git a/sql/dump_unextracted_pdf.sql b/sql/dump_unextracted_pdf.sql
index 4d264b9..5c7e7a7 100644
--- a/sql/dump_unextracted_pdf.sql
+++ b/sql/dump_unextracted_pdf.sql
@@ -8,8 +8,11 @@ COPY (
   SELECT row_to_json(cdx)
   FROM grobid
   LEFT JOIN cdx ON grobid.sha1hex = cdx.sha1hex
+  --LEFT JOIN fatcat_file ON grobid.sha1hex = fatcat_file.sha1hex
+  WHERE cdx.sha1hex IS NOT NULL
+  --AND fatcat_file.sha1hex IS NOT NULL
 )
--- TO '/grande/snapshots/dump_unextracted_pdf.2020-06-25.json';
+--TO '/grande/snapshots/dump_unextracted_pdf.2020-06-25.json';
 TO STDOUT
 WITH NULL '';
 
-- 
cgit v1.2.3

