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 (3482371,3484498,3486616,3488726,3490859,3490994,3491005,3492985,3493120,3493131,3495105,3495240,3495251,3497262,3497397,3497408,3499409,3499544,3499555,3501549,3501684,3501695,3503681,3503817,3503828,3505809,3505945,3505956,3507932,3508068,3508079,3510048,3510184,3510195,3512160,3512296,3512307,3514262,3514398,3514409,3516356,3516492,3516503,3518443,3518579,3518590,3520529,3520664,3520677,3522603,3522738,3522751,3524671,3524812,3524825,3526727,3526868,3526881,3528792,3528933,3528946,3530844,3530985,3530998,3532886,3533027,3533040,3534926,3535067,3535080,3536959,3537101,3537114,3538985,3539127,3539140,3541024,3541166,3541179,3543085,3543227,3543240,3545133,3545275,3545288,3547171,3547313,3547326,3549205,3549348,3549361,3551247,3551390,3551403,3553284,3553427,3553440,3555325,3555468,3555481,3557498,3557511,3559516,3559529,3561525,3561538,3563525,3563538,3565545,3565558,3567561,3567574,3569584,3569597,3571592,3571605,3573612,3573625,3575533,3577440,3579343,3581242,3583100,3584960,3586817,3588671,3590523,3592372,3594300,3594306,3596296,3596302,3598278,3598284,3600245,3600251,3602197,3602203,3604140,3604146,3606071,3606077,3607994,3608000,3609907,3609913,3611808,3611814,3613737,3613743,3615654,3615660,3617564,3617570,3619468,3619474,3621377,3623272)) 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





	Evgenia Muravieva (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Evgenia Muravieva (Soprano)

Evgenia Muravieva (Soprano)

Born in St Petersburg (Russia), Evgenia Muravieva graduated from the St Petersburg State Rimsky-Korsakov Conservatoire in 2008 (class of Prof. Irina Bogacheva). While a student Evgenia made her debut as Tatiana in Eugene Onegin by Tchaikovsky at the Rimsky-Korsakov Opera and Ballet Theater.

In 2007-2011 she was a soloist with the Mariinsky Academy of Young Opera Singers.

In 2009 she appeared at the Mariinsky Theater as Pannochka in May Night by N. Rimskiy-Korsakov, followed by the role of the First Dame in Die Zauberflöte by W.A. Mozart.
Her recent repertoire at the Mariinsky includes the title part in Salome, Gutruna (Götterdämmerung), Countes Almaviva (Le nozze di Figaro), Lyubka (Semyon Kotko), Liza (The Queen of Spades), Natalia (The Oprichnik), Tatiana (Eugene Onegin).

In 2010-2014 as a soloist with the St Petersburg Chamber Opera Company she performed the following roles: Tatiana (Eugene Onegin), Mimi (La Boheme), Donna Anna (Don Giovanni), Nedda (I pagliacci), Tosca (Tosca), Liza (The Queen of Spades), Ksenia (Boris Godunov), Cio-Cio-San (Madama Butterfly), Natasha (Not only Love).
Also in the repertoire: Leonora (Il trovatore), Liu (Turandot), Micaela (Carmen).

In 2016 Evgenia debuted at the Komische Oper Berlin in the part of Tatiana (Eugene Onegin).

In August 2017 she made her Salzburg Festival debut as Katerina Lvovna in production of The Lady Macbeth of Mtsensk by Shostakovich (conductor Mariss Jansons, director Andreas Kriegenburg) and received great critical acclaim.

In February 2018 Evgenia Muravieva appeared at the Bolshoi Theatre as Liza in new production of The Queen of Spades (conductor Tugan Sokhiev, director Rimas Tuminas).