Ella,

Try this one:

use yourdatasource
select mr.renditionnumber
from mediamaster mm inner join mediarenditions mr on mm.mediamasterid = mr.mediamasterid
where mm.mediamasterid not in
 (select mediamasterid
from mediaxrefs)

And yes, we have some orphaned media records laying around!

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Ella Rothgangel
Sent: Monday, May 23, 2016 4:28 PM
To: [log in to unmask]
Subject: broken media links

Has anyone figured out a view, script, report, or query to see only media records where the link has been broken?


Ella Rothgangel
Acting Head of Registration
Saint Louis Art Museum
314.655.5408

To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.