From 855e570ea292ad0f97299500693ad742817515a4 Mon Sep 17 00:00:00 2001
From: Munyoki Kilyungi
Date: Tue, 9 May 2023 14:48:57 +0300
Subject: Add new issue on incorrect pmids

Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
---
 issues/incorrect-pmids.gmi | 44 ++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 44 insertions(+)
 create mode 100644 issues/incorrect-pmids.gmi

(limited to 'issues')

diff --git a/issues/incorrect-pmids.gmi b/issues/incorrect-pmids.gmi
new file mode 100644
index 0000000..f9e617b
--- /dev/null
+++ b/issues/incorrect-pmids.gmi
@@ -0,0 +1,44 @@
+# Incorrect PubMed IDs in the Publication Table
+
+* assigned: arthur, bonfacem, pjotrp
+* priority: high
+* status: stalled
+* keywords: rdf, sql
+
+Consider the query:
+
+```
+SELECT * FROM PublishXRef WHERE InbredSetId NOT IN (SELECT PublishFreeze.InbredSetId FROM PublishFreeze);
+```
+
+which results in:
+
+```
+*************************** 1. row ***************************
+Id: 5772
+PubMed_ID: 14805
+Abstract: NULL
+Authors: Harenza, J, Muldoon, PP, De Biasi, M, Miles, MF, and Damaj, MI
+Title: Better title here
+Journal: NULL
+Volume: NULL
+Pages: NULL
+Month: NULL
+Year: 2013
+*************************** 2. row ***************************
+Id: 7276
+PubMed_ID: 15792
+Abstract: NULL
+Authors: Williams EG, Andreux P, Houtkooper R, Auwerx J
+Title: Recombinant Inbred BXD Mice as a Model for the Metabolic Syndrome
+Journal: NULL
+Volume: NULL
+Pages: NULL
+Month: NULL
+Year: 2013
+```
+
+The above pmids are off.  Check:
+
+=> https://pubmed.ncbi.nlm.nih.gov/14805/
+=> https://pubmed.ncbi.nlm.nih.gov/15792/
-- 
cgit v1.2.3