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 (8418,10124,11707,13290,14679,16130,17740,35519,35566,37106,37170,38718,40167,41627,41640,43021,43031,44380,44393,45732,45745,47077,47090,48418,48428,49749,49763,51077,51091,52397,52411,53712,53726,55021,55035,56324,56335,57686,57699,59769,61831,107649,107666,107740,107939,108134,109536,109552,109627,109826,110021,111414,111429,111504,111703,111898,113283,113298,113373,113573,113768,115144,115159,115234,115434,115629,117020,117034,117110,117310,117505,118895,118909,118985,119185,119380,120766,120780,120856,121056,121251,122633,122646,122722,122921,123117,124491,124504,124579,124779,124975,126340,126353,126428,126628,126824,128180,128193,128268,128468,128664,130009,130022,130097,130297,130493,131838,131851,131926,132126,132322,133671,133684,133759,133959,134155,135496,135509,135584,135784,135980,137317,137330,137405,137605,137801,139135,139148,139223,139423,139618,140945,140958,141032,141232,141428,142746,142759,142833,143033,143229,144536,144549,144623,144823,145019,146316,146329,146403,146603,146799,148087,148100,148174,148373,148570,149843,149857,149931,150131,150328,151593,151607,151681,151881,152078,153333,153351,153422,153465,153622,153819,155064,155082,155157,155196,155358,155550,156785,156803,156878,156917,157079,157271,158496,158514,158589,158628,158789,158982,160222,160240,160315,160354,160514,160708,161949,161967,162042,162081,162241,162435,163667,163684,163772,163826,163989,164186,165408,165426,165514,165568,165730,165927,167139,167157,167245,167299,167461,167658,168878,168971,169020,169186,169379,170590,170683,170732,170899,171091,172294,172387,172436,172604,172796,173994,174081,174130,174298,174490,175765,175814,175982,176174,177438,177487,177655,177847,179101,179150,179317,179510,180755,180803,180970,181163,182402,182450,182616,182810,184042,184091,184257,184451,185673,185723,185888,186082,187294,187345,187510,187704,188906,188957,189122,189316,190506,190557,190722,190917,192095,192146,192311,192506,193673,193699,193724,193892,194087,196433,196453,196482,196667,196900,197745,197765,197794,197979,198216,199062,199082,199111,199296,199533,200379,200399,200428,200613,200850,202061,202081,202110,202295,202532,203733,203758,203782,203967,204204,205405,205429,205455,205642,205908,207103,207127,207153,207340,207606,208791,208815,208841,209028,209294,210504,210691,210958,212192,212261,212275,212326,212344,212477,213728,213796,213810,213861,213879,214017,215263,215332,215346,215397,215415,215553,216794,216863,216877,216928,216946,217084,218323,218392,218406,218457,218475,218612,219846,219915,219929,219980,219998,220135,221365,221434,221448,221499,221517,221654,222879,222948,222962,223013,223031,223168,224388,224457,224471,224522,224540,224677,225894,225962,225979,226033,226051,226188,227400,227467,227485,227538,227556,227693,228899,228966,228983,229037,229055,229192,230884,230951,230968,231022,231040,231177,232879,232946,232963,233017,233035,233172,234868,234936,234953,235006,235025,235163,236852,236921,236937,236991,237010,237148,238827,238895,238912,238965,238984,239122,240793,240861,240878,240931,240950,241088,242754,242822,242839,242892,242911,243049,244711,244779,244796,244850,244868,245009,246664,246733,246750,246804,246825,246961,248611,248680,248697,248751,248772,248908,250560,250624,250645,250695,250716,250852,252544,252607,252623,252678,252699,252835,254517,254581,254601,254652,254673,254809,256543,256565,256616,256638,256773,258506,258527,258577,258598,258734,260470,260492,260543,260565,260700,262430,262452,262503,262525,262660,264399,264420,264470,264491,264627,266359,266380,266429,266451,266587,268309,268332,268381,268403,268538,270250,270273,270322,270344,270478,272188,272212,272261,272283,272417,274121,274145,274194,274215,274272,274350,276055,276079,276128,276149,276206,276284,277982,278002,278052,278075,278133,278211,279859,279879,279929,279952,280010,280088,281727,281747,281797,281819,281878,281956,283606,283660,283677,283737,283816,285463,285517,285534,285594,285673,287318,287372,287389,287449,287528,289160,289214,289234,289292,289371,291052,291072,291130,291208,292948,292968,293026,293105,294836,294856,294915,294994,296716,296736,296795,296874,298590,298610,298669,298748,300461,300481,300539,300619,302353,302371,302431,302510,304235,304253,304313,304392,306161,306179,306240,306324,308085,308103,308164,308248,310021,310082,310166,311938,311995,312080,313846,313904,313989,315751,315809,315894,317649,317707,317792,319597,319682,321476,321561,323346,323431,325241,325326,327140,327224,329040,329125,330931,331016,332817,332902,334692,334777,336558,336643,338424,338509,340305,340389,342229,342313,342351,342422,344153,344237,344275,344344,346069,346153,346192,346260,348061,348099,348167,349951,349989,350057,351829,351870,351938,353707,353743,353816,355580,355620,355688,357457,357497,357565,359364,359404,359472,361263,361303,361371,363153,363193,363263,365037,365077,365146,366915,366955,367026,368791,368835,368903,370664,370706,370774,372528,372570,372638,374384,374425,374493,376228,376270,376338,378063,378105,378173,379896,379938,380006,381724,381766,381834,383544,383582,383655,385359,385399,385470,387205,387278,389019,389089,390818,390890,392617,392689,394415,394485,396203,396276,397988,398060,399770,399839,401540,401606,403367,405121,406874,408621,410361,412127,413884,415627,417366,419106,420839,422569,424294,426008,427707,457371,458938,460494,462042,463594,465140,466682,468379,470082,471633,477993,479559,481128,481869,482613,483347,484089,484840,485585,486323,487047,487762,488473,489186,489895,490597,491296,491984,523811,525229,526632,528037,529440,530841,532236,533625,535054,536479,537908,539334,540750,542182,543626,545096,546550,548006,549456,550899,552335,553759,555176,556584,557987,559384,560776,562163,563545,644547,646054,647556,649041,650538,652022,653498,654964,656419,656472,657859,657921,659313,659375,660749,660812,662238,663656,665072,666478,667913,669337,670772,672200,673618,675023,676419,677805,732075,733059,734044,735031,735999,736039,736977,737016,737945,737984,738905,738944,739857,739897,741828,741868,743804,743844,745773,745813,747738,747778,749723,749758,751705,751740,753687,753722,756563,756603,759433,759473,762300,762340,765163,765203,768018,768059,770867,770908,773710,773751,776547,776588,779380,779421,782216,782256,785049,785088,787877,787916,790701,790740,793521,793560,796329,796372,799136,799179,801938,801982,804737,804780,807530,807573,810317,810360,813098,813141,815874,815917,818645,818688,821409,821452,824165,824208,826914,826957,829657,829701,832398,832441,835132,835176,837861,837908,840588,840635,843311,843358,846056,846103,848791,848839,851521,851570,854254,854301,856983,857030,859710,859752,862427,862469,865134,865176,867828,867871,870512,870556,873195,873239,875878,875922,878565,878609,881249,881293,883935,883979,886610,886654,889275,889320,891936,891982,894591,894637,897245,897290,899894,899940,902538,902582,905210,907827,910441,913052,915684,918387,921080,923758,1006244,1008811,1011370,1013949,1016517,1019062,1021609,1024154,1026689,1029219,1031607,1031745,1034109,1034248,1036599,1036738,1039226,1041718,1044131,1044194,1046598,1046661,1049055,1049118,1051507,1051562,1053937,1053992,1056364,1056419,1058786,1058841,1061195,1061250,1063596,1063649,1065990,1066043,1068370,1068425,1070738,1070795,1073138,1073193,1075531,1075586,1077914,1077969,1080285,1080340,1082645,1082700,1084986,1085043,1087376,1089690,1092020,1094342,1096659,1098955,1101232,1103503,1105751,1107979,1317657,1319580,1321493,1323398,1325294,1327170,1329031,1330886,1332768,1334643,1336509,1338362,1340200,1342022,1343834,1345639,1347446,1349238,1351017,1352915,1354801,1356676,1358540,1360398,1362246,1364085,1365916,1367727,1367738,1369533,1369547,1371333,1371347,1373120,1373133,1374895,1374908,1376748,1376761,1378595,1380414,1802532,1804970,1807391,1809794,1812175,1814530,1816876,1819198,1821496,1823768,1826018,1828242,1830444,1832632,1834831,1837023,1839207,1841374,1843527,1845667,1847823,1849975,1852121,1854261,1856400,1858527,1860643,1862758,1971195,1973201,1975202,1977187,1979159,1981155,1983147,1985134,1987109,1989078,1991033,1992976,1994909,1996838,1998764,2000678,2002582,2068021,2070027,2072019,2073998,2075970,2077933,2079931,2081922,2083909,2085834,2087747,2089656,2091560,2112780,2114686,2116584,2118477,2120357,2122228,2124089,2125933,2127771,2129600,2131421)) 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





	Ilya Selivanov (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Ilya Selivanov (Tenor)
			

																
Ilya Selivanov (Tenor)

														
				


        




    

        
• Prize-winner and recipient of the special prize at the I International Young Opera Singers’ Competition Opera without Borders (Krasnodar, 2014) 
• Prize-winner at the International Competition in Kohtla-Jдrve (Estonia, 2009) 
• Prize-winner at the Maxim Mikhailov International Opera Singers’ Competition (Kaluga, 2013) 
• Grant-recipient of the Mstislav Rostropovich Foundation (2011-2012) 
Born in Leningrad. In 2007 he graduated with honours from the Glinka Choral School. In 2012 he graduated from the choral and conducting faculty of the St Petersburg State Rimsky-Korsakov Conservatoire, while in 2013 he graduated from the vocals faculty there (class of Professor Yuri Marusin). 
Has toured to Italy, Great Britain, Austria, Switzerland, France and Germany. 
Became a soloist of the Mariinsky Academy of Young Singers in 2012. 
Repertoire at the Mariinsky Theatre: 
Lensky (Eugene Onegin) 
Gritsko (Sorochintsy Fair). 
Repertoire includes: Vaudemont (Iolanta), the Prince (Respighi’s La bella dormente nel bosco), Rinuccio (Gianni Schicchi) and Alfredo (La traviata). 
        

    

    

            


			

		





	


	

	

		


			

				

					Deals & Discounts 
					Subscribe to our email newsletter
				



				
				


			

			

		

		

	

	




 



	

		

			
    		

    

        

		
		
Award-winning
Group Tour Packages

        

        

		
Useful Links &
Company Information

        

        

        
    
		

	





	

		

			
© 2001 – 2024 by Northern Crown, Ltd. uVisitRussia and uVisitRussia.com are registered trademarks. Terms & Conditions  Privacy Policy