summaryrefslogtreecommitdiff
path: root/issues
diff options
context:
space:
mode:
authorMunyoki Kilyungi2023-05-09 14:48:57 +0300
committerMunyoki Kilyungi2023-05-09 14:48:57 +0300
commit855e570ea292ad0f97299500693ad742817515a4 (patch)
tree7e5f357e58c48c422fc65d39facd41267c983849 /issues
parent986f0481ae7bbd16163e67b209c6ff14eb3bf80f (diff)
downloadgn-gemtext-855e570ea292ad0f97299500693ad742817515a4.tar.gz
Add new issue on incorrect pmids
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'issues')
-rw-r--r--issues/incorrect-pmids.gmi44
1 files changed, 44 insertions, 0 deletions
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/