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 (211802,213335,214873,216406,217937,219462,220983,222500,224012,225520,227028,477540,477548,479113,479122,480680,480689,481433,481441,482176,482186,482913,482923,483648,483657,484399,484408,485148,485157,485891,485900,486623,486631,487342,487351,488056,488065,488768,488778,489480,489490,490187,490197,490890,490896,491582,491592,492267,492277,492950,492960,493632,493642,494311,494317,494980,494988,495638,495648,496290,496298,496928,496934,498397,498406,499859,499868,501314,501323,502763,502771,504245,504254,505725,505731,507193,507202,508665,508674,510132,510141,511592,511601,513047,513053,514523,514532,515993,516002,517454,517463,518905,518914,520351,520359,521790,521799,523226,523234,524651,524659,526065,526074,527472,527481,528878,528887,530283,530291,531681,531690,533070,533080,534513,534521,535940,535950,537376,537384,538808,538813,540228,540235,541640,541647,543087,543095,544565,544572,546034,546040,547489,547494,548943,548950,550392,550399,551833,551840,553267,553273,554688,554693,556100,556105,557506,557511,558906,558911,560303,560308,561693,561699,563080,563086,564457,564463,565824,565830,567182,567188,568542,568548,569895,569901,571238,571244,572620,572626,574000,574006,575369,575375,576729,576735,578086,578092,579436,579442,580775,580781,582104,582110,583434,583440,584754,584760,586067,586073,587376,587382,588676,588683,590011,590022,591631,591642,593270,593281,594979,594989,596676,596686,598360,598370,600038,600048,601717,601727,603391,603401,605052,605063,606708,606718,608353,608363,609991,610001,611675,611685,613353,613363,615020,615030,616673,616684,618317,618327,619950,619960,621575,621586,623196,623206,624806,624816,626427,626437,628038,628048,629638,629648,631231,631241,632818,632828,634396,634406,635963,635973,637531,639076,3114170,3114181,3115694,3115708,3117212,3117226,3118720,3118734,3120230,3120244,3121732,3121746,3123335,3123351,3125027,3125043,3126707,3126723,3128377,3128393,3130036,3130052,3131688,3131704,3133332,3133348,3134968,3134984,3136604,3136620,3138229,3138245,3139845,3139861,3141454,3141470,3143054,3143070,3144648,3144664,3146233,3146249,3150310,3150326,3151854,3151870,3153391,3153407,3154919,3154935,3156439,3156455,3157951,3157967,3159451,3159467,3160940,3160956,3162422,3162438,3163898,3163914,3165365,3165381,3166847,3166863,3168244,3168260,3169631,3169647,3171011,3171027,3172385,3172401,3173753,3173769,3175113,3175129,3176514,3176530,3177910,3177926,3179384,3179400,3180854,3180870,3182321,3182337,3183782,3183798,3185245,3185261,3186703,3186719,3188157,3188173,3189604,3189620,3191047,3191063,3192486,3192502,3194179,3194195,3195866,3195882,3197649,3197665,3199619,3199635,3201320,3201336,3203014,3203030,3204706,3204722,3206395,3206411,3208077,3208093,3209755,3209768,3211425,3211438,3213134,3213147,3214830,3214846,3216524,3216540,3218215,3218231,3219899,3219915,3221574,3221590,3223246,3223262,3224881,3224897,3226503,3226519,3228117,3228133,3229734,3229750,3231351,3231367,3232964,3232980,3234566,3234582,3236153,3236169,3237728,3237744,3239297,3239313,3240860,3240876,3242458,3242474,3244060,3245636,3444082,3444091,3446075,3446086,3448226,3448237,3450369,3450380,3452504,3452515,3454628,3454639,3456747,3456758,3458870,3458881,3461010,3461021,3463140,3463151,3465293,3465304,3467437,3467448,3469610,3469621,3471772,3471783,3473926,3473937,3476082,3476093,3478232,3478243,3480374,3480385,3482506,3482517,3484633,3484644,3486751,3486762,3488861,3488872,3490994,3491005,3493120,3493131,3495240,3495251,3497397,3497408,3499544,3499555,3501684,3501695,3503817,3503828,3505945,3505956,3508068,3508079,3510184,3510195,3512296,3512307,3514398,3514409,3516492,3516503,3518579,3518590,3520664,3520677,3522738,3522751,3524812,3524825,3526868,3526881,3528933,3528946,3530985,3530998,3533027,3533040,3535067,3535080,3537101,3537114,3539127,3539140,3541166,3541179,3543227,3543240,3545275,3545288,3547313,3547326,3549348,3549361,3551390,3551403,3553427,3553440,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





	Mikhail Gubsky (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Mikhail Gubsky (Tenor)

Mikhail Gubsky (Tenor)

Biography
Born in Magnitogorsk, Russia. Graduated from Samara Technical University (1993) and Samara Academia of Arts (1997; prof. Galina Sorokina).
From 1994, he was a soloist of the Samara Opera Theatre, from 1997, - soloist of the Moscow’s Novaya Opera Company (Moscow).
Since 2001, he has also been appearing at the Bolshoi Theatre.

Repertoire

His repertoire at the Bolshoi Theatre includes the following roles:
Lensky (Eugene Onegin)
Golitsyn, Andrei Khovansky (Mussorgky’s Khovanshchina)
Vaudemont (Tchaikovsky's Iolantа)
The Simpleton, Shuisky (Boris Godunov)
Lykov (Rimsky-Korsakov's The Tsar's Bride)
King Berendey (Rimsky-Korsakov's The Snow Maiden)
Macduff (Macbeth)
Andrei (Tchaikovsky's Mazeppa)
Riccardo (Un Ballo in Maschera)
Anatole Kuragin (Prokofiev’s War and Peace)
Grishka Kuterma (Rimsky-Korsakov's The Legend of the Invisible City of Kitezh and of the Maiden Fevronia)

Also in repertoire:
Fisherman (Stravinsky’s Le Rossignol)
Alfredo (La Traviata)
Pan Damazy (Moniuszko’s The Haunted Manor)
Mozart (Rimsky-Korsakov's Mozart and Salieri)
Vakula (Tchaikovsky's The Slippers)
Rodolfo (La Boheme)
Paolo (Rakhmaninov’s Francesca da Rimini)
Title role (Zemlinsky’s The Dwarf )
Jacopo (Verdi’s I Due Foscari)
Guglielmo (Donizetti’s Viva la Mamma)
Title role (Faust)
Hagenbach (Catalani’s La Wally)
Young Gipsy (Rakhmaninov’s Aleko)
The Duke (Rigoletto)
Vasily (Slonimsky’s Ivan the Terrible's Dreams)
Leicester (Donizetti’s Maria Stuarda)
The Pretender (Boris Godunov)
Nemorino (L'Elisir d'Amore)
Turiddu (Cavalleria Rusticana)
Tenor parts in Stravinsky's Les Noces, and Verdi's Requiem

He has toured in USA, Canada, Japan, France, Germany, Austria, Italy, Switzerland, Finland, Slovenia and Poland.
In 2003, he took part in a Russian National Orchestra performance of J.S. Bach's Mass in B minor (conductor Kent Nagano) at Moscow's International House of Music. In 2004, he sang the role of The Hussar in a performance of Mavra at the Igor Stravinsky Festival in Arnhem (The Netherlands) and took part in a performance of Rakhmaninov’s The Bells at the Carnegie Hall (conductor James Conlon).

Since 2004, he has been organizer and artistic director of the From Heart to Heart Music Festival, which is held under the patronage of the Samara region local government.
Since 2007, he has been artistic director of the Samara Theatre of Opera and Ballet.

Awards

He was a prize-winner at the Nikolai Pechkovsky Singers Competition (Saint Petersburg, 1996), at the Mikhail Glinka Singing Contest (Samara, 1997), at the Stanislaw Moniuszko Vocal Competition (Warsaw, 1998), at the International Byul-Byul Competition (Baku, 2000), and at the Sobinov Musical Festival (Saratov, 2000).
He was a prize-winner at the Irina Arkhipova Grand Prize of Moscow Television competition (1997); a diploma-winner at the International Hans Gabor Belvedere Singing Competition (Vienna, 1996).

He was voted Teacher of the year - 99 at a review-competition of professional skills (Samara region).
His awards include: Theatrical Muse prize of the Samara region (1997, 2001, 2006); bronze medal awarded by the Irina Arkhipova Foundation (2002); silver Peter the Great medal for devoted service (2006).