CREATE TABLE table_203_485 (id NUMBER, "year" CLOB, "show" CLOB, "role" CLOB, "notes" CLOB)

the show above left right left
SELECT "show" FROM table_203_485 WHERE id = (SELECT id FROM table_203_485 WHERE "show" = 'left right left') - 1
SELECT "show" FROM "table_203_485" WHERE "id" = (SELECT "id" FROM "table_203_485" WHERE "show" = 'left right left') - 1