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 (14713,16167,17777,19175,34111,35584,37125,37191,38672,38746,40193,41608,41660,41683,43000,43056,43079,43108,43120,44361,44412,44437,44468,44476,45712,45764,45790,45820,45828,47057,47109,47135,47165,47173,48397,48453,48476,48505,48517,49730,49782,49808,49838,49851,51058,51115,51136,51166,51179,52434,52455,52484,52498,53749,53770,53799,53812,55058,55079,55108,55121,56355,56379,56412,56420,57722,57742,57776,57785,59789,59812,59846,59855,61853,61875,61909,61916,63907,63930,63964,63971,65954,65977,66011,66018,67999,68022,68056,68063,70041,70064,70098,70105,72078,72101,72135,72142,74108,74131,74165,74172,76149,76183,76190,78159,78193,78200,80165,80199,80206,82164,82198,82205,84157,84191,84198,86176,86183,88154,88161,90120,90129,92078,92087,94031,94040,95980,95989,97919,97928,99857,101777,105619,105627,107513,107521,109399,109407,111276,111284,113145,113153,115014,116890,153402,155133,156854,158565,160291,162022,163749,165490,167221,168942,170654,172358,174057,175740,177414,179077,180731,182378,184018,185649,187271,188883,190483,192072,198360,199677,200994,202676,204348,206052,207750,209438,211103,212636,214175,215711,217242,218771,220294,221411,221430,221431,221813,222925,222944,222945,223327,224434,224453,224454,224836,225939,225958,225959,226347,227444,227463,227464,227852,228943,228962,228963,229351,230928,230947,230948,231336,232923,232942,232943,233331,234913,234932,234933,235321,236898,236917,236918,237306,238872,238891,238892,239280,240838,240857,240858,241246,242799,242818,242819,243207,244759,244775,244776,245168,246713,246729,246730,247120,248660,248676,248677,249067,250603,250620,250621,251010,252587,252603,252604,252994,254560,254576,254577,254967,256524,256544,256545,256932,258485,258502,258503,258906,260451,260472,260473,260872,262411,262432,262433,262832,264377,264395,264396,264798,266337,266355,266356,266758,268289,268310,268311,268709,270230,270251,270252,270650,272169,272189,272190,272589,274102,274122,274123,274522,276056,276057,276456,277980,277981,278384,279857,279858,280261,281725,281726,282129,283988,285845,287699,289249,289544,291086,291420,292982,293316,294870,295205,296751,297085,298627,298961,300498,300832,302386,302722,304269,304602,306195,306534,308119,308458,310037,310376,311952,312290,313861,314199,315766,316104,317664,318002,319554,319892,321433,321771,323303,323641,325198,325546,327453,329352,331245,333131,335006,336872,338751,340680,342364,342372,342604,344288,344296,344528,346204,346212,346451,348111,348119,348358,350001,350009,350248,351879,351885,352127,353757,353764,354007,355629,355636,355878,357506,357513,357755,359413,359420,359662,361312,361318,361563,363203,363212,363453,365086,365092,365337,366965,366975,367216,368843,368850,369094,370713,370723,370965,372577,372587,372829,374432,374442,374684,376277,376287,376530,378112,378121,378365,379945,379954,380198,381772,381782,382026,383595,383602,383847,385411,385418,385662,387218,387225,387468,389030,389037,389281,390829,390837,391083,392629,392636,392883,394425,394434,394675,396215,396223,396469,398000,398009,398254,399777,399786,400032,401547,401556,401801,403305,403314,403560,405062,405072,405317,406814,406824,407069,408570,408816,410310,410556,412322,414079,415822,417562,419302,421035,422765,424488,426202,427901,429595,431287,432991,434689,436381,438064,439732,441389,443031,444664,446284,447898,449500,451092,452682,454270,455849,457330,457375,457421,458895,458941,458988,460497,460544,462045,462092,463597,463644,465145,465191,466687,466734,468385,468434,470085,470134,471636,471685,473178,473227,474758,474807,476384,477944,477957,477985,479514,479527,479554,481076,481091,481118,481822,481837,481863,482560,482575,482601,483295,483310,483336,484038,484052,484080,484788,484803,484831,485548,485576,486286,486314,487010,487038,487753,488462,489176,489885,490587,491284,497386,498850,500304,501758,503251,504728,506205,507674,509140,510604,512060,513509,514984,516442,539362,540778,542211,543656,545126,546580,548036,549435,549487,550878,550929,552313,552365,553738,553789,555154,555204,556610,558013,559410,560803,562189,563571,564941,566307,567664,569016,570368,571706,583959,583969,584022,585277,585286,585335,586583,586594,586646,587891,587900,587950,589187,589196,589245,590827,590837,590886,592445,592454,592503,594074,594085,594133,595773,595784,595833,597463,597474,597523,599143,599155,599203,600816,600826,600876,602493,602503,602552,604170,604219,605829,605877,607526,609168,610855,612535,614209,614255,614275,615871,615917,615937,615975,616014,617520,617566,617586,617624,617663,619152,619201,619221,619259,619299,620786,620831,620850,620890,620929,622406,622455,622475,622513,622553,624020,624069,624089,624127,624167,625694,625714,625752,625792,627309,627332,627369,627408,628914,628937,628974,629013,630510,630533,630570,630608,632099,632122,632159,632196,633683,633706,633741,633780,635256,635279,635315,635356,636818,636841,636877,636918,638371,638393,638429,638470,639910,639931,639969,640009,641461,641499,641538,642981,643019,643059,644494,644532,644572,645999,646037,646078,647538,647574,649025,649065,650520,650560,652004,652040,653480,653516,654946,654982,656402,656438,657884,659332,660772,662198,663617,665031,666438,667873,693978,694014,695226,695262,696454,696494,697674,697711,698881,698917,700078,700114,701267,701308,702466,702502,703648,703689,704823,704863,705981,706020,707128,707164,708256,708295,709378,709417,710524,710562,711703,712840,713969,715083,716184,717278,859678,859681,862394,862398,865101,865104,867796,867799,870480,870483,873162,873166,875845,875849,875876,878531,878536,878563,881215,881219,881247,883900,883905,883933,886584,886608,889273,891934,894589,897243,899898,902535,921180,921211,921213,923859,923890,923894,926553,926582,926587,929267,929298,929302,931976,932005,932008,934683,934712,934716,937388,937417,937420,940119,940148,940150,942840,942866,942868,945545,945571,945574,948247,948273,948276,950953,950979,950982,953653,953678,953682,956342,956368,956372,959019,959045,959049,961674,961699,961704,964314,964342,964344,966949,966978,966980,969581,969610,969612,972209,972238,972240,974829,974858,974859,977441,977470,977472,980048,980077,980079,982640,982669,982670,985227,985254,985258,987878,987882,990497,990501,993111,993113,995718,995722,995799,995806,995865,995870,998312,998316,998393,998401,998459,998464,1000896,1000900,1000977,1000985,1001043,1001048,1003477,1003481,1003558,1003566,1003624,1003629,1006051,1006056,1006131,1006139,1006197,1006202,1008623,1008698,1008709,1008764,1008769,1011257,1011268,1011323,1011328,1013837,1013848,1013903,1013907,1016401,1016411,1016467,1016472,1018947,1018961,1019015,1019019,1021494,1021508,1021562,1021566,1024039,1024053,1024107,1024111,1026573,1026587,1026645,1026649,1029108,1029117,1029175,1029178,1031634,1031643,1031701,1031704,1034137,1034146,1034204,1034207,1036627,1036636,1036694,1036696,1039116,1039125,1039183,1039185,1041599,1041609,1041667,1041669,1044075,1044085,1044143,1044145,1046542,1046552,1046610,1046612,1048998,1049008,1049067,1049069,1051442,1051450,1051510,1051513,1053883,1053939,1053943,1056310,1056366,1056370,1058731,1058788,1058792,1061197,1061201,1063598,1063602,1065992,1065996,1068376,1068380,1070745,1070750,1073145,1073149,1075538,1075542,1077921,1077925,1080292,1080296,1082652,1082656,1082791,1084997,1085000,1085136,1087325,1087328,1087465,1089649,1089785,1092115,1094436,1096746,1099043,1101320,1103591,1105840,1108075,1110282,1112468,1114636,1116783,1118924,1121049,1123194,1125324,1127514,1129735,1131945,1134135,1136339,1138539,1140736,1142925,1145108,1147278,1553926,1554960,1555977,1556994,1558000,1559007,1559999,1561352,1563043,1564885,1566710,1569348,1572244,1575131,1578008,1580876,1583729,1586569,1589405,1592234,1595055,1597929,1600795,1603649,1606491,1609328,1612159,1614980,1617792,1620593,1623376,1716114,1718884,1721637,1724379,1727118,1729850,1732569,1735273,1737968,1740650,1971118,1971123,1971177,1973130,1973187,1975184,1977169,1979141,1981138,1983130,1985116,1987093,1989063,1991019,1992958,1994895,1994895,2112801,2114706,2116608,2118500,2120381,2122252,2124112,2125956,2127794,2129623,2131443,2133254,2135055,2136845,2138686,2566980,2569780,2572611,2575431,2578241,2581050,2583840,2586609,2589382,2592144,2594896,2597646,2600382,2603105,2678751,2681134,2683507,2685872,2688231,2690582,2692918,2695239,2697901,2700975,2704057,2707129,2710165,2731730,2734841,2737932,2741014,2744086,2747137,2750167,2753194,2756217,2854544,2855954,2857357,2934929,2937424,2939925,2942422,2944909,2947379,2949828,2952267,2954713,2957194,2959669,2962131,2964569,2966989,2969403,2971821,2974213,2976594,3002630,3002641,3004926,3004937,3007158,3007169,3009356,3011537,3029402,3029412,3029481,3030828,3030839,3030908,3032242,3032254,3032321,3033653,3033661,3033726,3035245,3035254,3035318,3036822,3036832,3036897,3038391,3038401,3038466,3039950,3039961,3040026,3041511,3041579,3043055,3043123,3044663,3046194,3047710,3049217,3050723,3052226,3053716,3055199,3056672,3058130,3059578,3061022,3062758,3064549,3064572,3064605,3066272,3066295,3066328,3067978,3068003,3068036,3069677,3069703,3069732,3071364,3071390,3071420,3073047,3073068,3073099,3074715,3074738,3074773,3076374,3076397,3076429,3078025,3078049,3078086,3079686,3079711,3079740,3081335,3081361,3081392,3082976,3083000,3083032,3084603,3084622,3084658,3086277,3086311,3087919,3087956,3089554,3089586,3091174,3091209,3092821,3094419,3096013,3097599,3099175,3100746,3132715,3134355,3135995,3137628,3139249,3140861,3142465,3144059,3145649,3147229,3147865,3148495,3149119,3149743,3151290,3152829,3154362,3155885,3157401,3158908,3160402,3161887,3163364,3164836,3166299,3167724,3169118,3170503,3171880,3173251,3174616,3175871,3176018,3177269,3177416,3178660,3178805,3180132,3180277,3181600,3181745,3183066,3183211,3184529,3184674,3185990,3186135,3187447,3187592,3188898,3189043,3190344,3190488,3191785,3191925,3193365,3195052,3196838,3198812,3200784,3202478,3204172,3205864,3207548,3209232,3210901,3212621,3214323,3216019,3217713,3219401,3221081,3222683,3222688,3222700,3222704,3222719,3222740,3222742,3222743,3222748,3222754,3222759,3222761,3222787,3224347,3224352,3224364,3224370,3224383,3224405,3224407,3224409,3224413,3224417,3224424,3224426,3224452,3225976,3225981,3225993,3225997,3226009,3226032,3226035,3226036,3226042,3226046,3226052,3226057,3226079,3227591,3227601,3227608,3227612,3227631,3227650,3227652,3227654,3227656,3227662,3227669,3227672,3227695,3229208,3229214,3229226,3229230,3229248,3229267,3229269,3229271,3229274,3229279,3229286,3229290,3229313,3230832,3230839,3230850,3230855,3230870,3230888,3230891,3230892,3230897,3230903,3230910,3230912,3230937,3232449,3232455,3232465,3232470,3232483,3232503,3232509,3232510,3232516,3232518,3232526,3232528,3232551,3234057,3234063,3234076,3234077,3234095,3234113,3234116,3234117,3234122,3234127,3234133,3234136,3234161,3235662,3235675,3235677,3235694,3235711,3235715,3235717,3235722,3235728,3235733,3235736,3235760,3237246,3237259,3237261,3237278,3237296,3237299,3237300,3237304,3237311,3237317,3237319,3237344,3238828,3238832,3238843,3238865,3238869,3238872,3238877,3238882,3238886,3238892,3238913,3240396,3240398,3240411,3240435,3240438,3240439,3240441,3240449,3240454,3240459,3240482,3241998,3242002,3242018,3242038,3242040,3242042,3242045,3242050,3242058,3242059,3242085,3243594,3243613,3243631,3243635,3243636,3243637,3243645,3243650,3243655,3243678,3245192,3245211,3245215,3245218,3245222,3245226,3245234,3245237,3245261,3246791,3246815,3246818,3246819,3246825,3246830,3246834,3246840,3246860,3248377,3248401,3248404,3248406,3248412,3248416,3248421,3248426,3248446,3249972,3249975,3249976,3249978,3249984,3249992,3249994,3250018,3251536,3251539,3251540,3251544,3251550,3251555,3251560,3251584,3253095,3253098,3253101,3253104,3253109,3253117,3253120,3253144,3254694,3254698,3254700,3254704,3254708,3254716,3254719,3254742,3256706,3256708,3256709,3256715,3256720,3256725,3256729,3256752,3258720,3258721,3258725,3258732,3258736,3258742,3258764,3260725,3260728,3260735,3260739,3260759,3262710,3262717,3262718,3262741,3264690,3264697,3264702,3264725,3266673,3266677,3266702,3268658,3268664,3268687,3268691,3268695,3268716,3270711,3270734,3270737,3270747,3270764,3272861,3272864,3272872,3272890,3274973,3274975,3274982,3275000,3277065,3277068,3277077,3277093,3279155,3279158,3279161,3279184,3281289,3281293,3281296,3281317,3283414,3283419,3283422,3283443,3285538,3285541,3285562,3287691,3287712,3289847,3291963,3294066,3296168,3341406,3341408,3343747,3343749,3346101,3346103,3348452,3348456,3350791,3350793,3353112,3353114,3355431,3355434,3357762,3357764,3360109,3360111,3362472,3362474,3364824,3364825,3367166,3367168,3369493,3369495,3371818,3371821,3374137,3374139,3376448,3376453,3378747,3378751,3378757,3378759,3378767,3381044,3381047,3381050,3381055,3381064,3383312,3383317,3383321,3383324,3383333,3385601,3385604,3385608,3385609,3385619,3387869,3387871,3387876,3387879,3387887,3390132,3390135,3390138,3390147,3392385,3392390,3392398,3394635,3396857,3403521,3403539,3403645,3405702,3405719,3405825,3407865,3407886,3407991,3410035,3410048,3410156,3412179,3412190,3412301,3414342,3414363,3414468,3416494,3416509,3416617,3418635,3418649,3418758,3420757,3420767,3420879,3422873,3422979,3424955,3425062,3427120,3429165,3431188,3433197,3435203,3437198,3439179,3441145,3443110,3445084,3447236,3449384,3451523,3453654,3455776,3457900,3460022,3462160,3464286,3466435,3468615,3470783,3472939,3475095,3477246,3479392,3481531,3492168,3492176,3494291,3494298,3496407,3496413,3498560,3498566,3500705,3500711,3502846,3504977,3505013,3507139,3509260,3511373,3513481,3515578,3517664,3519752,3521828,3523901,3525961,3534216,3536251,3538285,3540305,3542377,3544435,3546474,3548510,3550544,3552585,3554617,3556658,3807846,3808222,3808595,3808964,3809332,3809698,3810060,3810419,3810775,3810798,3810802,3811167,3811189,3811193,3811572,3811578,3811954,3811958,3812332,3812334,3812707,3812712,3813076,3813079,3813448,3835752,3835996,3836235,3836468,3838004,3838261,3838514,3838765,3839018,3839269,3840284,3840537,3840820,3841099,3841374,3841646,3841913,3842175,3842435,3842702,3842967,3843230,3843488,3843742,3847495,3847727,3847955,3848179,3848408,3848633,3848855,3849076,3849295,3849529,3849761,3850712,3850934,3851151,3851365,3851576,3851784,3851990,3852194,3852393,3852396,3852511,3852986,3852988,3853107,3853578,3853579,3853696,3854165,3854167,3854282,3854753,3854871,3855453,3856035,3856615,3857189,3857807,3858423,3859229,3860025,3860826,3861621,3862415,3863204,3863992,3864775,3865557,3866334,3867108,3867881,3868647,3869417,3870181,3870944,3871707,3872452,3873193,3873949,3874700,3875451,3876198,3876944,3877689,3878432,3879174,3879917,3880658,3881400,3882142,3882885,3883626,3884365,3885106,3885842,3886577,3887313,3888043,3888777,3889504,3890228,3890956,3891671,3892393,3893105,3893821,3894540,3895258,3895971,3907309,3907999,3908684,3909369,3910049,3910739,3923727,3924401,3925070,3925734,3926399,3927062,3927721,3928377,3929032,3929686,3932291,3932298,3932312,3932932,3932937,3932952,3933575,3933583,3933597,3934217,3934225,3934239,3934860,3934873,3935496,3935509,3936128,3936143,3936798,3937454,3938103,3938747,3953307,3953318,3953925,3953941,3954539,3954548,3955148,3955164,3955766,3956368,3956422,3956435,3957041,3957058,3957620,3957661,3957679,3957685,3958280,3958299,3958303,3958895,3958911,3958916,3959500,3959518,3959522,3960109,3960122,3960125,3960707,3960724,3960729,3961308,3961324,3961329,3961906,3961919,3961922,3962488,3962506,3962510,3963074,3963089,3963092,3963657,3963662,3963665,3964229,3964234,3964240,3964806,3964809,3965377,3965963,3994325,3994846,3995368,3995883,3996393,3996903,3997406,3998422,3998928,3999430,3999929,4000423,4000921,4001415,4001906)) 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





	Nadezhda Gonchar (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Nadezhda Gonchar (Dancer)
			

																
Nadezhda Gonchar (Dancer)

														
				


        




    

        Born in Kiev. Graduated with distinction from the Kiev State Choreography School in 1996 and was engaged as a soloist at the Kiev National Shevchenko Theatre of Opera and Ballet. Her repertoire there included Myrtha (Giselle), Aurora, the Lilac Fairy (The Sleeping Beauty), solo and variations from Paquita, Juliet (Romeo and Juliet in Serge Lifar?s staging) and the Queen of the Dryads (Don Quixote).
Joined Mariinsky Theatre in 2002

Won first prize at the Serge Lifar International Ballet Competition (1999). 

Repertoire includes:
Swan Lake (Two swans/ The Prince?s Friends), Don Quixote (Street Dancer, Flower-girl, Queen of the Dryads and variation from Act IV), Raymonda ("Dream" – variations from first act), Fokine?s Chopiniana (Nokturne), Balanchine?s Apollo (Calliope), Le Corsaire (the Odalisque), The Nutcracker (Masha), La Sylphide (Sylphide), Forsythe?s The vertiginous thrill of exactitude. 
        

    

    

            


			

		





	


	

	

		


			

				

					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