diff options
Diffstat (limited to 'issues/incorrect-pmids.gmi')
-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/ |