diff options
author | Munyoki Kilyungi | 2023-05-09 14:48:57 +0300 |
---|---|---|
committer | Munyoki Kilyungi | 2023-05-09 14:48:57 +0300 |
commit | 855e570ea292ad0f97299500693ad742817515a4 (patch) | |
tree | 7e5f357e58c48c422fc65d39facd41267c983849 | |
parent | 986f0481ae7bbd16163e67b209c6ff14eb3bf80f (diff) | |
download | gn-gemtext-855e570ea292ad0f97299500693ad742817515a4.tar.gz |
Add new issue on incorrect pmids
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
-rw-r--r-- | issues/incorrect-pmids.gmi | 44 |
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/ |