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 (14688,16138,17748,274258,276192,278117,279993,281861,283720,285577,287432,289274,291114,293010,294899,296779,298651,300522,302415,304296,306220,308144,310062,311977,313886,315791,317689,319579,321458,323328,325224,327123,329024,330915,332801,334676,342355,344278,346195,348102,349992,351868,353747,355619,357495,359402,361301,363195,365075,366953,368832,370703,372566,374421,376266,378100,379933,381761,383583,385400,387206,389020,390819,392618,394417,396206,397991,399767,401537,457338,458904,460461,497410,497497,498874,498960,500330,500416,501784,501870,503273,503360,504755,504841,506225,506313,507697,507784,509166,509254,510631,510716,512085,512172,513535,513621,515002,515095,516470,516556,517924,518010,519368,519453,520809,520895,522246,522332,523675,523766,525185,526589,527993,529397,530797,532191,533580,535011,536435,537864,539289,540705,542137,543585,545054,546508,547963,549414,550857,732042,733029,734012,734995,735968,736945,737913,738873,739826,741797,743773,745741,747709,749687,751669,753651,756533,759403,762270,765133,767989,770838,773681,776518,779351,782185,785018,787846,790670,793490,796297,799104,801907,804705,807498,810285,813065,815840,818611,821375,824131,826880,829624,832365,835100,837829,840556,843279,846024,848760,851491,854224,856953,859674,862390,865097,867792,870476,873158,875841,878527,881211,883904,1317618,1319541,1321450,1323359,1325251,1327126,1328988,1330847,1332729,1334604,1336463,1338316,1340153,1341976,1343788,1345601,1347401,1349193,1350978,1352877,1354762,1356637,1358501,1360359,1362207,1364044,1971132,1973141,1975139,1977124,3807823,3808199,3857239,3857856,3858471,3859276,3860075,3860860,3860873,3861656,3861669,3862447,3862464,3863240,3863254,3864027,3864040,3864810,3864822,3865588,3865604,3866367,3866380,3867142,3867155,3867912,3867929,3868683,3868695,3869452,3869469,3870221,3870233,3870984,3870996,3871746,3871760,3872494,3873233,3873246,3873988,3874001,3874740,3874752,3875491,3875504,3876237,3876250,3876983,3876996,3877729,3877742,3878470,3878483,3879214,3879227,3879952,3879969,3880694,3880712,3881441,3881455,3882182,3882196,3882926,3882940,3883667,3883681,3884405,3884419,3885142,3885160,3885882,3885896,3886616,3886631,3887348,3887364,3888083,3888096,3888813,3888830,3889543,3889558,3890270,3890283,3890991,3891009,3891711,3891725,3892430,3892446,3893145,3893158,3893860,3893877,3894579,3894595,3895296,3895316,3896008,3896029,3896716,3896735,3897423,3897441,3898128,3898149,3898830,3898849,3899532,3899550,3900231,3900250,3900948,3900970,3901666,3901681,3902378,3902398,3903091,3903107,3903798,3903814,3904501,3904521,3905202,3905218,3905899,3905917,3906609,3907305,3907994,3908679,3909365,3910042,3941354,3941995,3942632,3943260,3943886,3944512,3945138,3945750,3946378,3947001,3947614,3975696,3976307,3976909,3977510,3978107,3978700,3979291,3979877,3980465,3981046)) 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





	Yuri Marusin (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Yuri Marusin (Tenor)

Yuri Marusin (Tenor)

Tenor

People‘s Artist of Russia (1983) and also holds.
Russian State Prize for his achievements in the Arts (1985).

Yuri Marusin was born in Kizel in the Urals. He studied music at an early age and initially performed with a folk ensemble. In 1970 he was accepted into the Leningrad Conservatoire graduating in 1975 with honours, already being engaged as a soloist with the Maly Opera Theatre in Leningrad since 1972.
During the 1977-78 season he studied at La Scala in Milan where he subsequently sang the leading tenor roles in ‘Gianni Schicchi‘, ‘Madama Butterfly‘, ‘Boris Godunov‘ and other roles in both Western and Russian repertory. In 1982 he was awarded the Verdi Prize as the best foreign singer at La Scala for his performance of Gabriele Adorno in ‘Simon Boccanegra‘ conducted by Claudio Abbado. He is also a laureate of many international competitions including the ‘Erkel‘ competition in Budapest, in Viotti, and in Pleven, Bulgaria.
Since 1980 Yuri Marusin has been a leading soloist at the Kirov Theatre in St Petersburg, where he has worked closely with Yuri Temirkanov and Valery Gergiev on a large number of new productions. His repertoire includes over 50 leading roles in Russian, French and Italian opera. He made his debut at the Vienna State Opera in 1986 and has sung a variety of roles there including Lensky, Dmitry, Golitsyn, Herman and Cavaradossi. His Salzburg Festival debut came in 1980 in the role of Don Juan in Dargomyzhski‘s opera "The Stone Guest". Other foreign appearances have taken him to the USA, Japan, Canada, Belgium, Holland, Switzerland, Sweden, Finland. He was first heard in England in 1987 when the Kirov Opera gave a guest season at the Royal Opera House, Covent Garden. In 1992 he enjoyed immense critical acclaim as Herman in Graham Vick‘s new production of "The Queen of Spades" at Glyndebourne.
In the 1998-99 season Yuri Marusin has been invited to the Metropolitan Opera House to sing the role of Herman ("Pique Dame").

His repertoire includes: Bizet Carmen - Don Jose; Boito Mephistopheles - Faust; Borodin Prince Igor - Vladimir Igorevich; Dargomyzhsky Stone Guest - Don Juan; Donizetti Lucia di Lammermoor - Edgardo, L‘Elisir d‘Amore - Nemorino; Glinka Ruslan and Liudmila - Finn, Bayan; Gluck Iphigenie en Tauride - Orestes; Gounod Faust - Faust; Janacek Diary of One Who Disappeared; Massenet Werther - Werther; Mozart Don Giovanni - Don Ottavio, Requiem; Mussorgsky Boris Godunov - Dmitry, Khovanschina - Golitsyn, Andrei, Sorochinsky Fair - Gritsko; Tchaikovsky Eugene Onegin - Lensky, The Queen of Spades - Herman, Iolanta - Vaudemont, Mazeppa - Andrei, Cherevichki - Vakula; Vainberg Madonna I Soldat - Pavel; Verdi La Traviata - Alfredo, Rigoletto - Duke of Mantua, Don Carlos - Don Carlos, La Forza del Destino - Don Alvaro, Aida - Radames, Simon Boccanegra - Gabriele Adorno, Otello - Otello (in preparation), Requiem.
Complete recital programmes feature songs by Glinka, Tchaikovsky, Gliere, Cui, Rimsky-Korsakov, Rachmaninov, Dargomyzhsky, Sviridov, Dvorak, Brahms, Schubert, Grieg, and others.
Has toured with the Mariinsky Theatre throughout Europe, Israel, the United States (Metropolitan Opera House) and Japan.

Recordings: ‘ Gianni Schicchi‘, ‘La Forza del Destino‘, ‘Ruslan and Liudmila‘, ‘Khovanschina‘, ‘Iolanta‘, ‘The Queen of Spades‘, ‘War and Peace‘.