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 (14685,16134,17744,37149,38697,40146,110139,112016,113886,115747,117623,119498,121370,123236,125094,126943,128783,130612,132441,134274,136099,137920,139738,141548,143349,145139,146919,148690,150448,152197,153938,155669,157390,159101,160827,162554,164306,166047,167778,169499,171210,172915,174609,176293,177966,179629,181283,182931,184572,186203,187825,189437,191036,192625,194206,197022,198338,198393,199655,199710,200972,201027,202654,202709,204326,204381,206030,206087,207728,207785,209416,209472,211081,211136,212614,212670,214153,214209,215689,215745,217220,217276,218749,218805,220272,220328,221791,221847,223305,223361,224814,224870,226325,226381,227830,227886,229329,229386,231314,231371,233309,233366,235299,235356,237284,237341,239257,239315,241223,241281,243184,243242,245145,245203,247097,247155,249044,249102,250988,251046,252971,253029,254945,255003,256910,256967,258882,258941,260849,260908,262809,262867,264775,264834,266735,266794,268686,268745,270627,270686,272566,272625,274173,274499,274558,276107,276433,276492,278032,278360,278419,279910,280237,280296,281778,282105,282164,283637,283964,284022,285493,285821,285878,287348,287675,287732,289195,289521,289579,291028,291384,291464,292924,293280,293360,294814,295169,295249,296694,297049,297129,298572,298922,299006,300442,300794,300876,302687,302765,304569,304647,306497,306579,308425,308503,310343,310421,312257,312335,314166,314244,316071,316149,317969,318047,319859,319937,321738,321816,323608,323686,325513,325591,327416,327499,329319,329397,331212,331290,333098,333176,334973,335051,336839,336917,338717,338797,340632,340727,342556,342651,344481,344575,346404,346498,348310,348405,350199,350295,352080,352174,353960,354051,355834,355931,357710,357808,359616,359715,361518,361617,363404,363507,365289,365391,367169,367273,369049,369148,370917,371018,372780,372882,374635,374737,376480,376582,378314,378417,380147,380250,381975,382078,383802,383902,385617,385717,387425,387525,389236,389336,391037,391137,392836,392936,394626,394729,396423,396523,398207,398307,399980,400083,401752,401853,403508,403612,405266,405369,407018,407121,408765,408868,410504,410608,412271,412375,414028,414132,415777,415875,417517,417615,419257,419355,420990,421088,422720,422818,424445,424543,426159,426257,427858,427955,429552,429649,431240,431361,432936,433063,434640,434761,436334,436455,438017,438138,439685,439805,441342,441462,442981,443104,444610,444734,446229,446356,447847,447971,449444,449573,451041,451165,452631,452755,454219,454343,455797,455923,457369,457497,458936,459063,460492,460619,462040,462167,463592,463719,465138,465267,466680,466809,468377,468513,470081,470218,471631,471769,473311,474891,476468,478043,479613,497342,497362,497368,498806,498826,498837,500260,500282,500293,501715,501736,501747,503228,503237,504707,504718,506178,506190,507647,507660,509119,509130,510582,510594,512049,513496,523777,525197,526605,528009,529413,530813,532207,533593,535027,536451,537880,539305,540721,542153,543598,545068,546520,547975,549426,549513,550869,550956,552305,552392,553733,553816,555235,556642,558044,559441,560834,562217,563599,564972,566333,567692,569046,570394,571731,573110,574482,575843,577201,578553,583966,583993,585279,585306,586587,586617,587893,587920,589190,589216,590831,590860,592447,592477,594079,594105,595777,595805,597467,597494,599148,599175,600820,600848,602497,602524,604164,604191,605849,607497,609136,610823,612504,614177,615936,617584,619222,620853,622476,624090,625715,627331,628936,630532,632121,633705,635278,636838,638367,638391,639930,641460,642982,644493,646000,693927,695175,696404,697624,698831,700028,701217,736021,736996,737965,738925,739878,741849,743824,745793,747755,749739,751721,753703,756579,759449,762316,765179,768035,770884,773727,776564,779397,782233,785065,787893,790717,793537,796347,799154,801957,804755,807548,810335,813116,815892,818663,821427,824182,826932,829676,832416,835150,837882,840609,843332,846077,848813,851544,854277,857005,859732,862448,865156,867851,870535,873218,875901,878588,881272,883958,886633,889298,891960,894615,897269,899918,902555,902672,905187,905304,907804,907920,910418,910534,913031,913146,915779,918483,921176,923853,926544,929261,931970,934677,937382,940115,942833,945538,948240,950946,953645,956335,959012,961667,964305,966941,969573,972201,974821,977433,980040,1024179,1026714,1029249,1031774,1034276,1036765,1039254,1041738,1044214,1044301,1046681,1046768,1049138,1049225,1051584,1051669,1054014,1054099,1056441,1056526,1058863,1058948,1061272,1061357,1063673,1063758,1066067,1066152,1068449,1068534,1070819,1070904,1073219,1073304,1075612,1075697,1077995,1078079,1080366,1080450,1082726,1082810,1085071,1085155,1087399,1087484,1089719,1089803,1092049,1092133,1094371,1094455,1096680,1096765,1098975,1099061,1101252,1101339,1103523,1103610,1105774,1105860,1108002,1108088,1110207,1110296,1112394,1112482,1114562,1114651,1116800,1118939,1121066,1123209,1125342,1127533,1129754,1131958,1134151,1136355,1138557,1140755,1142945,1145128,1147298,1149455,1151608,1153752,1155896,1256571,1258536,1260490,1262432,1264360,1266281,1268208,1270122,1272025,1273919,1275794,1277652,1279507,1281356,1283196,1285026,1286849,1412310,1414073,1415828,1417570,1419301,1421021,1422731,1424427,1426110,1427778,1648688,1651492,1654356,1657210,1660053,1662887,1665704,1668511,1671310,1674165,1677017,1679861,1682694,1685513,1688371,1691229,1694000,1696765,1699523,1702272,1705011,1707784,1710551,1713309,1716089,1718859,1721614,1802548,1804986,1807407,1809810,1812198,1814553,1816899,1819221,1821516,1823788,1826037,1828261,1830461,1832649,1834848,1837039,1839223,1841390,1843543,1845683,1847840,1849991,1852137,1854277,1856415,1858542,1860658,1862773,1864884,1866986,1869075,1871153,2112764,2114669,2116570,2118461,2120342,2122212,2124072,2125918,2550177,2552977,2555769,2558576,2561374,2564157,2566926,2569730,2572559,2710208,2710319,2713244,2713357,2716268,2716381,2719333,2719446,2722407,2722520,2725506,2725619,2728595,2728708,2731680,2731794,2734905,2737996,2741078,2744150,2747201,2750231,2753258,2756283,2759296,2762311,2765320,2768310,2771284,2774254,2777213,2780197,2783222,2786303,2786423,2789502,2792561,2795617,2798686,2801745,2804795,2807762,2810706,2813630,2816546,2819525,2822495,2825477,2828446,2831397,2834327,2837250,2840177,3177352,3178742,3180214,3181682,3183148,3184611,3186072,3187529,3188980,3190423,3191864,3193300,3194993,3196778,3198751,3200719,3202417,3204111,3205800,3207489,3209167,3210842,3212560,3214263,3215956,3217652,3219340,3221019,3222685,3224350,3225979,3227594,3229212,3230836,3232451,3234061,3235660,3357992,3360338,3362700,3365052,3367393,3369720,3372047,3374366,3376679,3378982,3381280,3383547,3385836,3388102,3390363,3392612,3394850,3397073,3399286,3401491,3403678,3405858,3408029,3410195,3412338,3414507,3416654,3418795,3420916,3423018,3425099,3427157,3429202,3431226,3433233,3435241,3437237,3439217,3441180,3443147,3445121,3447276,3449420,3451561,3453692,3455811,3457934,3460062,3462198,3464323,3466473,3468652,3470820,3472976,3475132,3477282,3479429,3481566,3483699,3485823,3487933,3490040,3492172,3494292,3496408,3498561,3500706,3946407,3947029,3947643,3948248,3948890,3949529,3950164,3950795,3951424,3952050)) 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 Ulanov (Baritone) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Yevgeny Ulanov (Baritone)

