Table schema:
CREATE TABLE table_name_47 (result VARCHAR, date VARCHAR)

Question: What was the result of the game from 10 October 2009?
SQL: SELECT result FROM table_name_47 WHERE date = "10 october 2009"