drop view episodeview;
create view episodeview as select episode.*,files.strFileName as strFileName,
  path.strPath as strPath,files.playCount as playCount,files.lastPlayed as lastPlayed,
  tvshow.c00 as strTitle,tvshow.c14 as strStudio,tvshow.idShow as idShow,
  tvshow.c05 as premiered from episode 
  join files on files.idFile=episode.idFile 
  join tvshowlinkepisode on episode.idepisode=tvshowlinkepisode.idepisode 
  join tvshow on tvshow.idshow=tvshowlinkepisode.idshow 
  join path on files.idPath=path.idPath;
update version set idVersion = 28;