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 (35535,549510,550953,552388,553811,555228,556635,558037,559434,560826,562213,563594,564964,566327,567689,569040,570387,571727,573105,574477,575839,577197,902660,905292,907909,910523,913134,915765,918469,921162,923841,926532,929249,931958,934665,937370,940101,942819,945524,948226,950932,953632,956322,958999,961653,964293,966929,969561,972189,3460096,3462230,3464358,3466506,3468688,3470852,3473009,3475165,3477318,3479466,3481601,3483736,3485858,3487967,3490074,3490318,3492204,3492449,3494327,3494571,3496441,3496686,3498595,3498839,3500741,3500981,3502873,3503118,3505006,3505247,3507130,3507374,3509249,3509492,3511363,3511608,3513472,3513717,3515568,3515812,3517656,3517901,3519744,3519985,3521820,3522064,3524133,3526197,3528249,3530309,3532351,3534391,3536433,3538461,3540485,3542555,3544613,3546654,3548690,3550721,3552764,3554798,3556835,3558859,3560872,3562876,3564876,3566894,3568909,3570926,3572936,3574948,3576856,3578757,3580657,3582524,3584382,3586241,3588095,3589947,3591795,3593639,3595617,3597612,3599588,3601544,3603494,3605433,3607356,3609276,3611186,3613083,3615003,3616918,3617439,3618827,3619347,3620728,3621248,3622627,3623147,3624518,3625039,3626397,3626918,3628265,3628785,3630124,3630648,3631985,3632507,3633835,3634358,3635680,3636202,3637516,3638037,3639340,3639861,3641150,3641672,3642953,3643476,3644749,3645269,3646534,3647056,3648835,3650607,3652364,3654112,3655851,3657584,3659306,3661030,3662756,3664471,3666174,3667870,3669558,3671237,3672910,3674577,3676230,3677874,3679513,3681147,3682777,3684402,3686022,3687629,3689231,3690826,3692418,3694000,3695575,3697146,3698701,3700244,3701782,3703316,3704841,3706360,3707869,3709365,3710853,3712337,3713813,3715284,3716749,3718209,3719663,3721110,3722553,3723989,3725417,3726840,3728258,3729667,3731068,3732463,3733848,3735222,3736591,3737956,3739308,3740653,3741990,3743321,3744641,3745958,3747266,3748566,3749856,3751138,3752413,3753680,3754939,3756194,3757449,3758695,3759933,3761166,3762391,3763612,3764829,3766039,3767242,3768436,3769624,3770017,3770405,3770791,3771173,3771553,3771932,3772307,3772678,3773048,3773413,3773782,3774150,3774515,3774878,3775239,3775598,3775955,3776308,3776656,3777008,3777357,3777702,3778042,3778377,3778707,3779032,3779362,3779688,3780009,3780325,3780640,3780951,3781256,3781556,3781853,3782145,3782433,3782716,3783001,3783283,3783562,3783838,3784110,3784381,3784647,3784909,3785167,3785422,3785686,3786020,3786351,3786701,3787047,3787389,3787728,3788063,3788396,3788725,3789051,3789374,3789692,3790008,3790321,3790632,3790939,3791243,3791544,3791841,3792136,3792428,3792717,3793004,3793287,3793566,3793841,3794114,3794383,3794649,3794913,3795175,3795434,3795688,3795953,3796218,3796480,3796739,3796994,3797244,3797488,3797730,3797968,3798203,3798435,3798666,3798892,3799112,3799331)) 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





	Larisa Shevchenko (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Larisa Shevchenko (Soprano)

Larisa Shevchenko (Soprano)

Soprano

•People`s Artist of the USSR.
•Recipient of the State Prize of the USSR.
•Prize-winner at the All-Russian Glinka Vocalists? Competition (1975).
•Recipient of many awards at international competitions including the Grand Prix and special audience prize (the Netherlands, 1977) and the gold medal and audience prize at the bel canto competition in Oostende (1978).
•Awarded the Golden Sofit, St Petersburg?s highest theatre prize, in the category Best Opera Role for her interpretation of Turandot in Puccini?s opera of the same name (2003).

Born in Lvov (Ukraine). After graduating from the Leningrad State Rimsky-Korsakov Conservatoire in 1976, she made her Mariinsky Theatre debut as Tatiana in Tchaikovsky?s Eugene Onegin. Mariinsky Theatre soloist from the same year.

Her extensive repertoire includes over thirty roles from Russian and European operas, among them:
Yaroslavna (Prince Igor),
Filippevna (Eugeny Onegin),
Maria (Mazepa),
Lisa (The Queen of Spades),
Akhrosimova (War and Peace),
Katerina Ismailova (Lady Macbeth of Mtsensk),
Amelia (Un ballo in maschera),
Leonora (La forza del destino),
Elisabeth (Don Carlo),
Aida (Aida),
Giorgetta (Il tabarro),
Turandot (Turandot),
Senta (Der Fliegende Hollander),
Ortrude (Lohengrin),
Brьnnhilde (Die Walkure),
Mrs Grose (The turn of the Screw).

In addition to operatic roles, she frequently performs concerts of symphony music. Her concert repertoire is based on works by Beethoven (Ninth Symphony), Mahler (Second Symphony), Shostakovich (Fourteenth Symphony), Mozart (Requiem), Verdi (Requiem) and Britten (War Requiem).

From 1992–1997 she was a soloist with the Bonn Opera, performing as Lisa in Tchaikovsky?s The Queen of Spades (Stage Director: Lyubimov; music revised by Schnittke).
In addition to tours with the Mariinsky Opera Company to Italy, the Netherlands, the USA and Spain, she regularly gives solo concerts. She has performed in Birmingham, Edinburgh, Manchester, Melbourne and throughout Germany.