<br><br><div class="gmail_quote">On 7 February 2012 23:12, Mario Weilguni <span dir="ltr"><<a href="mailto:roadrunner6@gmx.at">roadrunner6@gmx.at</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Am 06.02.2012 23:19, schrieb Anthony Giggins:
<div><div class="h5"><blockquote type="cite"><br>
<br>
<div class="gmail_quote">On 7 February 2012 07:59, Mario Weilguni
<span dir="ltr"><<a href="mailto:roadrunner6@gmx.at" target="_blank">roadrunner6@gmx.at</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Am 06.02.2012 22:50,
schrieb Anthony Giggins:
<div>
<div>
<blockquote type="cite"><br>
<br>
<div class="gmail_quote">On 7 February 2012 05:59,
Mario Weilguni <span dir="ltr"><<a href="mailto:roadrunner6@gmx.at" target="_blank">roadrunner6@gmx.at</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Am 06.02.2012 01:46, schrieb Anthony Giggins:<br>
<div>> What is the SQL query that fetches the
Series dropdown list, this<br>
> doesn't quiet look complete?<br>
><br>
<br>
</div>
It's within selectMovie.php<br>
<br>
<br>
select title, count(1) as cnt, sum(filesize) as
size<br>
from recorded r<br>
where transcoded = 0<br>
and deletepending = 0<br>
and not exists (select 1 from
recordedmarkup m where<br>
m.chanid=r.chanid and m.starttime=r.starttime and
m.type in (0,1))";<br>
group by title having count(1) > 1<br>
order by size desc<br>
<br>
Regards<br>
<span><font color="#888888">Mario<br>
</font></span>
<div>
<div><br>
<br>
</div>
</div>
</blockquote>
<div><br>
I'd like to see this set to <br>
group by title having count(1) > 0<br>
<br>
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.<br>
<br>
Cheers,<br>
<br>
</div>
</div>
</blockquote>
<br>
</div>
</div>
Well, having count(1) > 0 is a little pointless, same as
where true. How do you distinguish between series and real
"films"?<br>
<br>
Regards<span><font color="#888888"><br>
Mario</font></span><br>
</div>
</blockquote>
<div><br>
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. <br>
</div>
</div>
<br>
group by title <br>
<br>
is all that is needed<br>
<br>
</blockquote>
<br></div></div>
Hmmm... maybe you're right. What query do you propose?<br>
<br>
Regards,<br>
Mario<br>
<br>
</div>
<br></blockquote><div>This seems to work<br> </div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">select title, count(1) as cnt, sum(filesize) as
size<br>
from recorded r<br>
where transcoded = 0<br>
and deletepending = 0<br>
and not exists (select 1 from
recordedmarkup m where<br>
m.chanid=r.chanid and m.starttime=r.starttime and
m.type in (0,1))";<br>
group by title<br>
order by size desc<br></blockquote></div><br>Cheers,<br><br>Anthony<br>