/* rename master files table and add fields to track watchlist of slave user */
RENAME TABLE  `MyVideos110`.`files` TO  `MyVideos110`.`globalfiles` ;
ALTER TABLE  `MyVideos110`.`globalfiles` ADD  `playCount1` INT( 11 ) NULL DEFAULT NULL , ADD  `lastPlayed1` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE  `MyVideos110`.`globalfiles` CHANGE  `playCount`  `playCount0` INT( 11 ) NULL DEFAULT NULL;
ALTER TABLE  `MyVideos110`.`globalfiles` CHANGE  `lastPlayed`  `lastPlayed0` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

/* create files view in master database */
CREATE ALGORITHM=MERGE VIEW `MyVideos110`.`files` AS
SELECT idFile, idPath, strFilename, playCount0 AS playCount, lastPlayed0 AS lastPlayed, dateAdded FROM `MyVideos110`.`globalfiles`;



/* create slave database and the only slave table required */
CREATE DATABASE  `NewUserVideos110`;
USE NewUserVideos110;
CREATE TABLE bookmark ( idBookmark integer primary key AUTO_INCREMENT, idFile integer, timeInSeconds double, totalTimeInSeconds double, thumbNailImage text, player text, playerState text, type integer);
CREATE INDEX ix_bookmark ON bookmark (idFile, type);

/* from here to the end of the paste is creating views in slave database */
CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`files` AS
SELECT idFile, idPath, strFilename, playCount1 AS playCount, lastPlayed1 AS lastPlayed, dateAdded FROM `MyVideos110`.`globalfiles`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`actor_link` AS
SELECT * FROM `MyVideos110`.`actor_link`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`actor` AS
SELECT * FROM `MyVideos110`.`actor`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`art` AS
SELECT * FROM `MyVideos110`.`art`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`country` AS
SELECT * FROM `MyVideos110`.`country`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`country_link` AS
SELECT * FROM `MyVideos110`.`country_link`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`director_link` AS
SELECT * FROM `MyVideos110`.`director_link`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`episode` AS
SELECT * FROM `MyVideos110`.`episode`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`genre` AS
SELECT * FROM `MyVideos110`.`genre`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`genre_link` AS
SELECT * FROM `MyVideos110`.`genre_link`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`movie` AS
SELECT * FROM `MyVideos110`.`movie`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`movielinktvshow` AS
SELECT * FROM `MyVideos110`.`movielinktvshow`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`musicvideo` AS
SELECT * FROM `MyVideos110`.`musicvideo`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`path` AS
SELECT * FROM `MyVideos110`.`path`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`rating` AS
SELECT * FROM `MyVideos110`.`rating`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`seasons` AS
SELECT * FROM `MyVideos110`.`seasons`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`sets` AS
SELECT * FROM `MyVideos110`.`sets`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`settings` AS
SELECT * FROM `MyVideos110`.`settings`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`stacktimes` AS
SELECT * FROM `MyVideos110`.`stacktimes`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`streamdetails` AS
SELECT * FROM `MyVideos110`.`streamdetails`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`studio` AS
SELECT * FROM `MyVideos110`.`studio`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`studio_link` AS
SELECT * FROM `MyVideos110`.`studio_link`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`tag` AS
SELECT * FROM `MyVideos110`.`tag`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`tag_link` AS
SELECT * FROM `MyVideos110`.`tag_link`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`tvshow` AS
SELECT * FROM `MyVideos110`.`tvshow`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`tvshowlinkpath` AS
SELECT * FROM `MyVideos110`.`tvshowlinkpath`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`uniqueid` AS
SELECT * FROM `MyVideos110`.`uniqueid`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`version` AS
SELECT * FROM `MyVideos110`.`version`;

CREATE ALGORITHM=MERGE VIEW `NewUserVideos110`.`writer_link` AS
SELECT * FROM `MyVideos110`.`writer_link`;


