[mythtv-users] mysql query failing after upgrade to 5.5

[John Marshall]

> one I want). Oh, by the way, the USING(column) is a shorthand for ON
> (table1.column = table2.column). If I'm going to use a nested select,

Right, ON is just more explicit about what is matching, and not 
mysql-specific.  And I think you already had a nested select, since the 
R2/C2 clause was in parentheses.  But yeah, I think you could just

   LEFT JOIN recorded AS R2 ON r2.programid = p.programid
   LEFT JOIN channel AS C2
       ON R2.chanid = C2.chanid AND C2.commmethod = -2

Note C2 has to be a left join, too, in that case.  I'm sure there are 
other ways to do it, too, like a (NOT) EXISTS.