SELECT tv.inetref, tv.title, tv.season, COUNT(DIstinct tv.intid),
        fanart.fanart, coverart.coverfile, banner.banner
FROM videometadata tv
   LEFT OUTER JOIN videometadata fanart ON fanart.inetref = tv.inetref
            AND fanart.fanart != "" AND fanart.season = tv.season
   LEFT OUTER JOIN videometadata coverart ON coverart.inetref = tv.inetref
            AND coverart.coverfile != "" AND coverart.season = tv.season
   LEFT OUTER JOIN videometadata banner ON banner.inetref = tv.inetref
            AND banner.banner != "" AND banner.season = tv.season
WHERE tv.contenttype = "TELEVISION" AND tv.inetref != '00000000'
GROUP BY tv.inetref, tv.season