CREATE TABLE table_name_47 (season VARCHAR, third VARCHAR)

Which Season has a Third of colin hodgson?
SELECT season FROM table_name_47 WHERE third = "colin hodgson"
SELECT "season" FROM "table_name_47" WHERE "colin hodgson" = "third"