<br><br><div class="gmail_quote">On 7 February 2012 05:59, 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">
Am 06.02.2012 01:46, schrieb Anthony Giggins:<br>
<div class="im">> 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 class="HOEnZb"><font color="#888888">Mario<br>
</font></span><div class="HOEnZb"><div class="h5"><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>Anthony<br></div></div><br>