CREATE TABLE table_204_959 (id NUMBER, "club" CLOB, "founded" NUMBER, "nickname" CLOB, "location" CLOB, "home ground" CLOB, "entered competition" NUMBER, "most recent promotion" NUMBER)

which football club had its most recent promotion a year before the heidelberg football club ?
SELECT "club" FROM table_204_959 WHERE "most recent promotion" = (SELECT "most recent promotion" FROM table_204_959 WHERE "club" = 'heidelberg football club') - 1
SELECT "club" FROM "table_204_959" WHERE "most recent promotion" = (SELECT "most recent promotion" FROM "table_204_959" WHERE "club" = 'heidelberg football club') - 1