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 (14699,14708,14728,14753,16151,16160,16180,16205,17761,17770,17790,17815,19164,19173,19186,19211,20617,20629,20654,22100,22112,22137,23554,23566,23591,25029,25054,26734,26773,26825,27611,27665,27758,29072,29101,29160,30965,30977,31002,32488,32518,37187,37211,38737,38763,40189,40211,56429,56502,57787,57863,59857,59933,61925,61997,63977,64052,66027,66099,68072,68144,70114,70186,72151,72223,74181,74253,76199,76271,78209,78281,80215,80287,82214,82286,84207,84279,86192,86264,88170,88242,90138,90210,92096,92168,94045,94121,95998,96070,97937,98009,99866,99938,101787,101859,103695,103768,105668,107562,108010,108032,109449,109896,109919,111326,111773,111796,113195,113643,113666,115055,115504,115527,116931,117380,117403,118806,119255,119278,120676,121126,121149,122542,122991,123015,124400,124849,124873,126249,126703,126722,128089,128543,128562,129918,130371,130391,131747,132200,132220,133580,134033,134053,135405,135858,135878,137226,137679,137699,139497,139517,141307,141327,143108,143128,144898,144918,146678,146698,148449,148469,150207,150227,151957,151977,153698,153718,155429,155447,157150,157166,158861,158877,160587,160603,162312,162330,164065,164084,165805,165825,167535,167556,169256,169275,170968,170987,172673,172692,174366,174386,176050,176069,177722,177742,179385,179405,181038,181058,182685,182705,184326,184350,185962,185981,187584,187603,189196,189215,190796,190815,192384,192404,193965,193985,195267,195649,196031,196757,196783,198071,198098,198393,199388,199415,199710,200705,200732,201027,202387,202414,202709,204058,204085,204381,205735,205760,206087,207432,207458,207785,209120,209146,209472,210781,210813,211136,212264,212288,212322,212670,213799,213824,213857,214209,215335,215360,215393,215745,216866,216891,216924,217276,218395,218420,218453,218805,219918,219943,219976,220328,221437,221461,221495,221847,222951,222974,223008,223361,224464,224483,224517,224870,225971,225993,226028,226381,227471,227498,227533,227886,228975,228997,229032,229386,230960,230982,231017,231371,232955,232977,233012,233366,234945,234967,235002,235356,236930,236952,236985,237341,238904,238926,238961,239315,240869,240892,240925,241281,242830,242853,242886,243242,244787,244811,244844,245203,246741,246771,246798,247155,248688,248716,248745,249102,250632,250660,250688,251046,252615,252643,252672,253029,254589,254617,254645,255003,256553,256581,256610,256967,258514,258542,258570,258941,260480,260508,260537,260908,262440,262468,262497,262867,264408,264435,264463,264834,266368,266395,266423,266794,268320,268347,268375,268745,270261,270288,270316,270686,272200,272227,272255,272625,274133,274160,274188,274558,276066,276094,276122,276492,277990,278019,278046,278419,279867,279895,279923,280296,281735,281761,281791,282164,283594,283619,283655,284022,285451,285476,285512,285878,287331,287367,287732,289180,289208,289579,291015,291047,291464,292911,292943,293360,294800,294832,295249,296712,297129,298587,299006,300457,300876,302347,302765,304231,304647,306157,306579,308503,310421,312335,314244,316149,318047,319937,321816,323686,325591,327499,329397,331290,333176,335051,336917,338797,340727,342362,342651,344287,344575,346203,346498,348110,348405,350000,350295,351878,352174,353756,354051,355628,355931,357505,357808,359412,359715,361311,361617,363204,363507,365084,365391,366967,367273,368841,369148,370715,371018,372579,372882,374434,374737,376279,376582,378114,378417,379947,380250,381775,382078,383594,383902,385410,385717,387217,387525,389029,389336,390828,391137,392628,392936,394426,394729,396214,396523,397999,398065,398307,399780,399844,400083,401546,401611,401853,403308,403371,403612,405065,405128,405369,406817,406877,407121,408628,408868,410367,410608,412133,412375,413889,414132,415632,415875,417371,417615,419111,419355,420844,421088,422574,422818,424299,424543,426013,426257,427712,427955,429406,429649,431361,433063,434761,436455,438138,439805,441462,443104,444734,446356,447971,449573,451165,452755,454343,455923,457497,459063,460619,462167,463719,465267,466809,468513,470218,471769,473311,474891,476468,478031,478043,479604,479613,497329,497342,497369,497379,497426,497478,497488,498793,498806,498838,498841,498890,498940,498952,500260,500294,500301,500348,500402,500406,501715,501748,501749,501800,501850,501861,503238,503245,503292,503345,503354,504719,504725,504773,504827,504832,506191,506196,506245,506298,506303,507661,507666,507716,507771,507778,509131,509136,509186,509240,509245,510595,510600,510650,510702,510707,512050,512055,512105,512158,512163,513497,513501,513550,513601,513613,514977,515024,515079,515086,516488,516542,516547,517942,517996,518000,519386,519439,519444,520828,520881,520886,522265,522318,522326,523693,523746,523755,523776,525112,525165,525174,525195,526521,526575,526583,526604,527925,527979,527987,528008,529328,529382,529390,529412,530782,530790,530812,532176,532184,532206,533563,533570,533592,534994,535003,535026,536419,536428,536450,537850,537854,537879,539272,539282,539304,540688,540698,540720,542122,542127,542152,543562,543573,543597,545032,545043,545067,546497,546519,547953,547974,549425,549527,549545,550868,550970,550988,552304,552405,552425,553731,553829,553849,555244,555265,556651,556672,558053,558074,559449,559471,560841,560864,562229,562250,563610,563632,564979,565001,566341,566362,567703,567721,569054,569076,570402,570423,571742,571761,573119,573140,574491,574512,575852,575873,577210,577231,578561,578583,579902,579924,581235,581257,582580,583905,585218,586529,595776,595811,597466,597501,599147,599182,600819,600854,602496,602531,604163,604198,605856,607505,609143,610830,612509,614184,615846,638467,638528,640006,640068,641536,641598,643053,643118,644565,644628,646071,646134,647573,647635,649063,649125,650554,650619,652039,652101,653515,653577,654981,655043,656436,656498,657881,657949,659330,659398,660766,660835,662192,662262,663612,663681,665026,665094,666431,666502,667937,669357,670796,672220,673639,675044,676443,677829,679232,680630,682016,683391,732014,732041,733000,733028,733985,734018,734968,735001,735946,735967,736021,736921,736944,736996,737889,737912,737965,738849,738872,738925,739802,739825,739878,741773,741796,741849,743749,743772,743824,745718,745747,745793,747680,747708,747755,749664,749693,749739,751646,751675,751721,753628,753657,753703,756504,756532,756579,759374,759402,759449,762241,762269,762316,765104,765132,765179,767960,767988,768035,770809,770837,770884,773653,773680,773727,776490,776517,776564,779323,779350,779397,782159,782184,782233,784992,785017,785065,787820,787845,787893,790644,790669,790717,793464,793489,793537,796271,796296,796347,799078,799103,799154,801879,801906,801957,804677,804704,804755,807469,807497,807548,810256,810284,810335,813037,813064,813116,815813,815839,815892,818584,818610,818663,821347,821374,821427,824103,824130,824182,826852,826879,826932,829596,829623,829676,832339,832364,832416,835071,835097,835150,837800,837826,837882,840527,840555,840609,843250,843278,843309,843332,845995,846023,846055,846077,848731,848759,848790,848813,851462,851490,851526,851544,854195,854223,854259,854277,856929,856952,856988,857005,859650,859673,859709,859732,862367,862389,862426,862448,865074,865096,865133,865156,867769,867791,867829,867851,870475,870513,870535,873164,873196,873218,875847,875879,875901,878533,878566,878588,881217,881250,881272,883902,883936,883958,886611,886633,889276,889298,891937,891960,894592,894615,897246,897269,899895,899918,902533,902555,902623,902632,902684,905187,905256,905265,905314,907804,907873,907882,907933,910418,910487,910496,910547,913031,913098,913108,913156,915729,915739,915787,918433,918443,918491,921126,921136,921184,923802,923815,923863,926496,926504,926556,929213,929223,929271,931921,931932,931980,934629,934639,934687,937334,937344,937392,940065,940075,940123,942782,942793,942841,945487,945498,945548,948189,948200,948250,950895,950905,950956,953604,953656,956293,956346,959023,959030,961678,961685,964318,964325,966954,966961,969586,969593,972214,972221,974833,974841,977446,977453,980052,980060,982644,982652,985231,985236,987855,987860,990479,993094,1006234,1008801,1011359,1013939,1016510,1019060,1021607,1024144,1026686,1029217,1031619,1031651,1031743,1034121,1034154,1034246,1036613,1036648,1036736,1039102,1039137,1039225,1041586,1041621,1041709,1044062,1044097,1044185,1046528,1046564,1046652,1049021,1049109,1051464,1051553,1053894,1053983,1056320,1056410,1058742,1058832,1061151,1061241,1063551,1063641,1065944,1066035,1068416,1070783,1073183,1075576,1077959,1080330,1082690,1085036,1087365,1089680,1092010,1094333,1096643,1098940,1101217,1103488,1105741,1256638,1258604,1260559,1262501,1264427,1266343,1268269,1270189,1272093,1273986,1275861,1277720,1279575,1281425,1283265,1285095,1286916,1288718,1290502,1292314,1294120,1295919,1297713,1299494,1301260,1303008,1304760,1306501,1308236,1309961,1311682,1648601,1651409,1654273,1657127,1659970,1662799,1665616,1971138,1973145,1975145,1977128,2698334,2701408,2704490,2707562,2710606,2713644,2716666,2719736,2722854,2725958,2729047,2731772,2732148,2734883,2735258,2737974,2738349,2741056,2741431,2744128,2744503,2747179,2747554,2750209,2750584,2753236,2753611,2756260,2756348,2756639,2759273,2759361,2759658,2762288,2762376,2762674,2765297,2765385,2765683,2768287,2768375,2768673,2771261,2771349,2771647,2774231,2774319,2774617,2777278,2777577,2780262,2780561,2783287,2783590,2786368,2786671,2789447,2789750,2792506,2792809,2795562,2795867,2798631,2798936,2801690,2801995,2804740,2805045,2807708,2808012,2810652,2810956,2813576,2813880,2816492,2816796,2819777,2822747,2825729,2828698,2831649,2834579,2837502,2840430,2843348,2844787,2846215,2847634,2849042,2851896,2853316,2854729,2856139,2857542,2858938,2860325,2861701,2864477,2867254,2868627,2870006,2871382,2872753,2874118,2875475,2876821,2878164,2879536,2882312,2885077,2887818,2890546,2893260,2895952,2898637,2901336,2904020,2906599,2909185,2911794,2914385,2916970,2919551,2922118,2939848,2942345,2944832,2947302,2949751,2952196,2957314,2959789,2962251,2964689,2967109,2969523,2971941,2974333,2976714,2979080,2981460,2983830,2986195,2988577,2990949,2993317,2995672,2998010,3000330,3002648,3004944,3007176,3009363,3011544,3029386,3030813,3032226,3033632,3035225,3142535,3142566,3144129,3144160,3145719,3145750,3147299,3147330,3147935,3147966,3148565,3148596,3149189,3149220,3149813,3149844,3151360,3151391,3152899,3152930,3154432,3154463,3155955,3155986,3157471,3157502,3158978,3159009,3160472,3160503,3161957,3161988,3163434,3163465,3164906,3164937,3166379,3166414,3167791,3167821,3169185,3169215,3170570,3170600,3171947,3171977,3173318,3173348,3174682,3174712,3176084,3176114,3177482,3177512,3177579,3178871,3178901,3178968,3180343,3180373,3180440,3181811,3181841,3181908,3183277,3183307,3183374,3184740,3184770,3184795,3184839,3186201,3186231,3186256,3186300,3187658,3187688,3187713,3187757,3189109,3189139,3189164,3189208,3190555,3190586,3190608,3190655,3191996,3192027,3192050,3192096,3193432,3193466,3193483,3193530,3195122,3195156,3195175,3195221,3196908,3196942,3196958,3197007,3198885,3198913,3198936,3198983,3200851,3200885,3200902,3200949,3202548,3202579,3202602,3202649,3204242,3204274,3204294,3204340,3205934,3205961,3205985,3206031,3207620,3207653,3207671,3207717,3209300,3209333,3209350,3209397,3210974,3211001,3211025,3211071,3212693,3212723,3212745,3212791,3214396,3214427,3214448,3214495,3216090,3216122,3216144,3216190,3217784,3217818,3217836,3217883,3219471,3219503,3219524,3219572,3221150,3221185,3221203,3221250,3222819,3222853,3222873,3222918,3224483,3224516,3224537,3224583,3226114,3226146,3226166,3226212,3227730,3227761,3227781,3227828,3229346,3229376,3229398,3229444,3230970,3230998,3231021,3231067,3232585,3232618,3232636,3232682,3234196,3234228,3234247,3234292,3235795,3235826,3235846,3235892,3237378,3237408,3237430,3237476,3238948,3238978,3238999,3239046,3240516,3240545,3240567,3240613,3242116,3242150,3242167,3242216,3243711,3243739,3243761,3243807,3245292,3245322,3245344,3245387,3246894,3246924,3246945,3246991,3248479,3248508,3248528,3248577,3250051,3250078,3250101,3250146,3251617,3251647,3251666,3251712,3253176,3253208,3253223,3253280,3254775,3254806,3254822,3254879,3256787,3256817,3256834,3256890,3258797,3258824,3258846,3258902,3260794,3260826,3260842,3260898,3262776,3262805,3262823,3262882,3264758,3264785,3264808,3264863,3266732,3266762,3266783,3266841,3268719,3268747,3268769,3268826,3270769,3270800,3270816,3270874,3272893,3272923,3272945,3273002,3275005,3275036,3275056,3275112,3277096,3277125,3277149,3277203,3279188,3279219,3279235,3279293,3281319,3281351,3281372,3281427,3283448,3283481,3283497,3283556,3285565,3285600,3285621,3285676,3287715,3287749,3287769,3287825,3289850,3289885,3289903,3289960,3291967,3291998,3292019,3292075,3294070,3294102,3294124,3294181,3296169,3296206,3296225,3296281,3298263,3298295,3298318,3298374,3300381,3300402,3300458,3302456,3302477,3302533,3304523,3304540,3304597,3306567,3306588,3306645,3308615,3308634,3308691,3310658,3310676,3310732,3312688,3312709,3312767,3314712,3314730,3314785,3316719,3316738,3316796,3318724,3318740,3318798,3320728,3320787,3322713,3322772,3324860,3324917,3327130,3327187,3329521,3329576,3331899,3331956,3334264,3334323,3336673,3339022,3341366,3343704,3346061,3348412,3350748,3353073,3355390,3357721,3360066,3362428,3364783,3367123,3369452,3371777,3390251,3390267,3392502,3392517,3394745,3394757,3396961,3396979,3399179,3399192,3401381,3401393,3403575,3403584,3405755,3405764,3407919,3407934,3410084,3410100,3412232,3412244,3414395,3414409,3414693,3416542,3416560,3416841,3418683,3418701,3418982,3420810,3420822,3421105,3422906,3422922,3423204,3424988,3425005,3425289,3427046,3427061,3427345,3429094,3429106,3429389,3431117,3431132,3431414,3433129,3433141,3433428,3435133,3435143,3435425,3437127,3437139,3437427,3439110,3439120,3439404,3441086,3441370,3443053,3443330,3445027,3445311,3447179,3447458,3449608,3451751,3453877,3455998,3458121,3460254,3462389,3464511,3466660,3468839,3471009,3473165,3475320,3477477,3479621,3481754,3483883,3486009,3488122,3490224,3492352,3494474,3496590,3498749,3500890,3503021,3505152,3507283,3509403,3511513,3513624,3515724,3517808,3519895,3521969,3524040,3526102,3528153,3530217,3532257,3534304,3536338,3538369,3540394,3542466,3544517,3546562,3548600,3550628,3552670,3554707,3556740,3558766,3560784,3562780,3564782,3566802,3568812,3570831,3572842,3574858,3576761,3578666,3580565,3582455,3584311,3586171,3588021,3589875,3591724,3593568,3595526,3597518,3599491,3807821,3845833,3846079,3846322,3846562,3846800,3847034,3847263,3847491,3847723,3847951,3848175,3848404,3848629,3848851,3849072,3849291,3918249,3918923,3919612,3920300,3920978,3921658,3946407,3947029,3947643,3948248,3948890,3949529,3950164,3950795,3951424,3952050,3953301,3953918,3963671,3964243,3964815,3965380,3965965,3966546,3975711,3976321,3976925,3977521,3978119,3978712,3979305,3979892,3980476,3981057,3981633,3982209,3982779,3983348,3983920,3994322,3994848,3995367,3995881,3996398,3996901,3997402,4035104,4035462,4036364,4037266,4038185,4039098,4040005,4040907,4125937,4126626,4127304,4127985,4128663,4129343,4130013,4130680,4250757,4251125)) 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





	Anastasia Kalagina (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Anastasia Kalagina (Soprano)
			

																
Anastasia Kalagina (Soprano)

														
				


        




    

        
She is a winner of special prize the Moniuszko Prize at the IV International Stanislaw Moniuszko Vocal Competition in Warsaw (2001). 
She won the first award at the V International Rimsky-Korsakov Competition (St Petersburg, 2002).
She is an IV award-winner of the III China (Ningbo) International Vocal Competition (2005). 

Was born in St Petersburg.
Graduated from the St Petersburg State Conservatoire (violin) in 1997.
Since 1998 she has been a soloist of the Mariinsky Academy of Young Singers. 

Repertoire includes:
The Snow Maiden (The Snow Maiden);
Luisa (Betrothal in a Monastery);
Anyuta (The Story of a Real Man in concert);
Bolkonsky`s Maid (War and Peace);
Gerda (The Story of Kai and Gerda);
Avrora (Cephalus and Procris);
Madame Cortese (Il viaggio a Reims);
Adina (L`elisir d`amore in concert);
Norina (Don Pasquale in concert);
Gilda (Rigoletto);
Thibaut (Don Carlo);
Nannetta (Falstaff in concert);
Frasquita (Carmen);
Susanna, Barbarina (Le nozze di Figaro);
Zerlina (Don Giovanni);
Sophie (Der Rosencavalier);
Zerbinetta (Ariadne auf Naxos). 

She is giving several recitals concert with Larisa Gergieva and tours with Mariinsky Theatre in Europe. 

© State Academic Mariinkiy Opera and Ballet theatre
        

    

    

            


			

		





	


	

	

		


			

				

					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