CREATE TABLE table_11066 ("Name" CLOB, "Club" CLOB, "Date of departure" CLOB, "Replacement" CLOB, "Date of appointment" CLOB)

Name the club with date of appointment of 1 november 2007
SELECT "Club" FROM table_11066 WHERE "Date of appointment" = '1 november 2007'
SELECT "Club" FROM "table_11066" WHERE "Date of appointment" = '1 november 2007'