CREATE TABLE table_59319 ("Date" CLOB, "Time" CLOB, "Opponent#" CLOB, "Rank #" CLOB, "Result" CLOB, "Attendance" CLOB)

What was the rank# of the opponent when the result of the game was w42-14?
SELECT "Rank #" FROM table_59319 WHERE "Result" = 'w42-14'
SELECT "Rank #" FROM "table_59319" WHERE "Result" = 'w42-14'