2017-09-17, 08:34
Quote:Boyzie: You are using "seriesSummarize = 1" therefore seriesSummarizeQuery is used, not seriesQuery. So just set "seriesSummarize = 0".When I do it this message appears:
Code:
[series]
seriesTabname = Series
seriesColumns = Title,231,Season,100,Episode,200,lastPlayed,220
seriesQuery = SELECT title,season,episode AS datetime(lastPlayed, 'unixepoch') FROM tvshows JOIN episode_watched USING(idShow) WHERE playCount>0 ORDER BY title,season,episode
seriesSummarizeQuery = SELECT DISTINCT title,season,(SELECT GROUP_CONCAT(episode) FROM episode_watched AS e WHERE e.idShow=episode_watched.idShow AND e.season=episode_watched.season AND e.playCount>0 ORDER by episode) AS episode FROM tvshows JOIN episode_watched USING(idShow) WHERE playCount>0 ORDER BY title,season,episode
seriesSummarize = 0
seriesSummarizeCol = 3
seriesTitleSeasonCols = 1,2
seriesMenu = Copy,Complete
completeFeature = 1