SELECT title, inetref, season, MAX(episode), fanart, banner, coverfile
FROM videometadata
WHERE inetref != '00000000' AND contenttype = "TELEVISION" AND fanart != ""
GROUP BY inetref, season, fanart, banner, coverfile
ORDER BY title, season, MAX(episode)