[mythtv-users] what is mythcommflag doing?

Chris Pinkham cpinkham at bc2va.org
Sat Nov 22 22:16:20 EST 2003


> >mysql> SELECT  
> >recorded.chanid,starttime,endtime,title,subtitle,description,channel.cha 
> >nnum,channel.callsign,channel.name
> >     -> FROM recorded
> >     -> LEFT JOIN channel ON recorded.chanid = channel.chanid
> >     -> WHERE recorded.chanid = 1009
> >     -> AND starttime = 20030419200000;

> I don't know if anyone is interested, but there is an alternate
> syntax that may be easier to use.  Try:
> 
> select r.chanid,starttime,endtime,title,subtitle,description,
> channum,callsign,name from recorded r, channel c
> where r.chanid = 1009 and starttime = 20030419200000 and
> r.chanid = c.chanid;

What you show is the same format query (without the 'r' and 'c' aliases)
that was in Myth before I modified it.  The new left join makes it so that
it will return results if there are matching entries in recorded but
nothing to join on in channel which is what we need in this scenario.

-- 

Chris



More information about the mythtv-users mailing list