CREATE TABLE table_203_485 (id DECIMAL, "year" TEXT, "show" TEXT, "role" TEXT, "notes" TEXT)

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