CREATE OR REPLACE ALGORITHM=MERGE VIEW `NewUserVideos110`.`movie_view` AS
select
    `NewUserVideos110`.`movie`.`idMovie` AS `idMovie`,
    `NewUserVideos110`.`movie`.`idFile` AS `idFile`,
    `NewUserVideos110`.`movie`.`c00` AS `c00`,
    `NewUserVideos110`.`movie`.`c01` AS `c01`,
    `NewUserVideos110`.`movie`.`c02` AS `c02`,
    `NewUserVideos110`.`movie`.`c03` AS `c03`,
    `NewUserVideos110`.`movie`.`c04` AS `c04`,
    `NewUserVideos110`.`movie`.`c05` AS `c05`,
    `NewUserVideos110`.`movie`.`c06` AS `c06`,
    `NewUserVideos110`.`movie`.`c07` AS `c07`,
    `NewUserVideos110`.`movie`.`c08` AS `c08`,
    `NewUserVideos110`.`movie`.`c09` AS `c09`,
    `NewUserVideos110`.`movie`.`c10` AS `c10`,
    `NewUserVideos110`.`movie`.`c11` AS `c11`,
    `NewUserVideos110`.`movie`.`c12` AS `c12`,
    `NewUserVideos110`.`movie`.`c13` AS `c13`,
    `NewUserVideos110`.`movie`.`c14` AS `c14`,
    `NewUserVideos110`.`movie`.`c15` AS `c15`,
    `NewUserVideos110`.`movie`.`c16` AS `c16`,
    `NewUserVideos110`.`movie`.`c17` AS `c17`,
    `NewUserVideos110`.`movie`.`c18` AS `c18`,
    `NewUserVideos110`.`movie`.`c19` AS `c19`,
    `NewUserVideos110`.`movie`.`c20` AS `c20`,
    `NewUserVideos110`.`movie`.`c21` AS `c21`,
    `NewUserVideos110`.`movie`.`c22` AS `c22`,
    `NewUserVideos110`.`movie`.`c23` AS `c23`,
    `NewUserVideos110`.`movie`.`idSet` AS `idSet`,
    `NewUserVideos110`.`movie`.`userrating` AS `userrating`,
    `NewUserVideos110`.`movie`.`premiered` AS `premiered`,
    `NewUserVideos110`.`sets`.`strSet` AS `strSet`,
    `NewUserVideos110`.`sets`.`strOverview` AS `strSetOverview`,
    `NewUserVideos110`.`files`.`strFilename` AS `strFileName`,
    `NewUserVideos110`.`path`.`strPath` AS `strPath`,
    `NewUserVideos110`.`files`.`playCount` AS `playCount`,
    `NewUserVideos110`.`files`.`lastPlayed` AS `lastPlayed`,
    `NewUserVideos110`.`files`.`dateAdded` AS `dateAdded`,
    `NewUserVideos110`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
    `NewUserVideos110`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`,
    `NewUserVideos110`.`bookmark`.`playerState` AS `playerState`,
    `NewUserVideos110`.`rating`.`rating` AS `rating`,
    `NewUserVideos110`.`rating`.`votes` AS `votes`,
    `NewUserVideos110`.`rating`.`rating_type` AS `rating_type`,
    `NewUserVideos110`.`uniqueid`.`value` AS `uniqueid_value`,
    `NewUserVideos110`.`uniqueid`.`type` AS `uniqueid_type`
from ((((((`NewUserVideos110`.`movie` left join `NewUserVideos110`.`sets` on((`NewUserVideos110`.`sets`.`idSet` = `NewUserVideos110`.`movie`.`idSet`))) join `NewUserVideos110`.`files` on((`NewUserVideos110`.`files`.`idFile` = `NewUserVideos110`.`movie`.`idFile`))) join `NewUserVideos110`.`path` on((`NewUserVideos110`.`path`.`idPath` = `NewUserVideos110`.`files`.`idPath`))) left join `NewUserVideos110`.`bookmark` on(((`NewUserVideos110`.`bookmark`.`idFile` = `NewUserVideos110`.`movie`.`idFile`) and (`NewUserVideos110`.`bookmark`.`type` = 1)))) left join `NewUserVideos110`.`rating` on((`NewUserVideos110`.`rating`.`rating_id` = `NewUserVideos110`.`movie`.`c05`))) left join `NewUserVideos110`.`uniqueid` on((`NewUserVideos110`.`uniqueid`.`uniqueid_id` = `NewUserVideos110`.`movie`.`c09`)));

CREATE OR REPLACE ALGORITHM=MERGE VIEW `NewUserVideos110`.`musicvideo_view` AS
select
    `NewUserVideos110`.`musicvideo`.`idMVideo` AS `idMVideo`,
    `NewUserVideos110`.`musicvideo`.`idFile` AS `idFile`,
    `NewUserVideos110`.`musicvideo`.`c00` AS `c00`,
    `NewUserVideos110`.`musicvideo`.`c01` AS `c01`,
    `NewUserVideos110`.`musicvideo`.`c02` AS `c02`,
    `NewUserVideos110`.`musicvideo`.`c03` AS `c03`,
    `NewUserVideos110`.`musicvideo`.`c04` AS `c04`,
    `NewUserVideos110`.`musicvideo`.`c05` AS `c05`,
    `NewUserVideos110`.`musicvideo`.`c06` AS `c06`,
    `NewUserVideos110`.`musicvideo`.`c07` AS `c07`,
    `NewUserVideos110`.`musicvideo`.`c08` AS `c08`,
    `NewUserVideos110`.`musicvideo`.`c09` AS `c09`,
    `NewUserVideos110`.`musicvideo`.`c10` AS `c10`,
    `NewUserVideos110`.`musicvideo`.`c11` AS `c11`,
    `NewUserVideos110`.`musicvideo`.`c12` AS `c12`,
    `NewUserVideos110`.`musicvideo`.`c13` AS `c13`,
    `NewUserVideos110`.`musicvideo`.`c14` AS `c14`,
    `NewUserVideos110`.`musicvideo`.`c15` AS `c15`,
    `NewUserVideos110`.`musicvideo`.`c16` AS `c16`,
    `NewUserVideos110`.`musicvideo`.`c17` AS `c17`,
    `NewUserVideos110`.`musicvideo`.`c18` AS `c18`,
    `NewUserVideos110`.`musicvideo`.`c19` AS `c19`,
    `NewUserVideos110`.`musicvideo`.`c20` AS `c20`,
    `NewUserVideos110`.`musicvideo`.`c21` AS `c21`,
    `NewUserVideos110`.`musicvideo`.`c22` AS `c22`,
    `NewUserVideos110`.`musicvideo`.`c23` AS `c23`,
    `NewUserVideos110`.`musicvideo`.`userrating` AS `userrating`,
    `NewUserVideos110`.`musicvideo`.`premiered` AS `premiered`,
    `NewUserVideos110`.`files`.`strFilename` AS `strFileName`,
    `NewUserVideos110`.`path`.`strPath` AS `strPath`,
    `NewUserVideos110`.`files`.`playCount` AS `playCount`,
    `NewUserVideos110`.`files`.`lastPlayed` AS `lastPlayed`,
    `NewUserVideos110`.`files`.`dateAdded` AS `dateAdded`,
    `NewUserVideos110`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
    `NewUserVideos110`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`,
    `NewUserVideos110`.`bookmark`.`playerState` AS `playerState`
