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 (14707,16157,17767,19169,20615,35526,37153,38703,40151,424277,424287,424308,426001,426022,427721,429415,431103,432806,457353,457393,458920,458959,460476,460514,462024,462063,463576,463615,465123,465162,466665,466705,468403,470104,471655,473196,474776,476353,477924,477982,479497,479552,481056,481117,481866,482604,483338,484077,484828,485573,486311,487035,487750,488464,489178,489887,490589,491288,497476,498946,500401,501856,503344,504826,506299,507770,509239,510703,512159,513607,515077,516541,517995,519440,520882,522319,523747,523808,525166,525226,526576,526637,527980,528042,529383,529445,530783,530845,532177,532240,533561,533624,534995,535058,536418,536483,537849,537912,539273,539338,540689,540754,542123,542186,543568,543631,545038,545101,546555,548011,549461,550904,552340,553764,555181,556588,557991,559388,560780,562167,563549,583952,584018,585266,585331,586574,586642,587880,587946,589176,589242,590817,590883,592435,592498,594066,594130,595766,595830,597456,597520,599137,599200,600873,602549,604216,605874,607523,609161,610848,612528,614202,615864,617513,619150,620778,622404,638528,640068,641598,643118,644628,646134,647635,649125,650619,652101,653577,655043,656498,657949,659398,660835,662262,663681,665094,666502,667937,669357,670796,672220,673639,675044,676443,677829,679232,680630,682016,683391,732014,732041,732065,733000,733028,733048,733985,734018,734036,734968,735001,735019,735946,735967,735992,736003,736921,736944,736969,736979,737889,737912,737937,737947,738849,738872,738896,738907,739802,739825,739849,739859,741773,741796,741820,741830,743749,743772,743796,743806,745718,745747,745765,745775,747680,747708,747726,747735,749664,749693,749711,749720,751646,751675,751693,751702,753628,753657,753675,753684,756504,756532,756551,756560,759374,759402,759421,759430,762241,762269,762287,762297,765104,765132,765150,765160,767960,767988,768006,768015,770809,770837,770855,770864,773653,773680,773698,773707,776490,776517,776535,776544,779323,779350,779368,779377,782159,782184,782204,782213,784992,785017,785037,785046,787820,787845,787865,787874,790644,790669,790689,790698,793464,793489,793509,793518,796271,796296,796317,796327,799078,799103,799124,799134,801879,801906,801927,801937,804677,804704,804725,804735,807469,807497,807518,807528,810256,810284,810305,810315,813037,813064,813086,813096,815813,815839,815866,815872,818584,818610,818637,818643,821347,821374,821401,821407,824103,824130,824156,824163,826852,826879,826905,826912,829596,829623,829649,829655,832339,832364,832385,832396,835071,835097,835124,835130,837800,837826,837853,837859,840527,840555,840580,840586,843250,843278,843303,843309,845995,846023,846047,846055,848731,848759,848783,848790,851462,851490,851514,851526,854195,854223,854247,854259,856929,856952,856976,856988,859650,859673,859698,859709,862367,862389,862416,862426,865074,865096,865124,865133,867769,867791,867819,867829,870475,870503,870513,873164,873186,873196,875847,875869,875879,878533,878556,878566,881217,881240,881250,883902,883926,883936,886601,886611,889266,889276,891928,891937,894583,894592,897237,897246,899895,902533,902555,905187,907804,910418,910588,913031,913200,915830,918534,921227,923906,926597,929314,932020,934728,937433,940164,942882,945588,948290,950996,953696,956386,959062,961717,964357,966993,969625,972253,974872,977477,977483,977484,980084,980090,980091,982677,982681,982682,985262,985269,985270,987886,987893,987894,987928,990505,990512,990513,990547,993116,993122,993123,993160,995726,995733,995734,995769,998321,998328,998329,998364,1000906,1000912,1000913,1000948,1003486,1003493,1003494,1003529,1003655,1006061,1006068,1006069,1006102,1006227,1006234,1008628,1008634,1008635,1008669,1008794,1008801,1011188,1011193,1011194,1011228,1011353,1011359,1013772,1013773,1013808,1013934,1013939,1016371,1016498,1016510,1018920,1019047,1019060,1021467,1021594,1021607,1024012,1024139,1024144,1024217,1026546,1026674,1026686,1026752,1029076,1029204,1029217,1029282,1031601,1031730,1031743,1031809,1034104,1034233,1034246,1034312,1036723,1036736,1036800,1039212,1039225,1039289,1041697,1041709,1041772,1044173,1044185,1044248,1046640,1046652,1046715,1049097,1049109,1049173,1051541,1051553,1051617,1053971,1053983,1054046,1056398,1056410,1056473,1058820,1058832,1058895,1061229,1061241,1061304,1063630,1063641,1063705,1066024,1066035,1066099,1068407,1068416,1068481,1070775,1070783,1070851,1073175,1073183,1073251,1075568,1075576,1075644,1077951,1077959,1078028,1080322,1080330,1080399,1082682,1082690,1082759,1085026,1085036,1085104,1087355,1087365,1087433,1089674,1089680,1089753,1092004,1092010,1092084,1094326,1094333,1094406,1096636,1096643,1096717,1098932,1098940,1099012,1101209,1101217,1101291,1103480,1103488,1103562,1105741,1105811,1108039,1110246,1112430,1114601,1116749,1118889,1121015,1123160,1125292,1127484,1129704,1155933,1158106,1160267,1162414,1164548,1166677,1168811,1170936,1173052,1412309,1414072,1415826,1417569,1419300,1421020,1422730,1424426,1426109,1427777,1447248,1448807,1450352,1451885,1453403,1454921,1456426,1457924,1459410,1483478,1484827,1486165,1487493,1488810,1490114,1491404,1492686,1493994,1495295,1496590,1497883,1499181,1500466,1501745,1503019,1504281,1505541,1506790,1508032,1509259,1510489,1511718,1512941,1514161,1515388,1516613,1517822,1519024,1520225,1521417,1522604,1523783,1524955,1526121,1527278,1528430,1529577,1530720,1531859,1532993,1534123,1535249,1536370,1537486,1538626,1539759,1540884,1542006,1543125,1544232,1545334,1546426,1547506,1548574,1549628,1550680,1551724,1552769,1553811,1554844,1555870,1556884,1557893,1558896,1559891,1561244,1562935,1802535,1804973,1807394,1809799,1812181,1814536,1816882,1819204,1821501,1823773,1826022,1828246,1830448,1832636,1834835,1837027,1839210,1841378,1843529,1845669,1847826,1849978,1852124,1854264,1856402,1858529,1860645,1862760,1864871,1915725,1917937,1920137,1922336,1924527,1926774,1929015,1931244,1933458,1935657,1937853,1940042,1942220,1944390,1946555,1948703,1950839,1952970,1955093,1957169,1959237,1961285,1963323,1965350,1967372,1969390,1971167,1971172,1971402,1973179,1973181,1973412,1975174,1975179,1975409,1977160,1977164,1977395,1979131,1979136,1979366,1981129,1981133,1981364,1983119,1983125,1983356,1985106,1985111,1985341,1987083,1987088,1987319,1989054,1989058,1989288,1991009,1991013,1991245,1992953,1993183,1995122,1997049,1998971,2000885,2002788,2004682,2006554,2008442,2010327,2012204,2014065,2015905,2017731,2019542,2021349,2023150,2024944,2026936,2028926,2030905,2032870,2034829,2036784,2038729,2040667,2042593,2044504,2046402,2048291,2050173,2052050,2053911,2055862,2057899,2059932,2061959,2063979,2065989,2067991,2069997,2071989,2073966,2075938,2077904,2079902,2197543,2199068,2200602,2202157,2203698,2205228,2206756,2208283,2209798,2211302,2212850,2214550,2216239,2217921,2219779,2222014,2224241,2226453,2228655,2230845,2233025,2235440,2238061,2240972,2244149,2247316,2250475,2253622,2256761,2259893,2263014,2266126,2269228,2272320,2275432,2278577,2281714,2284864,2288005,2291138,2294263,2297382,2300505,2303634,2306781,2309950,2313115,2316276,2319432,2322583,2325724,2328858,2331974,2335083,2338180,2341278,2344391,2347494,2350596,2353722,2356833,2359938,2363035,2366127,2369204,2372274,2375333,2378377,2381409,2384440,2386921,2387458,2389984,2390522,2393046,2393582,2396098,2396634,2399132,2399670,2402155,2402693,2405165,2405705,2408176,2408716,2411180,2411718,2414171,2414710,2417732,2420739,2423732,2426722,2429705,2432677,2435640,2438592,2441531,2444459,2447383,2450298,2453204,2456092,2458981,2461853,2464709,2467582,2470502,2473419,2476367,2479303,2482227,2485137,2488046,2490984,2493909,2496829,2499742,2502637,2505517,2508385,2511243,2514105,2516960,2519806,2522646,2525473,2528289,2531098,2533903,2536699,2539498,2542289,2545069,2547835,2550643,2553443,2556256,2559066,2561865,2564648,2567417,2570253,2573079,2575900,2578710,2581519,2584309,2587084,2589852,2592617,2595371,2598116,2600852,2603578,2606285,2608990,2611689,2614416,2617139,2619853,2622555,2625238,2627922,2630595,2633264,2635915,2638561,2641190,2643805,2646416,2649013,2651599,2654173,2656736,2659283,2661811,2664318,2666819,2669292,2671751,2674195,2676618,2679021,2681404,2683780,2686143,2688504,2690854,2693192,2695512,2697944,2698264,2701018,2701338,2704100,2704420,2707172,2707492,2710208,2710537,2713244,2713576,2716268,2716599,2719333,2719669,2722407,2722781,2725506,2725883,2728595,2728972,2731680,2732067,2735177,2738268,2741350,2744422,2747473,2750503,2753530,2756558,2759571,2762586,2765595,2768585,2771559,2774529,2777488,2780472,2783497,2786332,2786578,2789411,2789657,2792470,2792716,2795526,2795772,2798595,2798841,2801653,2801900,2804950,2807917,2810861,2813785,2816701,2819682,2822652,2825634,2828603,2831554,2834484,2837407,2840335,2843253,2844692,2846120,2847539,2848947,2851801,2853221,2854634,2856044,2857447,2858843,2860230,2861606,2864382,2867159,2868532,2869911,2871287,2872658,2874023,2875380,2876726,2878069,2879441,2882217,2884982,2906659,2909245,2911854,2914445,2917030,2919611,2922178,2924734,2927281,2929809,2932319,2934825,2937320,2939821,2942318,2942421,2944805,2944908,2947378,2949827,2952271,2954712,2957193,2959668,2962130,2964568,2966988,2969402,2971820,2974212,2976593,3002648,3004944,3007176,3009363,3011544,3283658,3283722,3285780,3285839,3287927,3287988,3290061,3290120,3292178,3292241,3294287,3294342,3296385,3296445,3298475,3298538,3300560,3300621,3302637,3302698,3304704,3304761,3306746,3306809,3308798,3308854,3310833,3310895,3312867,3312928,3314837,3314882,3314890,3314944,3316850,3316890,3316901,3316960,3318849,3318894,3318899,3318958,3320839,3320881,3320889,3320949,3322822,3322864,3322874,3322934,3324967,3325015,3325017,3325077,3327238,3327284,3327286,3327347,3329626,3329669,3329674,3329738,3332009,3332048,3332056,3332119,3334374,3334415,3334422,3334484,3336726,3336767,3336776,3336836,3339073,3339115,3339126,3339186,3341417,3341461,3341469,3341529,3343756,3343798,3343806,3343866,3346111,3346152,3346163,3346221,3348462,3348509,3348511,3348575,3350797,3350846,3350849,3350914,3353124,3353168,3353171,3353236,3355440,3355483,3355491,3355551,3357774,3357815,3357821,3357886,3360118,3360158,3360167,3360225,3362478,3362521,3362530,3362589,3364835,3364877,3364883,3364941,3367171,3367219,3367222,3367281,3369502,3369548,3369551,3369615,3371824,3371873,3371883,3371942,3374146,3374188,3374196,3374260,3376459,3376501,3376511,3376569,3378765,3378807,3378814,3378878,3381059,3381107,3381109,3381173,3383329,3383376,3383379,3383439,3385618,3385658,3385665,3385723,3387881,3387929,3387938,3387997,3390140,3390188,3390198,3390251,3392397,3392437,3392447,3392502,3394633,3394672,3394682,3394745,3396899,3396902,3396961,3399112,3399118,3399179,3401311,3401319,3401381,3403502,3403510,3403575,3405686,3405695,3405755,3407854,3407863,3407919,3410020,3410022,3410084,3412160,3412171,3412232,3414330,3414339,3414395,3416486,3416542,3418625,3418683,3420810,3422906,3424988,3427046,3429094,3431117,3433129,3435133,3437127,3439110,3490318,3492449,3494571,3496686,3498839,3500981,3503118,3505247,3507374,3509492,3511608,3513717,3515812,3517901,3519985,3522064,3524133,3526197,3528249,3530309,3532351,3534391,3536433,3538461,3538532,3540485,3540559,3542555,3542625,3544613,3544682,3546654,3546728,3548690,3548761,3550721,3550798,3552764,3552839,3554798,3554873,3556835,3556910,3558859,3558936,3560872,3560945,3562876,3562949,3564876,3564953,3566894,3566972,3568909,3568983,3570926,3571001,3572936,3573012,3574948,3575021,3576856,3576929,3578757,3578833,3580657,3580734,3582524,3582595,3584382,3584454,3586241,3586310,3588095,3588166,3589947,3590017,3591795,3591865,3593639,3593711,3595617,3595692,3597612,3597685,3599588,3599661,3601544,3601621,3603494,3603570,3605433,3605508,3607356,3607434,3609276,3609352,3611186,3611260,3613083,3613157,3615003,3615080,3616918,3616997,3618827,3618901,3620728,3620805,3622627,3622699,3624518,3624591,3626397,3626472,3628265,3628342,3630124,3630201,3631985,3632060,3633835,3633911,3635680,3635758,3637516,3637594,3639340,3639418,3641150,3641224,3642953,3643028,3644749,3644825,3646534,3646608,3648387,3650158,3651921,3653665,3655409,3657139,3658862,3660579,3662305,3664018,3665725,3667421,3669110,3670788,3672457,3674124,3675779,3807827,3808203,3808576,3849337,3849571,3849803,3850033,3850261,3850487,3850711,3850933,3851150,3851364,3851575,3851783,3851989,3852193,3852397,3852989,3853580,3854169,3854754,3893805,3918249,3918923,3919612,3920300,3920978,3921658,3926423,3927086,3927746,3928403,3929057,3929712,3930359,3931006,3931651,3932295,3932936,3933579,3934220,3934857,3935493,3953321,3953935,3954555,3955159,3955767,3956366,3956406,3957032,3957647,3958265,3958884,3959490,3960094,3960697,3961297,3961891,4051533,4052415,4053288,4054159,4055026,4055893,4056756,4057617,4058472,4059324,4060170,4061017,4061857,4062692,4063523)) 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





	Sergei Romanov (Baritone) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Sergei Romanov (Baritone)

Sergei Romanov (Baritone)

Born in Leningrad. Graduated from the St Petersburg State Rimsky-Korsakov Conservatoire in 2000 (class of N. Alexeyev).

Soloist with the Mariinsky Academy of Young Singers since 1999.

Mariinsky Theatre soloist since 2008.

At the Mariinsky Theatre he has performed the following roles:

Shchelkalov (Boris Godunov), Ovlur (Prince Igor), Eugene Onegin (Eugene Onegin), Robert (Iolanta), Silvio (I pagliacci), Marullo (Rigoletto), Germont, Baron Duphol (La traviata), Marcello (La boh?me), Prince Yamadori (Madama Butterfly), Danca?ro (Carmen), Pompeo (Benvenuto Cellini in concert), Count Almaviva (Le nozze di Figaro) and Wigmaker, Harlequin (Ariadne auf Naxos).

Frequently gives recitals. Has toured with the Mariinsky Opera Company to Finland, Spain, the UK, Sweden and Japan as well as throughout Russia.