[mythtv-users] Web based 'cutpoint' editing

Anthony Giggins seven at seven.dorksville.net
Mon Feb 6 21:50:32 UTC 2012


On 7 February 2012 05:59, Mario Weilguni <roadrunner6 at gmx.at> wrote:

> Am 06.02.2012 01:46, schrieb Anthony Giggins:
> > What is the SQL query that fetches the Series dropdown list, this
> > doesn't quiet look complete?
> >
>
> It's within selectMovie.php
>
>
> select title, count(1) as cnt, sum(filesize) as size
>         from recorded r
>        where transcoded = 0
>          and deletepending = 0
>         and not exists (select 1 from recordedmarkup m where
> m.chanid=r.chanid and m.starttime=r.starttime and m.type in (0,1))";
>        group by title having count(1) > 1
>        order by size desc
>
> Regards
> Mario
>
>
>
I'd like to see this set to
 group by title having count(1) > 0

As if you have transcoded an entire series and then another episode appears
you dont see this in the list until the next episode airs.

Cheers,

Anthony
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20120207/f1749f68/attachment.html 


More information about the mythtv-users mailing list