[mythtv-users] Web based 'cutpoint' editing
roadrunner6 at gmx.at
Mon Feb 6 21:59:42 UTC 2012
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
> 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.
Well, having count(1) > 0 is a little pointless, same as where true. How
do you distinguish between series and real "films"?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users