• assigned: arthur, bonfacem, pjotrp
• priority: high
• status: closed
• 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/