[mythtv-users] what is mythcommflag doing?

[Cedar McKay]

>Try running this query instead and see if it returns any rows:
>
>SELECT recorded.chanid,starttime,endtime,title,subtitle,
>		description,channel.channum,channel.callsign,
>		channel.name
>	FROM recorded
>	LEFT JOIN channel ON recorded.chanid = channel.chanid
>	WHERE chanid = 1009
>		AND starttime = 20030419200000;
>
>
>  
>

Here is what I get:

mysql> SELECT 
recorded.chanid,starttime,endtime,title,subtitle,description,channel.channum,channel.callsign,channel.name
    -> FROM recorded
    -> LEFT JOIN channel ON recorded.chanid = channel.chanid
    -> WHERE chanid = 1009
    -> AND starttime = 20030419200000;
ERROR 1052: Column: 'chanid' in where clause is ambiguous

Thanks,
Cedar