[mythtv-users] Web based 'cutpoint' editing

[Anthony Giggins]

On 7 February 2012 23:12, Mario Weilguni <roadrunner6 at gmx.at> wrote:

>  Am 06.02.2012 23:19, schrieb Anthony Giggins:
>
>
>
> 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
>
>
> Hmmm... maybe you're right. What query do you propose?
>
> Regards,
> Mario
>
>
> This seems to work


> 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
>        order by size desc
>

Cheers,

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