[mythtv-users] Web based 'cutpoint' editing

[Mario Weilguni]

Am 06.02.2012 22:50, schrieb Anthony Giggins:
>
>
> On 7 February 2012 05:59, Mario Weilguni <roadrunner6 at gmx.at 
> <mailto: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,
>

Well, having count(1) > 0 is a little pointless, same as where true. How 
do you distinguish between series and real "films"?

Regards
Mario



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20120206/9856ea86/attachment.html