from (((`NewUserVideos110`.`musicvideo` join `NewUserVideos110`.`files` on((`NewUserVideos110`.`files`.`idFile` = `NewUserVideos110`.`musicvideo`.`idFile`))) join `NewUserVideos110`.`path` on((`NewUserVideos110`.`path`.`idPath` = `NewUserVideos110`.`files`.`idPath`))) left join `NewUserVideos110`.`bookmark` on(((`NewUserVideos110`.`bookmark`.`idFile` = `NewUserVideos110`.`musicvideo`.`idFile`) and (`NewUserVideos110`.`bookmark`.`type` = 1))));

CREATE OR REPLACE ALGORITHM=MERGE VIEW `NewUserVideos110`.`episode_view` AS
select
    `NewUserVideos110`.`episode`.`idEpisode` AS `idEpisode`,
    `NewUserVideos110`.`episode`.`idFile` AS `idFile`,
    `NewUserVideos110`.`episode`.`c00` AS `c00`,
    `NewUserVideos110`.`episode`.`c01` AS `c01`,
    `NewUserVideos110`.`episode`.`c02` AS `c02`,
    `NewUserVideos110`.`episode`.`c03` AS `c03`,
    `NewUserVideos110`.`episode`.`c04` AS `c04`,
    `NewUserVideos110`.`episode`.`c05` AS `c05`,
    `NewUserVideos110`.`episode`.`c06` AS `c06`,
    `NewUserVideos110`.`episode`.`c07` AS `c07`,
    `NewUserVideos110`.`episode`.`c08` AS `c08`,
    `NewUserVideos110`.`episode`.`c09` AS `c09`,
    `NewUserVideos110`.`episode`.`c10` AS `c10`,
    `NewUserVideos110`.`episode`.`c11` AS `c11`,
    `NewUserVideos110`.`episode`.`c12` AS `c12`,
    `NewUserVideos110`.`episode`.`c13` AS `c13`,
    `NewUserVideos110`.`episode`.`c14` AS `c14`,
    `NewUserVideos110`.`episode`.`c15` AS `c15`,
    `NewUserVideos110`.`episode`.`c16` AS `c16`,
    `NewUserVideos110`.`episode`.`c17` AS `c17`,
    `NewUserVideos110`.`episode`.`c18` AS `c18`,
    `NewUserVideos110`.`episode`.`c19` AS `c19`,
    `NewUserVideos110`.`episode`.`c20` AS `c20`,
    `NewUserVideos110`.`episode`.`c21` AS `c21`,
    `NewUserVideos110`.`episode`.`c22` AS `c22`,
    `NewUserVideos110`.`episode`.`c23` AS `c23`,
    `NewUserVideos110`.`episode`.`idShow` AS `idShow`,
    `NewUserVideos110`.`episode`.`userrating` AS `userrating`,
    `NewUserVideos110`.`episode`.`idSeason` AS `idSeason`,
    `NewUserVideos110`.`files`.`strFilename` AS `strFileName`,
    `NewUserVideos110`.`path`.`strPath` AS `strPath`,
    `NewUserVideos110`.`files`.`playCount` AS `playCount`,
    `NewUserVideos110`.`files`.`lastPlayed` AS `lastPlayed`,
    `NewUserVideos110`.`files`.`dateAdded` AS `dateAdded`,
    `NewUserVideos110`.`tvshow`.`c00` AS `strTitle`,
    `NewUserVideos110`.`tvshow`.`c08` AS `genre`,
    `NewUserVideos110`.`tvshow`.`c14` AS `studio`,
    `NewUserVideos110`.`tvshow`.`c05` AS `premiered`,
    `NewUserVideos110`.`tvshow`.`c13` AS `mpaa`,
    `NewUserVideos110`.`bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
    `NewUserVideos110`.`bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`,
    `NewUserVideos110`.`bookmark`.`playerState` AS `playerState`,
    `NewUserVideos110`.`rating`.`rating` AS `rating`,
    `NewUserVideos110`.`rating`.`votes` AS `votes`,
    `NewUserVideos110`.`rating`.`rating_type` AS `rating_type`,
    `NewUserVideos110`.`uniqueid`.`value` AS `uniqueid_value`,
    `NewUserVideos110`.`uniqueid`.`type` AS `uniqueid_type`
from (((((((`NewUserVideos110`.`episode` join `NewUserVideos110`.`files` on((`Testuser110`.`files`.`idFile` = `NewUserVideos110`.`episode`.`idFile`))) join `NewUserVideos110`.`tvshow` on((`NewUserVideos110`.`tvshow`.`idShow` = `NewUserVideos110`.`episode`.`idShow`))) join `NewUserVideos110`.`seasons` on((`NewUserVideos110`.`seasons`.`idSeason` = `NewUserVideos110`.`episode`.`idSeason`))) join `NewUserVideos110`.`path` on((`Testuser110`.`files`.`idPath` = `NewUserVideos110`.`path`.`idPath`))) left join `NewUserVideos110`.`bookmark` on(((`NewUserVideos110`.`bookmark`.`idFile` = `NewUserVideos110`.`episode`.`idFile`) and (`NewUserVideos110`.`bookmark`.`type` = 1)))) left join `NewUserVideos110`.`rating` on((`NewUserVideos110`.`rating`.`rating_id` = `NewUserVideos110`.`episode`.`c03`))) left join `NewUserVideos110`.`uniqueid` on((`NewUserVideos110`.`uniqueid`.`uniqueid_id` = `NewUserVideos110`.`episode`.`c20`)));


CREATE OR REPLACE ALGORITHM=MERGE VIEW `NewUserVideos110`.`tvshowcounts` AS
select
    `NewUserVideos110`.`tvshow`.`idShow` AS `idShow`,
    max(`NewUserVideos110`.`files`.`lastPlayed`) AS `lastPlayed`,
    nullif(count(`NewUserVideos110`.`episode`.`c12`),0) AS `totalCount`,
    count(`NewUserVideos110`.`files`.`playCount`) AS `watchedcount`,
    nullif(count(distinct `NewUserVideos110`.`episode`.`c12`),0) AS `totalSeasons`,
    max(`NewUserVideos110`.`files`.`dateAdded`) AS `dateAdded`
from ((`NewUserVideos110`.`tvshow` left join `NewUserVideos110`.`episode` on((`NewUserVideos110`.`episode`.`idShow` = `NewUserVideos110`.`tvshow`.`idShow`))) left join `NewUserVideos110`.`files` on((`NewUserVideos110`.`files`.`idFile` = `NewUserVideos110`.`episode`.`idFile`))) group by `NewUserVideos110`.`tvshow`.`idShow`;

CREATE OR REPLACE ALGORITHM=MERGE VIEW `NewUserVideos110`.`tvshow_view` AS
select
    `NewUserVideos110`.`tvshow`.`idShow` AS `idShow`,
    `NewUserVideos110`.`tvshow`.`c00` AS `c00`,
    `NewUserVideos110`.`tvshow`.`c01` AS `c01`,
    `NewUserVideos110`.`tvshow`.`c02` AS `c02`,
    `NewUserVideos110`.`tvshow`.`c03` AS `c03`,
    `NewUserVideos110`.`tvshow`.`c04` AS `c04`,
    `NewUserVideos110`.`tvshow`.`c05` AS `c05`,
    `NewUserVideos110`.`tvshow`.`c06` AS `c06`,
    `NewUserVideos110`.`tvshow`.`c07` AS `c07`,
    `NewUserVideos110`.`tvshow`.`c08` AS `c08`,
    `NewUserVideos110`.`tvshow`.`c09` AS `c09`,
    `NewUserVideos110`.`tvshow`.`c10` AS `c10`,
    `NewUserVideos110`.`tvshow`.`c11` AS `c11`,
    `NewUserVideos110`.`tvshow`.`c12` AS `c12`,
    `NewUserVideos110`.`tvshow`.`c13` AS `c13`,
    `NewUserVideos110`.`tvshow`.`c14` AS `c14`,
    `NewUserVideos110`.`tvshow`.`c15` AS `c15`,
    `NewUserVideos110`.`tvshow`.`c16` AS `c16`,
    `NewUserVideos110`.`tvshow`.`c17` AS `c17`,
    `NewUserVideos110`.`tvshow`.`c18` AS `c18`,
    `NewUserVideos110`.`tvshow`.`c19` AS `c19`,
    `NewUserVideos110`.`tvshow`.`c20` AS `c20`,
    `NewUserVideos110`.`tvshow`.`c21` AS `c21`,
    `NewUserVideos110`.`tvshow`.`c22` AS `c22`,
    `NewUserVideos110`.`tvshow`.`c23` AS `c23`,
    `NewUserVideos110`.`tvshow`.`userrating` AS `userrating`,
    `NewUserVideos110`.`tvshow`.`duration` AS `duration`,
    `NewUserVideos110`.`path`.`idParentPath` AS `idParentPath`,
    `NewUserVideos110`.`path`.`strPath` AS `strPath`,
    `NewUserVideos110`.`tvshowcounts`.`dateAdded` AS `dateAdded`,
    `NewUserVideos110`.`tvshowcounts`.`lastPlayed` AS `lastPlayed`,
    `NewUserVideos110`.`tvshowcounts`.`totalCount` AS `totalCount`,
    `NewUserVideos110`.`tvshowcounts`.`watchedcount` AS `watchedcount`,
    `NewUserVideos110`.`tvshowcounts`.`totalSeasons` AS `totalSeasons`,
    `NewUserVideos110`.`rating`.`rating` AS `rating`,
    `NewUserVideos110`.`rating`.`votes` AS `votes`,
    `NewUserVideos110`.`rating`.`rating_type` AS `rating_type`,
    `NewUserVideos110`.`uniqueid`.`value` AS `uniqueid_value`,
    `NewUserVideos110`.`uniqueid`.`type` AS `uniqueid_type`
from (((((`NewUserVideos110`.`tvshow` left join `NewUserVideos110`.`tvshowlinkpath` on((`NewUserVideos110`.`tvshowlinkpath`.`idShow` = `NewUserVideos110`.`tvshow`.`idShow`))) left join `NewUserVideos110`.`path` on((`NewUserVideos110`.`path`.`idPath` = `NewUserVideos110`.`tvshowlinkpath`.`idPath`))) join `NewUserVideos110`.`tvshowcounts` on((`NewUserVideos110`.`tvshow`.`idShow` = `NewUserVideos110`.`tvshowcounts`.`idShow`))) left join `NewUserVideos110`.`rating` on((`NewUserVideos110`.`rating`.`rating_id` = `NewUserVideos110`.`tvshow`.`c04`))) left join `NewUserVideos110`.`uniqueid` on((`NewUserVideos110`.`uniqueid`.`uniqueid_id` = `NewUserVideos110`.`tvshow`.`c12`))) group by `NewUserVideos110`.`tvshow`.`idShow`;


CREATE OR REPLACE ALGORITHM=MERGE VIEW `NewUserVideos110`.`season_view` AS
select
    `NewUserVideos110`.`seasons`.`idSeason` AS `idSeason`,
    `NewUserVideos110`.`seasons`.`idShow` AS `idShow`,
    `NewUserVideos110`.`seasons`.`season` AS `season`,
    `NewUserVideos110`.`seasons`.`name` AS `name`,
    `NewUserVideos110`.`seasons`.`userrating` AS `userrating`,
    `NewUserVideos110`.`tvshow_view`.`strPath` AS `strPath`,
    `NewUserVideos110`.`tvshow_view`.`c00` AS `showTitle`,
    `NewUserVideos110`.`tvshow_view`.`c01` AS `plot`,
    `NewUserVideos110`.`tvshow_view`.`c05` AS `premiered`,
    `NewUserVideos110`.`tvshow_view`.`c08` AS `genre`,
    `NewUserVideos110`.`tvshow_view`.`c14` AS `studio`,
    `NewUserVideos110`.`tvshow_view`.`c13` AS `mpaa`,
    count(distinct `NewUserVideos110`.`episode`.`idEpisode`) AS `episodes`,
    count(`NewUserVideos110`.`files`.`playCount`) AS `playCount`,
    min(`NewUserVideos110`.`episode`.`c05`) AS `aired`
from (((`NewUserVideos110`.`seasons` join `NewUserVideos110`.`tvshow_view` on((`NewUserVideos110`.`tvshow_view`.`idShow` = `NewUserVideos110`.`seasons`.`idShow`))) join `NewUserVideos110`.`episode` on(((`NewUserVideos110`.`episode`.`idShow` = `NewUserVideos110`.`seasons`.`idShow`) and (`NewUserVideos110`.`episode`.`c12` = `NewUserVideos110`.`seasons`.`season`)))) join `NewUserVideos110`.`files` on((`NewUserVideos110`.`files`.`idFile` = `NewUserVideos110`.`episode`.`idFile`))) group by `NewUserVideos110`.`seasons`.`idSeason`;