[mythtv-users] sanity check of recorded seek?

[Scott & Nicole Harris]

On Thu, 7 Jul 2011, Brian J. Murrell wrote:

> My recordedseek table has 4,975,518 rows in it.  I understand that a
> single recording can produce many rows in this table but still, 5M rows
> seems like much.
>
> Does anyone have a quickie little mysql statement to test that every one
> of those 5M rows is for a currently recorded/stored program?

This is the one I came up with a few years ago....

SELECT recordedseek.chanid, recordedseek.starttime
FROM recordedseek
WHERE NOT EXISTS(
SELECT recorded.chanid, recorded.starttime
FROM recorded
WHERE recorded.chanid = recordedseek.chanid
AND recorded.starttime = recordedseek.starttime);