Reply to thread

Message: <blockquote data-quote="Hawkeye" data-source="post: 1175513" data-attributes="member: 11274">The code line you linked to order the items by FileDateCreated not FileDateAdded. I'd vote for using FileDateAdded but that shouldn't be the cause of my problem as the missing episodes are also the latest created ones ...Comparing the code with <a href="https://github.com/damienhaynes/mptvseries/blob/66e851c90b69b8024dfdab7b7e64f2e8b04feaaf/MP-TVSeries/DB%20Classes/DBEpisode.cs#L1664" target="_blank">MPTVSeries one</a> it looks nearly the same. Only differences are the check for SeriesID and Hidden not being 0. But you propably knew that <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink    ;)" loading="lazy" data-shortname=";)" /> ...I've attached log files with SQL verbose option of TVSeries activated. The query executed by LM should be:[CODE=SQL]select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, online_episodes.EpisodeIndex, online_episodes.SeasonIndex, online_episodes.EpisodeName, online_episodes.Watched, online_episodes.PlayCount, online_episodes.LastWatchedDate, online_episodes.FirstWatchedDate, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, online_episodes.lastupdated, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.RatingCount, online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, online_episodes.seasonid, online_episodes.thumb_added, online_episodes.thumb_height, online_episodes.thumb_width, online_episodes.myRating, online_episodes.myRatingAt, local_episodes.EpisodeFilename, local_episodes.OriginalComposite, local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.CompositeUpdated, local_episodes.AvailableSubtitles, local_episodes.OriginalComposite2, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.FileDateAdded as local_episodesFileDateAdded , local_episodes.FileDateCreated, local_episodes.IsAvailable, local_episodes.DateWatched, local_episodes.StopTime, local_episodes.ext, local_episodes.VolumeLabel, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoFormat, local_episodes.VideoFormatProfile, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioFormat, local_episodes.AudioFormatProfile, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.AudioTracks, local_episodes.AudioLanguage, local_episodes.TextCount from online_episodes left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID)  where online_episodes.SeriesID > 0 and online_episodes.Hidden = 0 and online_episodes.Watched != 1 and online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes where local_episodes.CompositeID2 != '') union select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, online_episodes.EpisodeIndex, online_episodes.SeasonIndex, online_episodes.EpisodeName, online_episodes.Watched, online_episodes.PlayCount, online_episodes.LastWatchedDate, online_episodes.FirstWatchedDate, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, online_episodes.lastupdated, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.RatingCount, online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, online_episodes.seasonid, online_episodes.thumb_added, online_episodes.thumb_height, online_episodes.thumb_width, online_episodes.myRating, online_episodes.myRatingAt, local_episodes.EpisodeFilename, local_episodes.OriginalComposite, local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.CompositeUpdated, local_episodes.AvailableSubtitles, local_episodes.OriginalComposite2, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.FileDateAdded as local_episodesFileDateAdded , local_episodes.FileDateCreated, local_episodes.IsAvailable, local_episodes.DateWatched, local_episodes.StopTime, local_episodes.ext, local_episodes.VolumeLabel, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoFormat, local_episodes.VideoFormatProfile, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioFormat, local_episodes.AudioFormatProfile, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.AudioTracks, local_episodes.AudioLanguage, local_episodes.TextCount from online_episodes left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID)  where online_episodes.SeriesID > 0 and online_episodes.Hidden = 0 and online_episodes.Watched != 1 and local_episodes.CompositeID2 != '' order by local_episodesFileDateAdded desc[/CODE]If I execute it in <a href="http://sqlitebrowser.org/" target="_blank">SQLiteBrowser</a> I get the correct results ...</blockquote>

Verification