question: who is the replacement when the date of vacancy is 1 september 2008?
answer: SELECT replaced_by FROM table_name_51 WHERE date_of_vacancy = "1 september 2008"
context: CREATE TABLE table_name_51 (replaced_by VARCHAR, date_of_vacancy VARCHAR)