[mythtv-users] sanity check of recorded seek?

[Alex Butcher]

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?

My SQL's a bit rusty, but I make it that:

select distinct * from recordedseek where not exists (select * from recorded
where recordedseek.starttime = recorded.starttime and recordedseek.chanid =
recorded.chanid);

will print any rows from recordedseek that don't have a corresponding entry
in recorded.

Reversing it:

select distinct chanid,starttime,title,subtitle from recorded where not exists (select *
from recordedseek where recordedseek.starttime = recorded.starttime and
recordedseek.chanid = recorded.chanid);

shows recordings without any entries in recordedseek. It seems that this is
normal for DVB "radio" recordings.

> Cheers,
> b.

HTH,
Alex