CREATE TABLE table_21817 ("Season" CLOB, "Timeslot" CLOB, "Premiere" CLOB, "Finale" CLOB, "TV season" CLOB, "Ranking" CLOB, "Viewers  ( in millions ) " CLOB)

What seasons had a ranking of #47?
SELECT "Season" FROM table_21817 WHERE "Ranking" = '#47'
SELECT "Season" FROM "table_21817" WHERE "Ranking" = '#47'