'Get the list of seasons of a show'

def run(self):

    show_obj = Show.find(sickbeard.showList, int(self.indexerid))
    if (not show_obj):
        return _responds(RESULT_FAILURE, msg=u'Show    not    found')
    main_db_con = db.DBConnection(row_type=u'dict')
    if (self.sort == u'asc'):
        sql_results = main_db_con.select(u'SELECT    DISTINCT    season    FROM    tv_episodes    WHERE    showid    =    ?    ORDER    BY    season    ASC', [self.indexerid])
    else:
        sql_results = main_db_con.select(u'SELECT    DISTINCT    season    FROM    tv_episodes    WHERE    showid    =    ?    ORDER    BY    season    DESC', [self.indexerid])
    season_list = []
    for row in sql_results:
        season_list.append(int(row['season']))
    return _responds(RESULT_SUCCESS, season_list)