Yevgeny Ulanov (Baritone)

Baritone

International Competition prize-winner (Byelorussia, 1999).

Born in Tashkent (Uzbekistan). Graduated from the Moscow State Gnesins Academy in 1991 (class of Professor Eizen). Trained in Italy in 1989 under Professor Mariotti. From 1990-92, participated in concerts and festivals as part of the New Names programme.

Soloist with the St Petersburg Chamber Opera Company from 1994. Since 1997, he has worked with the St Petersburg Chamber Chorus, directed by Nikolai Kornev. His large repertoire includes oratorios by Bach, Handel and Donizetti. Sang in the Russian premieres of Donizetti‘s Messa di Requiem and Handel‘s oratorio The Passion of Christ.

In 1999, was invited by the Mariinsky Theatre to perform Don Giovanni in the opera of the same name (Musical Director: Valery Gergiev; Stage Director: Johannes Schaaf).

Mariinsky Theatre soloist since 2000.

Repertoire includes: Ruprecht (The Fiery Angel), Count Almaviva (Le nozze di Figaro), Guglielmo (Cosi fan tutte), Don Giovanni (Don Giovanni), Flemish Deputies (Don Carlo), Marcello (La boheme), Sharpless (Madama Butterfly), Ser Amantio di Nicolao (Gianni Schicchi).

Has given solo recitals in Moscow, Paris, Vienna, Finland, the USA, Denmark, Sweden and Italy.

Has toured with the Mariinsky Theatre to Germany (Baden-Baden), Japan and Australia.