user: ### NOW ANSWER:
Question: What years did Marienhof run, which featured Leonore Capell and lasted 10 years?
Columns: ['Actor', 'Character', 'Soap Opera', 'Years', 'Duration']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Andrea Spatzek', 'Gabi Zenker', 'Lindenstraße', '1985—', '29 years']
SQL:

assistant: SELECT "Years" FROM "Table" WHERE "Soap Opera" = 'Marienhof' AND "Duration" = '10 years' AND "Actor" = 'Leonore Capell';