CREATE TABLE table_47 ("Nominative" TEXT, "Old orthography" TEXT, "New orthography" TEXT, "/e/ or /\\u00e6/  ( IPA ) " TEXT, "Tone  ( Latvian notation: /~/ - level ,  /^/ - broken ) " TEXT, "Translation" TEXT)

What is the tone for gen.sing. plague?
SELECT "Tone (Latvian notation: /~/ - level, /^/ - broken)" FROM table_47 WHERE "Translation" = 'Gen.Sing. plague'
SELECT "Tone (Latvian notation: /~/ - level, /^/ - broken)" FROM "table_47" WHERE "Translation" = 'Gen.Sing. plague'