[mythtv-users] Web based 'cutpoint' editing

[Mario Weilguni]

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

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