CREATE TABLE table_204_23 (id NUMBER, "#" NUMBER, "wrestlers" CLOB, "reign" NUMBER, "date" CLOB, "days held" NUMBER, "location" CLOB, "event" CLOB, "notes" CLOB)

what event comes before hardcore tv # 14 ?
SELECT "event" FROM table_204_23 WHERE id = (SELECT id FROM table_204_23 WHERE "event" = 'hardcore tv #14') - 1
SELECT "event" FROM "table_204_23" WHERE "id" = (SELECT "id" FROM "table_204_23" WHERE "event" = 'hardcore tv #14') - 1