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] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.