use prowlr_core;
SELECT
                                SeriesEpisodes.EpisodeID,
                                SeriesEpisodes.SeasonNumber,
                                SeriesEpisodes.EpisodeNumber,
                                SeriesEpisodes.EpisodeName,
                                SeriesEpisodes.FirstAired,
                                SeriesEpisodes.Overview,
                                Series.Network
                        FROM
                                SeriesEpisodes
                        JOIN
                                Series ON SeriesEpisodes.SeriesID = Series.SeriesID
                WHERE
                        SeriesEpisodes.SeriesID = "79488"
                AND
                        FirstAired <= "2010-11-20"
                AND
                        FirstAired NOT LIKE "%-00%"
                AND
                        FirstAired <> ""
                AND
                        SeasonNumber <> "0"
                ORDER BY
                        FirstAired DESC, EpisodeNumber DESC
                LIMIT 1;