[mythtv-users] Web based 'cutpoint' editing

Anthony Giggins seven at seven.dorksville.net
Mon Feb 6 22:19:07 UTC 2012


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

>  Am 06.02.2012 22:50, schrieb Anthony Giggins:
>
>
>
> 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,
>
>
> Well, having count(1) > 0 is a little pointless, same as where true. How
> do you distinguish between series and real "films"?
>
> Regards
> Mario
>

Agree'd, I dont see there to be a need to distinguish although films wont
have a subtitle but once you transcode them they wouldn't show in the list
either.

group by title

is all that is needed

Cheers,

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


More information about the mythtv-users mailing list