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 (3534247,3536288,3538272,3538287,3538288,3538292,3538316,3538438,3538441,3538445,3538449,3540296,3540311,3540313,3540315,3540336,3540461,3540465,3540467,3540469,3542367,3542379,3542380,3542387,3542405,3542533,3542536,3542537,3542539,3544424,3544438,3544439,3544446,3544462,3544588,3544594,3544595,3544598,3546464,3546479,3546481,3546482,3546503,3546630,3546633,3546635,3546637,3548502,3548514,3548515,3548522,3548545,3548667,3548671,3548673,3548677,3550532,3550547,3550549,3550552,3550577,3550699,3550701,3550703,3550710,3552586,3552587,3552592,3552614,3552741,3552742,3552744,3552747,3554623,3554625,3554626,3554647,3554773,3554777,3554778,3554785,3556659,3556660,3556665,3556687,3556813,3556816,3556818,3556820,3558685,3558688,3558692,3558717,3558837,3558841,3558842,3558845,3560707,3560726,3560851,3560855,3560856,3560858,3562727,3562852,3562856,3562859,3562865,3564729,3564855,3564858,3564861,3564865,3566750,3566873,3566875,3566876,3566885,3568762,3568885,3568888,3568889,3568892,3570779,3570903,3570908,3570910,3570913,3572787,3572913,3572917,3572919,3572923,3574926,3574930,3574932,3574934,3576833,3576836,3576839,3576842,3578737,3578740,3578741,3578743,3580635,3580639,3580640,3580642,3582505,3582510,3582511,3582513,3584367,3584369,3584370,3584372,3586222,3586226,3586227,3586229,3588078,3588080,3588081,3588083,3589928,3589933,3589934,3589936,3591777,3591779,3591780,3591786,3593624,3593626,3593627,3593629,3595595,3595597,3595600,3595605,3596093,3597586,3597591,3597592,3597596,3598087,3599562,3599568,3599569,3599572,3600063,3601522,3601525,3601527,3601529,3602021,3603470,3603473,3603474,3603482,3603971,3605409,3605411,3605414,3605420,3605907,3607335,3607338,3607339,3607342,3607832,3609253,3609255,3609257,3609263,3609753,3611160,3611165,3611167,3611169,3611661,3613057,3613060,3613064,3613068,3613559,3614981,3614984,3614985,3614988,3615482,3616894,3616899,3616901,3616903,3617397,3617452,3618803,3618805,3618808,3618814,3619303,3619360,3620702,3620705,3620706,3620715,3621205,3621261,3622602,3622604,3622605,3622614,3623103,3623160,3624494,3624497,3624500,3624502,3624996,3625052,3626371,3626374,3626378,3626384,3626872,3626930,3628239,3628242,3628245,3628248,3628742,3628798,3630103,3630104,3630108,3630111,3630602,3630660,3631962,3631963,3631966,3631970,3632461,3632519,3633814,3633816,3633818,3633825,3634312,3634371,3635656,3635659,3635661,3635663,3636155,3636214,3637496,3637498,3637500,3637991,3638050,3639326,3639815,3639874,3641626,3641684,3643430,3643488,3645225,3645282,3647013,3647069,3648792,3648848,3650560,3650619,3652320,3652377,3654067,3654124,3655806,3655864,3657539,3657596,3659260,3659319,3660979,3661044,3662707,3662770,3664421,3664484,3666124,3666187,3667822,3667884,3669507,3669572,3671188,3671251,3672862,3672924,3674526,3674590,3676181,3676244,3677823,3677887,3679464,3679526,3681097,3681160,3682727,3682791,3684354,3684416,3685971,3686035,3687578,3687643,3689182,3689244,3690777,3690840,3692368,3692431,3693950,3694014,3695524,3695589,3697097,3697159,3698649,3698714,3700195,3700257,3701731,3701796,3703265,3703329,3704789,3704854,3706308,3706373,3707820,3707883,3709313,3709378,3710803,3710866,3712288,3712350,3713765,3713827,3715235,3715297,3716697,3716762,3718161,3718223,3719615,3719677,3721059,3721124,3722502,3722566,3723940,3724002,3725368,3725431,3726792,3726854,3728206,3728271,3729616,3729681,3731019,3731082,3732412,3732476,3733798,3733861,3735171,3735236,3736543,3736605,3737905,3737969,3739257,3739321,3740603,3740666,3741939,3742004,3743271,3743334,3744593,3744655,3745908,3745971,3747217,3747280,3748514,3748579,3749806,3749869,3751089,3751152,3752364,3752427,3753629,3753693,3754890,3754953,3756143,3756207,3757398,3757462,3758644,3758708,3759882,3759947,3761117,3761180,3762342,3762405,3763561,3763626,3764778,3764843,3765988,3766053,3767190,3767255,3768387,3768450,3769574,3769638,3769968,3770030,3770357,3770419,3770741,3770805,3771123,3771187,3771504,3771567,3771881,3771945,3772256,3772320,3772629,3772692,3772996,3773061,3773365,3773427,3773734,3773796,3774101,3774163,3774466,3774528,3774829,3774891,3775190,3775252,3775549,3775611,3775906,3775968,3776259,3776321,3776607,3776669,3776959,3777021,3777308,3777370,3777653,3777715,3777993,3778055,3778328,3778390,3778658,3778720,3778983,3779045,3779313,3779375,3779639,3779701,3779960,3780022,3780276,3780338,3780591,3780653,3780902,3780964,3781207,3781269,3781507,3781569,3781804,3781866,3782096,3782158,3782384,3782446,3782667,3782729,3782952,3783014,3783234,3783296,3783513,3783575,3783789,3783851,3784061,3784123,3784332,3784394,3784598,3784660,3784860,3784922,3785118,3785180,3785373,3785435,3785625,3785709,3785959,3786043,3786290,3786374,3786640,3786724,3786986,3787070,3787328,3787412,3787667,3787751,3788002,3788086,3788335,3788419,3788664,3788748,3788990,3789074,3789313,3789397,3789631,3789715,3789947,3790031,3790260,3790344,3790571,3790655,3790878,3790962,3791182,3791266,3791483,3791567,3791780,3791864,3792075,3792159,3792367,3792451,3792656,3792740,3792943,3793027,3793226,3793310,3793505,3793589,3793864,3794137,3794406,3794672,3794936,3795198,3795457,3795711,3795977,3796242,3796504,3796763,3797018,3797268,3797512,3797754,3797992,3798227,3798459,3798690,3798916,3799136,3799355,3799571,3799785,3799996,3800205,3800410,3800613,3800815,3801015,3801212,3801406,3827417,3827757,3828097,3828425,3828753,3829077,3829400,3829720,3830035,3830342,3830645,3835770,3836012,3836252,3836485,3836716,3836976,3837233,3837490,3837744,3837995,3838252,3845806,3845825,3846052,3846071,3846295,3846314,3846534,3846553,3846772,3846791,3847006,3847025,3847235,3847254,3847463,3847482,3847714,3847942,3848166,3848395,3860848,3861645,3862438,3863228,3864016,3864798,3865577,3866355,3867132,3867902,3868672,3869440,3870209,3870972,3871731,3872473,3873220,3873975,3874728,3875478,3876225,3876971,3877714,3878458,3879201,3879941,3880682,3881425,3882169,3882912,3883653,3884392,3885131,3885867,3886602,3887336,3888069,3888800,3889530,3890256,3890978,3891698,3892414,3893131,3893835,3893843,3894558,3894566,3895274,3895282,3895988,3895995,3896695,3896703,3897403,3897410,3898108,3898116,3898809,3898817,3899512,3899519,3900208,3900217,3900927,3900935,3901649,3902362,3903075,3907310,3907998,3908685,3909368,3910045,3910738,3922365,3922388,3923044,3923066,3923722,3923744,3924398,3924420,3925065,3925088,3925731,3925753,3926392,3926415,3927055,3927078,3927714,3927736,3928373,3928396,3929050,3929704,3930353,3931000,3931645,3932286,3932926,3933570,3946385,3947008,3947621,3948230,3948874,3956419,3957042,3957663,3958281,3958894,3959502,3960108,3960705,3961307,3961905,3962492,3963070,3965386,3965970,3966549,3967128,3979900,3980483,3981068,3981645,3982214,3982790,3983348,3983356,3983386,3983920,3983930,3983956,3984499,3984527,3985066,3985090,3985648,3986207,3986762,3987311,3987858,3988401,3988940,3994313,3994314,3994835,3994839,3995354,3995356,3995872,3995875,3996386,3996387,4051533,4052415,4053288,4054159,4055026,4055893,4056756,4057617,4058472,4059324,4060170,4061017,4061857,4062692,4063523,4066047,4066866,4067681,4068495,4069304,4070108,4070905,4071702,4072496,4073287,4074077,4074863,4075647,4076427,4077204,4077977,4094626,4095389,4096148,4096905,4097659,4098413,4099164,4099911,4100660,4101405,4102147,4102887,4103628,4104364,4105099,4105833,4106563,4107289,4108010,4108732,4109450,4110166,4110878,4111590,4112297,4132022,4132023,4132027,4132029,4132693,4132694,4132698,4132699,4133360,4133361,4133366,4133368,4134027,4134028,4134030,4134033,4134690,4134691,4134696,4134697,4135353,4135355,4135357,4135358,4136016,4136021,4137997,4138008,4138014,4138671,4138679,4138687,4139333,4139343,4139351,4139998,4140007,4140015,4140655,4140664,4140673,4141319,4141327,4141972,4141980,4142620,4142628,4143275,4143919)) 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





	Yevgeny Akhmedov (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Yevgeny Akhmedov (Tenor)

Yevgeny Akhmedov (Tenor)

• Prize-winner at the III International Pavel Lisitsian Competition (Vladikavkaz, 2013, 1st prize)
• Diploma recipient at the XV International Tchaikovsky Competition (St. Рetersburg, 2015)

Trained at the Rimsky-Korsakov Saint Petersburg Conservatory under Olga Kondina. Since 2011 he has been a soloist for the Mikhailovsky Theatre where he has sung Lensky (Eugene Onegin), the Novice (Billy Budd), the  Steersman (Der fliegende Holländer), Lykov (The Tsar’s Bride), and Nemorino (L’Elisir d’amore). He was nominated for a Golden Mask National Theatre Award for Best Male Singer, Opera (2014) for his role as Lensky in Andriy Zholdak's production.

In 2014, he made his debut at the Mariinsky, appearing as Lensky in the premiere of a new production of Eugene Onegin.

Since 2015 he has been a member of the Mariinsky Opera.
During the 2016/17 season he was a fellow at Atkins Young Artists Program in Mariinsky.

Repertoire at the Mariinsky theatre includes:
Lensky (Eugene Onegin)
The Simpleton (Boris Godunov)
Lykov (The Tsar’s bride)
Mozart (Mozart and Salieri)
The Fisherman (Le Rossignol)
Don Antonio (Betrothal in a Monastery)
Pechorin (Bela in concert)
Ferranfo (Così fan tutte)
Don Ottavio (Don Giovanni)
Count Almaviva (Il barbiere di Siviglia)
Nemorino (L'elisir d'amore)
Arturo (Lucia di Lammermoor)
Alfredo (La traviata)
Fenton (Falstaff)
Beppe (Pagliacci)
The Abbé de Chazeuil (Adriana Lecouvreur)
Froh (Das Rheingold)
Steersman (Der fliegende Holländer)
Hylas (Les Troyens)
tenor solo in Stravinsky’s Les noces, Pulcinella, Rachmaninoff’s The Bells

Repertoire also includes: Edmondo (Manon Lescaut), Beppe (Pagliacci), Chekalinsky (The Queen of Spades), the Novice (Billy Budd), the tenor roles in Mozart’s Requiem and Britten’s Spring Symphony.

Yevgeny Akhmedov has toured in China, Finland, France, Scotland, England, Italy and Germany.