On 14/08/14 09:13, Karl Newman wrote: > ND C.commmethod != -2) LEFT JOIN (recorded AS R2 I can't exactly duplicate your experience because of missing categories in my EPG but my reading of MTSQL manual seems to indicate that that LEFT JOIN of your should be LEFT OUTER JOIN HTH Regards Tony Sauri