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 (3098215,3099796,3101366,3102926,3104472,3106009,3107562,3109141,3110710,3112268,3113817,3115350,3116870,3118385,3119895,3121398,3122927,3124623,3126309,3127983,3129647,3131303,3132950,3134590,3136230,3137863,3139484,3141096,3142700,3144294,3145884,3147464,3148100,3148730,3149354,3149978,3151525,3153064,3154597,3156120,3157636,3159143,3160637,3162122,3163600,3165072,3166556,3167956,3169350,3170735,3172112,3173483,3174847,3176249,3177647,3179040,3180512,3181980,3183442,3184907,3186368,3187825,3189276,3190722,3192163,3193604,3195295,3197080,3199056,3201017,3202716,3204408,3206099,3207786,3209466,3211139,3212858,3214562,3216258,3217951,3219640,3221318,3222990,3224655,3226285,3227900,3229517,3231141,3232756,3234365,3235964,3237548,3239118,3240685,3242289,3243879,3245461,3247064,3248650,3250219,3251784,3253388,3255006,3257017,3259028,3261023,3263008,3264988,3266967,3268782,3268951,3270828,3271019,3272958,3273144,3275068,3275255,3277161,3277348,3279249,3279439,3281384,3281570,3283510,3283701,3285633,3285819,3287783,3287969,3289914,3290105,3292032,3292220,3294136,3294324,3296235,3296426,3298329,3298517,3300413,3300604,3302491,3302678,3304554,3304742,3306600,3306791,3308646,3308838,3310687,3310878,3312721,3312910,3314743,3314926,3316751,3316940,3318754,3318940,3320740,3320926,3322726,3322911,3324874,3325060,3327141,3327330,3329530,3329716,3331913,3332097,3334279,3334463,3336628,3336817,3338978,3339166,3341322,3341508,3343658,3343844,3346201,3348555,3350893,3353213,3355534,3357865,3360208,3362572,3364923,3367265,3369596,3371919,3374236,3376550,3378854,3381154,3383423,3385706,3387973,3390233,3392484,3394721,3396944,3399158,3401362,3403554)) 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





	Tatiana Starkova (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Tatiana Starkova (Soprano)

Tatiana Starkova (Soprano)

• Prize-winner at the IX and X International Rimsky-Korsakov Young Opera Singers’ Competition (1st prize, Tikhvin, 2015, 2016)
• Prize-winner at the All-Russian Competition of Graduate Vocalists of Russian Higher Music Institutes ( 2nd prize, St Petersburg 2014)

Born in Novosibirsk. In 2009 she graduated from the Perm College of Music, having specialised in piano and vocals. Trained at the faculty of solo singing at the Perm State Academy of Art and Culture (class of Olga Liyka, a soloist of the Perm Opera and Ballet Theatre). In 2012 she was accepted into the Mariinsky Academy of Young Opera Singers.

Repertoire at the Mariinsky Theatre: 
Anna Bolena (Anna Bolena
Fiordiligi (Così fan tutte)
Fedora Romazov (Fedora in concert) 
the Princess (Rusalka by Dvořák) 
Yadviga Zapolska (Pan Voyevoda in concert) 
Maddalena (Maddalena
the Mother (The Christmas Tree
the Mother (Scenes from the Life of Nikolenka Irtenev)

In 2018, Tatiana Starkova performed the role of Manon Lescaut and Aida at the Mariinsky Theatre branch in Vladikavkaz.

Together with soloists of the Academy she appears in subscription series concert programmes as well as a series of concert performances of Soviet operas including Into the Storm by Khrennikov and Colas Breugnon by Kabalevsky (Jacqueline). The soloist’s repertoire includes the roles of Zemfira (Aleko), Leonora (Il trovatore), Tatiana (Eugene Onegin), Oxana (Christmas Eve), Natasha (Khrennikov’s Into the Storm), Natalia (Dzerzhinsky’s Quiet Flows the Don). 
Has toured to the China, Russia.