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 (586002,586009,587311,587318,588612,588619,589915,589927,591535,591547,593174,593186,594877,594888,596574,596585,598263,598274,599936,599947,601631,603300,654170,654183,654188,655631,655644,655649,657082,657095,657100,658537,658550,658555,659976,659989,659994,661412,661425,661430,662836,662849,662854,664253,664266,664271,665676,665681,667114,667119,668547,668552,669993,919669,922354,925053,927748,930461,933167,935875,938589,941312,944026,946723,949431,952136,954830,957514,960174,962815,965459,968091,970724,973346,975960,978573,1381454,1381458,1381465,1381474,1381478,1381585,1381592,1383270,1383274,1383281,1383290,1383294,1383401,1383408,1385077,1385081,1385088,1385097,1385101,1385106,1385211,1385219,1386881,1386885,1386892,1386901,1386905,1386910,1387015,1387023,1388675,1388679,1388686,1388695,1388699,1388704,1388809,1388817,1390455,1390459,1390466,1390475,1390479,1390484,1390589,1390597,1392224,1392228,1392235,1392244,1392248,1392253,1392358,1392366,1393984,1393988,1393995,1394004,1394008,1394013,1394118,1394126,1395762,1395766,1395773,1395782,1395786,1395791,1395896,1395904,1395916,1397528,1397532,1397539,1397548,1397552,1397557,1397662,1397670,1397682,1399285,1399289,1399296,1399305,1399309,1399314,1399419,1399427,1399439,1401041,1401048,1401057,1401061,1401066,1401171,1401179,1401191,1402790,1402799,1402803,1402808,1402913,1402921,1402933,1404532,1404536,1404541,1404646,1404654,1404666,1406255,1406259,1406264,1406369,1406377,1406389,1407976,1407980,1407985,1408090,1408098,1408110,1409704,1409709,1409814,1409822,1409834,1411436,1411541,1411549,1411561,1413291,1413299,1413311,1415051,1415059,1415071,1416793,1416803,1416815,1418536,1418544,1418556,1420263,1420271,1420283,1421980,1421988,1422000,1423683,1423691,1423703,1425372,1425380,1425392,1427046,1427054,1427066,1428710,1428718,1428730,1430360,1430368,1430380,1432000,1432008,1432020,1433631,1433639,1433651,1435247,1435255,1435267,1436852,1436860,1436872,1438473,1438481,1438493,1440081,1440089,1440101,1441682,1441690,1441702,1443276,1443284,1443296,1444868,1444880,1446444,1446456,1448020,1449572,1545887,1546972,1548045,1549108,1550167,1551215,1552254,1553295,1554330,1555357,1556375,1557385,1558393,1559391,1783687,1783688,1783723,1786219,1786220,1786255,1788724,1788725,1788760,1791218,1791219,1791254,1793730,1796187,1798637,1801090,2094471,2096350,2098215,2100176,2102127,2117737,2119624,2121501,2123368,2125220,2127061,2128895,2130721,2132537,2134344,2136138,2137922,2139765,2141599,2143424,2145238,2147042,2148836,2150616,2152383,2154141,2155890,2157628,2159355,2161109,2162848,2164577,2166298,2168001,2323373,2326511,2329641,2332752,2335854,2338950,2342046,2345153,2348252,2351348,2354467,2357574,2360675,2363770,2366855,2369929,2372994,2376044,2379082,2382114,2406446,2406452,2409451,2409457,2412446,2412452,2415432,2415438,2418446,2418452,2421448,2421454,2424439,2424445,2427431,2436372,2436377,2439318,2439323,2442253,2442258,2445179,2445184,2445209,2448100,2448105,2448130,2451010,2451015,2451024,2451035,2451040,2453913,2453918,2453927,2453938,2453943,2456797,2456802,2456811,2456822,2456827,2459690,2459701,2459706,2462565,2462570,2465420,2465425,2468297,2468302,2471235,2471240,2474154,2559897,2559899,2562686,2562688,2565461,2565465,2568227,2568231,2571058,2571060,2573882,2573884,2576696,2576698,2579497,2579499,2582294,2582296,2585076,2585078,2587847,2587849,2590615,2590617,2593374,2593376,2596125,2596127,2598867,2598869,2601596,2601598,2604312,2604314,2607019,2607021,2609724,2880896,2880932,2883668,2883704,2886426,2886462,2889160,2889197,2891883,2891920,2894586,2894623,2897275,2897312,2899972,2900009,2902663,2902700,2905247,2905284,2907839,2907876,2907904,2910456,2910493,2910521,2913054,2913091,2913119,2915642,2915679,2915707,2918232,2918269,2918297,2920842,2920870,2923407,2923435,2925962,2925990,2928498,2928526,2931017,2931045,2933525,2933553,2936025,2936053,2938561,2941064,2943558,2946036,3139772,3141381,3142981,3144575,3146160,3150237,3151781,3153318,3154846,3156366,3157878,3159378,3160867,3162349,3163825,3165292,3166774,3168171,3168217,3168226,3169558,3169604,3169613,3170938,3170984,3170993,3172312,3172358,3172367,3173680,3173726,3173735,3175040,3175086,3175095,3176441,3176487,3176496,3177837,3177883,3177892,3179311,3179357,3179366,3180781,3180827,3180836,3182248,3182294,3182303,3183709,3183755,3183764,3185172,3185218,3185227,3186630,3186676,3186685,3188084,3188130,3188139,3189531,3189577,3189586,3190974,3191020,3191029,3192413,3192459,3192468,3194106,3194152,3194161,3195793,3195839,3195848,3197576,3197622,3197631,3199546,3199592,3199601,3201247,3201293,3201302,3202941,3202987,3202996,3204633,3204679,3204688,3206321,3206368,3206377,3208003,3208050,3208059,3209676,3209726,3209728,3211346,3211396,3211398,3213055,3213105,3213107,3214756,3214803,3214812,3216450,3216497,3216506,3218141,3218188,3218197,3219872,3219881,3221547,3221556,3223219,3223228,3224854,3224863,3226476,3226485,3228090,3228099,3229705,3229714,3231319,3231322,3231331,3231340,3232932,3232935,3232944,3232953,3234537,3234546,3234555,3236142,3242531,3242538,3242548,3242555,3244117,3244124,3244134,3244141,3245693,3245700,3245710,3245717,3247284,3247291,3247301,3247308,3248861,3248868,3248878,3248885,3250429,3250436,3250446,3250453,3251993,3252000,3252010,3252017,3253590,3253597,3253607,3253614,3255586,3255593,3255603,3255610,3257601,3257608,3257618,3257625,3259602,3259609,3259619,3259626,3261590,3261597,3261607,3261614,3263572,3263579,3263589,3263596,3265552,3265559,3265565,3265577,3267540,3267547,3267553,3267565,3267588,3267594,3267600,3269599,3269605,3269617,3269640,3269646,3269652,3271688,3271700,3271723,3271729,3271737,3273815,3273838,3273844,3273852,3275937,3275943,3275951,3278027,3278033,3278041,3280114,3280120,3280129,3282244,3282250,3282259,3284368,3284374,3284383,3286494,3286505,3288645,3299214,3301293,3303360,3305415,3307462,3309506,3325722,3325727,3325729,3325738,3325747,3327996,3327998,3328007,3328016,3330381,3330390,3330399,3332769,3339901,3339910,3339916,3342240,3342249,3342255,3344601,3344610,3344616,3346953,3346962,3346968,3349296,3349305,3349311,3351624,3351633,3351639,3353945,3353954,3353960,3356263,3356272,3356278,3358611,3358620,3358626,3360976,3360985,3360991,3363333,3363342,3363348,3365677,3365686,3365692,3368013,3368022,3368028,3370341,3370350,3370356,3372662,3372671,3372677,3374976,3374985,3374991,3375075,3375082,3375095,3375098,3375108,3377285,3377294,3377300,3377384,3377391,3377404,3377407,3377417,3379594,3379600,3379684,3379691,3379704,3379707,3379717,3381967,3381974,3381987,3381990,3382000,3384243,3384251,3384266,3384270,3384281,3386517,3386525,3386540,3386544,3386555,3388777,3388785,3388800,3388804,3388815,3391031,3391039,3391054,3391058,3391069,3393274,3393282,3393297,3393301,3393312,3395503,3395511,3395526,3395530,3395541,3397719,3397727,3397742,3397746,3397757,3399926,3399934,3399949,3399953,3399964,3402120,3402128,3402143,3402147,3402158,3402192,3402200,3402204,3402219,3402227,3402232,3402255,3404303,3404311,3404326,3404330,3404341,3404375,3404383,3404387,3404402,3404410,3404415,3404438,3406475,3406483,3406498,3406502,3406513,3406547,3406555,3406559,3406574,3406582,3406587,3406610,3408671,3408675,3408686,3408720,3408728,3408732,3408747,3408755,3408760,3408783,3410826,3410837,3410871,3410879,3410883,3410898,3410906,3410911,3410934,3413000,3413008,3413012,3413027,3413035,3413040,3413050,3413058,3413063,3413092,3413093,3413097,3415154,3415162,3415166,3415181,3415189,3415194,3415204,3415212,3415217,3415246,3415247,3415251,3417296,3417304,3417308,3417323,3417331,3417336,3417346,3417354,3417359,3417388,3417389,3417393,3419428,3419436,3419440,3419455,3419463,3419468,3419478,3419486,3419491,3419520,3419521,3419525,3421549,3421564,3421572,3421577,3421587,3421595,3421600,3421629,3421630,3421634,3423653,3423661,3423666,3423676,3423684,3423689,3423718,3423719,3423723,3425733,3425743,3425751,3425756,3425785,3425786,3425790,3427791,3427799,3427804,3427833,3427834,3427838,3429835,3429864,3429865,3429869,3431878,3431879,3431883,3431915,3431917,3431922,3431926,3431937,3431939,3431942,3431944,3433885,3433886,3433890,3433922,3433924,3433929,3433933,3433944,3433946,3433949,3433951,3435885,3435886,3435890,3435922,3435924,3435929,3435933,3435944,3435946,3435949,3435951,3437872,3437873,3437877,3437909,3437911,3437916,3437920,3437931,3437933,3437936,3437938,3439845,3439846,3439850,3439882,3439884,3439889,3439893,3439904,3439906,3439909,3439911,3441811,3441812,3441816,3441848,3441850,3441855,3441859,3441870,3441872,3441875,3441877,3443774,3443778,3443810,3443812,3443817,3443821,3443832,3443834,3443837,3443839,3445749,3445781,3445783,3445788,3445792,3445803,3445805,3445808,3445810,3447932,3447934,3447939,3447943,3447954,3447956,3447959,3447961,3450075,3450077,3450082,3450086,3450097,3450099,3450102,3450104,3452210,3452212,3452217,3452221,3452232,3452234,3452237,3452239,3454334,3454336,3454341,3454345,3454356,3454358,3454361,3454363,3456453,3456455,3456460,3456464,3456475,3456477,3456480,3456482,3456499,3458577,3458579,3458584,3458588,3458599,3458601,3458604,3458606,3458623,3460707,3460709,3460714,3460718,3460731,3460733,3460736,3460738,3460757,3462837,3462839,3462844,3462848,3462861,3462863,3462866,3462868,3462887,3464987,3464989,3464994,3464998,3465011,3465013,3465016,3465018,3465037,3467133,3467138,3467142,3467155,3467157,3467160,3467162,3467181,3469315,3469328,3469330,3469333,3469335,3469354,3471490,3471492,3471495,3471497,3471516,3473644,3473646,3473649,3473651,3473670,3475800,3475802,3475805,3475807,3475826,3477950,3477952,3477955,3477957,3477976,3480092,3480094,3480097,3480099,3480118,3482226,3482229,3482231,3482250,3484358,3484377,3486495,3488604,3490737,3492863,3494983,3497140,3503602,3505730,3507853,3509969,3512081,3514183,3516277,3518364,3520450,3522524,3524592,3526648,3536993,3537001,3539019,3539027,3541058,3541066,3543119,3543127,3545167,3545175,3547205,3547213,3549239,3549247,3551281,3551289,3553318,3553326,3555359,3555367,3557389,3557397,3559407,3559415,3561416,3561424,3563416,3563424,3565436,3565444,3567452,3567460,3569475,3569483,3571494)) 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





	Olga Kishnyova (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Olga Kishnyova (Dancer)

Olga Kishnyova (Dancer)

Biography

She was born in Moscow. She graduated from the Moscow State Choreographic Academy (class of Tatyana Goltseva) and joined the Ballet Company of the Bolshoi Theater. While studying she dances the 11th waltz in the school performance Chopiniana on the stage of the Bolshoi Theater. She was a holder of a Maris Liepa fellowship.
In 2006 she graduated from the Department of “Choreographic arts”, the Bolshoi Ballet Academy with qualifications of “ballet dancer” and “teacher-repetiteur”.
Her teacher-repetiteur is Svetlana Adyrkhaeva.

Repertoire

2001
Fiends to Giselle (Giselle by A. Adam; choreography by Jean Coralli, Jules Perrot, Marius Petipa in the version by Y. Grigorovich and V. Vasiliev)
Role in the ballet Passacaille to music by Anton von Webern (Roland Petit production) — was among the creators of the ballet at the Bolshoi Theater

2002
Friends to Lise (La Fille mal gardee. Music by Louis Herold; choreography by Frederick Ashton) — was among the creators of the ballet at the Bolshoi Theater
Juno (creator of the role), Pallas (A dance scene in Adriana Lecouvreur, by F. Cilea, choreography by A. Petukhov) 
Friends to Shireen (A Legend of Love. Music by Arif Melikov, production by Yuri Grigorovich)
The 11th waltz (Chopiniana to music by F. Chopin, choreography by Mikhail Fokine)
Two wilises (Giselle)

2003
1st and 2nd variation in Raimonda’ s Dreams (Raimonda by A.Glazunov. Choreography by M. Petipa in the version of Y. Grigorovich)
Waltz (Swan Lake; choreography by Alexander Gorsky, Marius Petipa, Lev Ivanov in the 2nd version by Yuri Grigorovich)
Flowers (Cipollino. Music by Karen Khachaturyan. Production by Genrikh Mayorov)
Final Waltz and Apotheosis (Nutcracker, by P. Tchaikovsky, choreography by Y. Grigorovich)
The 2nd variation in Grand Pas (Don Quixote by L.Minkus, choreography by Marius Petipa, Alexander Gorsky in the version by A. Fadeechev)

2004
Maids of honor, Tender fairy, Gold Fairy, (The Sleeping Beauty by P.Tchaikovsky, choreography by M. Petipa, Y. Grigorovich version)
Four sylphs (Herman Levenskiold’s La Sylphide; choreography by August Bournonville in a version by E.M. Rosen)
Two pairs in part II (Symphony C-major to music by G. Bizet, choreography by G. Balanchine)
Three swans (Swan Lake, choreography by L. Ivanov)
Magnolia (Cipollino)
Grand pas (La Bayadère by L. Minkus. Choreography by M. Petipa, Yuri Grigorovich production)
Girls (Yuri Krasavin’s Magrittomania; choreography by Yuri Possokhov) 
Pikkilia(Don Quixote, by L.Minkus, choreography by M. Petipa, A. Gorsky; A. Fadeyechev version)
Neva (Cesare Pugni’s La Fille du Pharaon; Pierre Lacotte production after Marius Petipa) 
Indian doll (Nutcracker
Sweet pea (A Midnight’s Summer Dream to the music of F. Mendelssohn Bartholdy and G. Ligeti, choreography by John Neumeier) 
Clemence (Raymonda)

2005
Neapolitan bride (Swan Lake)
Typists (The Bolt by D. Shostakovich, choreography by A.Ratmansky) 
Temptation (Les Presages to music by P, Tchaikovsky. Choreography by Leonide Massine) — was among the creators of this ballet in Russia
Friends to Prince (Swan Lake)
Tobacco girls (Carmen Suite to music by Bizet-Shchedrin, A. Alonso production)

2006
Waltz soloists (Cinderella by S. Prokofiev, Y. Possokhov and Y. Borisov production) 
Caryatides (La Fille du Pharao by C. Pugni, Pierre Lacotte production after Marius Petipa)
Mimes (A. Khachaturian’s Spartacus, choreography by Y. Grigorovich)

2007
Russian bride (Swan Lake in the 2nd version by Yuri Grigorovich)
Odalisque (Le Corsaire by A. Adam. Production and new choreography by Alexei Ratmansky and Yuri Burlaka after Marius Petipa) — was among the creators of this ballet

2008
The 1st sylph (Herman Levenskiold’s La Sylphide; choreography by August Bournonville in a version by Johan Kobborg)
Waltz/tango (The Golden Age by D. Shostakovich. Production by Yuri Grigorovich) 
Furies (participant of the opening night performance), Bride’s ghost (Boris Asfiev’s The Flames of Paris. Production and new choreography by Alexei Ratmansky after Vasily Vainonen) 
Soloist (Grand Pas classique for the ballet Paquita by L.Minkus, choreography by M. Petipa, new choreographic version by Y. Burlaka) — was among the creators

2009
Two fashionable pairs (The Golden Age by D. Shostakovich. Production by Yuri Grigorovich)

2010
Friends to Juliet (Romeo and Juliet by S. Prokofiev, production by Yuri Grigorovich)

2011
Friends to Lucien (Illusions perdues. Music by Leonid Desyatnikov, choreography by Alexei Ratmansky) —participant of the opening night performance

2012
Title role in The Diamonds (Part III of Jewels, music by P. Tchaikovsky, choreography by G. Balanchine)
Gypsies (Anyuta to music by Valery Gavrilin; choreography by Vladimir Vasiliev )

In 2002 she took part in IV annual concert of young ballet stars from Russian theaters in Perm. There she danced the 7th waltz from Chopiniana.