CREATE TABLE table_30375 ("Team" CLOB, "Outgoing manager" CLOB, "Manner of departure" CLOB, "Date of vacancy" CLOB, "Replaced by" CLOB, "Date of appointment" CLOB, "Position in table" CLOB)

In football league one, what coach was hired as a replacement on 8 October 2007
SELECT "Replaced by" FROM table_30375 WHERE "Date of vacancy" = '8 October 2007'
SELECT "Replaced by" FROM "table_30375" WHERE "Date of vacancy" = '8 October 2007'