QUERY: (SELECT tmp.*, tt.code, tt.name, tp.code as perf_code, tp.name as perf_name, date_format(tmp.date, '%e,%M,%W') as date_first,  date_format(tmp.time, '%k:%i') as time_column, IF(tp.description='',tp1.description,tp.description) as description, tp.description_full, tp.id_perfomancetype, IF(year(curdate())=year(tmp.date),'',year(tmp.date) ) as year, tt.ves as ves, date_format(tmp.time, '%l:%i %p') as time_column1, datediff(tmp.date, curdate()) as offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id=tmp.theatre_id LEFT JOIN ticket_perfomances tp ON tp.id=tmp.perf_id LEFT JOIN ticket_perfomances tp1 ON tp1.id=tp.id_base WHERE 1=1 AND tt.show2=1  AND tmp.date >=curdate()  AND tmp.id IN (3551485,3553522,3555563,3557593,3559611,3561620,3563620,3565640,3567656,3569584,3569597,3569679,3569688,3569753,3571592,3571605,3571687,3571696,3571764,3573612,3573625,3573707,3573716,3573784,3575533,3575615,3575624,3575692,3577440,3577522,3577531,3577599,3579343,3579425,3579434,3579502,3581242,3581324,3581333,3581401,3583100,3583187,3583194,3583260,3584960,3585047,3585054,3585120,3586817,3586904,3586911,3586977,3588671,3588758,3588765,3588831,3590523,3590610,3590617,3590683,3592372,3592459,3592466,3592532,3594300,3594306,3594410,3594417,3594483,3596296,3596302,3596406,3596413,3596479,3598278,3598284,3598388,3598395,3598461,3600245,3600251,3600355,3600362,3600428,3602197,3602203,3602307,3602314,3602380,3604140,3604146,3604250,3604257,3604323,3606071,3606077,3606181,3606188,3606254,3607994,3608000,3608104,3608111,3608177,3609907,3609913,3610017,3610024,3610090,3611808,3611814,3611918,3611925,3611991,3613737,3613743,3613847,3613854,3613920,3615654,3615660,3615764,3615771,3615837,3617564,3617570,3617674,3617681,3617747,3619468,3619474,3619578,3619585,3619651,3621377,3621481,3621488,3621554,3623272,3623376,3623383,3623449,3625259,3625266,3625332,3627131,3627138,3627204,3628995,3629002,3629068,3630855,3630862,3630928,3632709,3632716,3632782,3634555,3634562,3634628,3636394,3636401,3636467,3638223,3638230,3638296,3640039,3640046,3640112,3641845,3641852,3641918,3643643,3643650,3643716,3645433,3645440,3645506,3647216,3647223,3647289,3648991,3648998,3649064,3650753,3650760,3650826,3652504,3652511,3652577,3654247,3654254,3654320,3655983,3655990,3656056,3657709,3657716,3657782,3659441,3659507,3661172,3661238,3662956,3664664,3666366,3668061,3669744,3671420,3673091,3674750,3676399,3678041,3679678,3681313,3682942,3684565,3686176,3687778,3689376,3690970)) ORDER BY date ASC, ves DESC, time ASC LIMIT 10
ERROR: (#1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id...' at line 1





	Ekaterina Vorontsova (Mezzo soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Ekaterina Vorontsova (Mezzo soprano)

Ekaterina Vorontsova (Mezzo soprano)

In 2017 Ekaterina Vorontsova graduated from the Kazan State Conservatory named after N. Zhiganov (the class of G. Lastovka). At the Opera Studio of the Conservatory she performed Zhenya Komelkova (The Dawns Here Are Quiet by Molchanov) and Malika ( Lakmé by Delibes).

While still a student, she took part in performances of the Tatar State Academic Opera and Ballet Theatre (Kazan) appearing as Mercedes (Carmen), Kate Pinkerton (Madama Butterfly), Alice (Lucia di Lammermoor), Annie, Strawberry woman (Porgy and Bess, in concert).
In September 2017, she joined the Tatar State Academic Opera and Ballet Theatre Opera Company as soloist. In the same year, she debuted as Polina in The Queen of Spades new production (Chaliapin Opera Festival in Kazan).

Her operatic repertoire also included the following parts: Olga (Eugene Onegin by Tchaikovsky), Maddalena (Rigoletto by Verdi), Flora Bervoix (La Traviata by Verdi), Khayat (Jalil by Zhiganov), The Third Lady (Die Zauberflöte).

Ekaterina Vorontsova has collaborated with Kazan State Conservatoire Symphonic Orchestra and Kazan Chamber orchestra “La Primavera”. She took part in festivals such as the Kazan Autumn (with Tatarstan National Symphony Orchestra, conductor Alexander Sladkovsky, 2016) and White Festival in Novosibirsk (recital with Chamber orchestra of Novosibirsk State Philharmonic, conductor Alim Shakhmametiev).

In November 2017, Ekaterina Vorontsova made her Bolshoi Theatre debut as Dorabella (Così fan tutte by Mozart).
Since 2018, she has been a soloist with the Bolshoi Theatre Opera Company.

Repertoire

Dorabella (Così fan tutte by Mozart)
Cherubino (Le Nozze di Figaro by Mozart)
Laura (Iolanta by Tchaikovsky)
Fyodor (Boris Godunov by Mussurgsky)
Paquette (Candide by Bernstein)
Mercedes (Carmen by Bizet)
Modestina (Il Viaggio a Reims by Rossini)
The Little Robber Girl (The Story of Kai and Gerda by Banevich)
The kitchen boy (Rusalka by Dvořák)
Olga (Eugene Onegin by Tchaikovsky)
The Weaver (The Tale of Tsar Saltan by Rimski-Korsakov)
Dido (Dido and Aeneas by Purcell)