X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=bibtex_to_paper;h=a6350eb98caedfecffcac5d9b248c5ac41760660;hb=56c8d8b286ae38e170ce915472f9aa86fabf9fee;hp=77cbffaba17091b288982783821d4567f6935bed;hpb=2f59fd62eb8e444af505e193a9f5f7c77011f7a2;p=bin.git

diff --git a/bibtex_to_paper b/bibtex_to_paper
index 77cbffa..a6350eb 100755
--- a/bibtex_to_paper
+++ b/bibtex_to_paper
@@ -477,6 +477,9 @@ INSERT OR REPLACE INTO bibtex (bibtex_key,file_name,pmid,doi,html) VALUES (?,?,?
 EOF
          select_papers_by_name => <<'EOF',
 SELECT * FROM papers WHERE file_name = ?;
+EOF
+         select_papers_by_pmid => <<'EOF',
+SELECT * FROM papers JOIN bibtex ON papers.file_name = bibtex.file_name WHERE bibtex.pmid = ?;
 EOF
          select_papers_by_name_like => <<'EOF',
 SELECT * FROM papers WHERE file_name LIKE ?;