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 (38765,40213,41660,41694,43056,43087,44412,44446,45764,45797,47109,47142,48453,48484,49782,49815,51115,51143,52434,52462,53749,53777,55058,55086,56355,56389,57722,57754,59789,59824,61853,61887,63907,63942,65954,65989,67999,68034,70041,70076,72078,72113,74108,74143,76161,78171,80177,82176,84168,86153,88131,221396,221406,221428,221431,222910,222920,222942,222945,224419,224429,224450,224454,225924,225934,225955,225959,227429,227439,227460,227464,228928,228938,228959,228963,230913,230923,230944,230948,232908,232918,232938,232943,234898,234908,234928,234933,236882,236893,236912,236918,238858,238867,238886,238892,240824,240833,240852,240858,242784,242794,242813,242819,244741,244751,244770,244776,246695,246709,246724,246730,248642,248656,248671,248677,250585,250600,250615,250621,252569,252583,252598,252604,254541,254557,254572,254577,256506,256521,256536,256545,258467,258482,258497,258503,260433,260448,260463,260473,262393,262408,262423,262433,264359,264374,264390,264396,266319,266334,266350,266356,268286,268302,268311,270227,270242,270252,272166,272181,272190,274114,274123,274168,274185,276048,276057,276102,276119,277977,277981,278027,278044,279854,279858,279904,279921,281726,281772,281789,283631,283648,285487,285505,287342,287359,289189,289205,289275,289323,289327,289331,289353,291023,291040,291112,291161,291165,291169,291190,292919,292936,293008,293057,293061,293065,293085,294808,294825,294897,294946,294950,294953,294974,296688,296705,296777,296826,296830,296834,296854,298563,298579,298655,298700,298704,298708,298732,300450,300526,300570,300574,300578,300603,302341,302413,302462,302466,302470,302491,304225,304295,304344,304348,304352,304375,306219,306275,306280,306284,306307,308143,308199,308204,308208,308231,310061,310117,310122,310125,310149,311976,312031,312036,312039,312063,313885,313940,313945,313948,313972,315790,315845,315850,315853,315877,317688,317743,317748,317751,317775,319578,319633,319638,319641,319665,321457,321512,321517,321520,321544,323327,323382,323387,323390,323414,325222,325277,325282,325285,325309,327126,327172,327182,327184,327210,329021,329076,329081,329084,329108,330912,330967,330972,330975,330999,332798,332853,332858,332861,332885,334673,334728,334733,334736,334760,336594,336599,336602,336625,338459,338465,338468,338492,340341,340346,340350,340374,342265,342270,342274,342298,342302,342314,342319,342385,342401,344188,344192,344198,344220,344225,344238,344242,344309,344324,346104,346108,346114,346136,346141,346154,346158,346225,346240,348011,348015,348021,348043,348048,348060,348065,348132,348147,349901,349905,349911,349933,349938,349950,349955,350022,350037,351777,351786,351789,351810,351816,351828,351834,351895,351918,353657,353661,353667,353688,353694,353706,353712,353777,353793,355527,355535,355539,355561,355567,355579,355585,355646,355665,357404,357412,357417,357438,357444,357456,357462,357523,357542,359311,359319,359323,359345,359351,359363,359369,359430,359449,361210,361218,361222,361244,361250,361262,361268,361329,361348,363110,363114,363138,363142,363154,363159,363224,363241,364995,365021,365025,365036,365042,365109,365125,366875,366899,366904,366914,366920,366989,367005,368774,368780,368794,368799,368860,368880,370647,370652,370663,370670,370737,370753,372511,372517,372527,372534,372601,372617,374366,374371,374382,374389,374455,374471,376211,376216,376226,376231,376300,376316,378051,378061,378067,378134,378151,379884,379894,379899,379967,379984,381722,381726,381795,381812,383546,383550,383614,383633,385361,385366,385430,385448,387173,387237,387256,389049,389067,390848,390868,392653,392667,394446,394463,396238,396253,398021,398038,399795,399818,401566,401585,403323,403346,405081,405100,406834,406852,408580,408599,410320,410339,412088,412106,413845,413863,415606,417348,419085,420821,422551,457352,457375,458919,458941,460475,460497,462023,462045,463575,463597,465122,465145,466664,466687,468385,470085,471636,473178,474758,477966,477985,478053,479533,479554,479624,481101,481118,481848,481863,482586,482601,483320,483336,484059,484080,484809,484831,485555,485576,486292,486314,487017,487038,487735,487753,488446,488462,489176,489885,490587,491284,497349,497355,497367,497415,497441,497452,497482,498813,498819,498831,498879,498905,498916,498944,500268,500274,500287,500333,500360,500372,500399,501722,501728,501741,501788,501815,501826,501854,503215,503218,503229,503281,503304,503316,503342,504693,504699,504712,504757,504786,504797,504824,506171,506183,506236,506258,506269,506296,507642,507652,507706,507729,507741,507769,509124,509169,509199,509210,509238,510587,510633,510662,510673,510701,512042,512095,512118,512129,512157,513537,513566,513577,513606,515008,515038,515049,515078,516472,516501,516513,516540,517926,517955,517966,517994,519376,519399,519410,519438,520818,520841,520852,520880,522254,522278,522289,522317,523683,523705,523718,523745,525101,525124,525136,525164,526535,526546,526574,527939,527950,527978,529342,529353,529381,530742,530752,530781,532136,532148,532174,533523,533533,533562,534967,534993,536392,536417,537822,537848,539271,539357,539380,540687,540773,540796,542121,542205,542224,543567,543652,543668,545037,545121,545138,546575,546591,548031,548047,549481,549498,550924,550941,552360,552377,553784,553801,555200,555218,556607,556624,558010,558032,559407,559428,560800,560821,562186,562202,563568,563584,564938,564960,566301,566322,567660,567679,569013,569035,570363,570383,571717,573097,574469,583944,583959,583969,584028,584043,585258,585277,585286,585347,585357,586565,586583,586594,586653,586665,587871,587891,587900,587961,587972,589167,589187,589196,589257,589268,590807,590827,590837,590896,590909,592426,592445,592454,592514,592526,594054,594074,594085,594142,594155,595753,595773,595784,595841,595855,597463,597474,597531,597545,599143,599155,599212,599226,600816,600826,600884,600898,602493,602503,602561,602574,604170,604228,604242,605829,605886,605900,607535,607549,609173,609188,610860,610875,612541,612555,614214,614228,615876,615892,616023,617530,617541,617672,619165,619175,619308,620795,620807,620937,622419,622429,622562,624033,624043,624176,625658,625668,625801,627275,627286,627416,628891,629021,630487,630617,632076,632206,633790,635362,636924,638477,640016,641549,643068,644579,646085,647586,649076,650569,652052,653528,654994,656448,656451,657896,657898,659344,659347,660781,660784,662207,662211,663626,663631,665040,665045,666448,666453,667883,667888,669307,669309,670742,670747,672173,693917,694026,694046,695165,695274,695294,696395,696507,696525,697614,697727,697744,698821,698934,698951,700129,700147,701318,701336,702514,702534,703698,703716,704873,704890,706030,706051,707176,707196,708305,708327,709433,709448,710579,710594,711719,711735,712857,712872,713981,714001,715095,715110,716198,716212,717290,717310,718373,718392,719443,719463,720522,721571,722622,859681,862398,865104,867799,870483,873166,875849,875881,875892,878536,878568,878579,881219,881252,881263,883905,883938,883949,886584,886613,886624,889279,889289,891941,891951,894595,894606,897255,897260,899902,899913,902539,902549,905172,905181,907798,910412,921203,921224,923879,923907,926573,926596,929287,929313,931997,932018,934701,934726,937406,937431,940140,940162,942858,942879,945563,945584,948265,948286,950971,950992,953671,953692,956361,956382,959037,959058,961691,961713,964331,964352,966967,966988,969599,969620,972226,972248,974846,974874,977459,977486,980066,980093,982657,982684,985246,985267,987870,987891,990489,990510,993099,993127,995709,995731,995791,995870,998302,998325,998386,998464,1000908,1000970,1001048,1003490,1003551,1003629,1006064,1006124,1006202,1008637,1008691,1008769,1011196,1011250,1011328,1013775,1013830,1013907,1016395,1016472,1018942,1019019,1021489,1021566,1024034,1024111,1026568,1026649,1029098,1029178,1031624,1031704,1034126,1034207,1036616,1036696,1039108,1039185,1041592,1041669,1044068,1044145,1046535,1046612,1048991,1049069,1051513,1053943,1056370,1058792,1061201,1063602,1065996,1068380,1070750,1073149,1075542,1075613,1077925,1077996,1080296,1080367,1082656,1082727,1082811,1085000,1085072,1085157,1087328,1087398,1087486,1089649,1089720,1089805,1092050,1092135,1094372,1094457,1096681,1096767,1098976,1099063,1101253,1101341,1103524,1103612,1105773,1105862,1108001,1108090,1110211,1110297,1112398,1112483,1114565,1114652,1116804,1118935,1118953,1121070,1121081,1123210,1123226,1125344,1125358,1127530,1127549,1129756,1129769,1131960,1131973,1134149,1134164,1136353,1136368,1138555,1138568,1140753,1140772,1142943,1142963,1145126,1145146,1147296,1147316,1149452,1149472,1151605,1151625,1153756,1153767,1155893,1155910,1158082,1160246,1162391,1330773,1332655,1334530,1336388,1338240,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,1716139,1718909,1721664,1724406,1727145,1729877,1732593,1735297,1737992,1740674,1743340,1746002,1748655,1751300,1753938,1756567,1971118,2112775,2114681,2116579,2118471,2120352,2122222,2124083,2125931,2127765,2129594,2475955,2478891,2481815,2484725,2487631,2490573,2493503,2496423,2499331,2502226,2505107,2507975,2510838,2513699,2516553,2519402,2522239,2525066,2527882,2530692,2533495,2536293,2539083,2541873,2544655,2547420,2550184,2552984,2555777,2558581,2561381,2564164,2566933,2569736,2572567,2575384,2578193,3000356,3002674,3004970,3007202,3009389,3011570,3013727,3015870,3018009,3020202,3029456,3030857,3030882,3032271,3032299,3033675,3033706,3035267,3035298,3036850,3036877,3038418,3038446,3039978,3040006,3041528,3041555,3043071,3043102,3044609,3044638,3046143,3046169,3047659,3047686,3049192,3050703,3052203,3053694,3055175,3064572,3064626,3064644,3066295,3066345,3066362,3068003,3068054,3068072,3069703,3069751,3069770,3071390,3071442,3071456,3073068,3073123,3073135,3074738,3074790,3074807,3076397,3076449,3076464,3078049,3078105,3078123,3079711,3079764,3079777,3081361,3081411,3081431,3083000,3083048,3083069,3084622,3084677,3084696,3086277,3086332,3086346,3087919,3087974,3087993,3089554,3089607,3089621,3091174,3091227,3091245,3092839,3092859,3094439,3094458,3096033,3096049,3097619,3097638,3099195,3099213,3100766,3100784,3102323,3102343,3103866,3103884,3105405,3105423,3106957,3106977,3108522,3110086,3111644,3222696,3222727,3222730,3222733,3222740,3222748,3222754,3222759,3222782,3222787,3224362,3224391,3224394,3224400,3224405,3224413,3224417,3224424,3224447,3224452,3225991,3226022,3226024,3226030,3226032,3226042,3226046,3226052,3226074,3226079,3227605,3227637,3227642,3227646,3227650,3227656,3227662,3227669,3227690,3227695,3229221,3229254,3229256,3229263,3229267,3229274,3229279,3229286,3229308,3229313,3230844,3230877,3230879,3230884,3230888,3230897,3230903,3230910,3230932,3230937,3232462,3232494,3232498,3232501,3232503,3232516,3232518,3232526,3232547,3232551,3234072,3234100,3234104,3234111,3234113,3234122,3234127,3234133,3234155,3234161,3235671,3235699,3235704,3235707,3235711,3235722,3235728,3235733,3235754,3235760,3237255,3237283,3237290,3237293,3237296,3237304,3237311,3237317,3237338,3237344,3238823,3238855,3238858,3238861,3238865,3238877,3238882,3238886,3238909,3238913,3240392,3240423,3240426,3240429,3240435,3240441,3240449,3240454,3240477,3240482,3242023,3242030,3242032,3242038,3242045,3242050,3242058,3242078,3242085,3243618,3243621,3243628,3243631,3243637,3243645,3243650,3243675,3243678,3245199,3245203,3245208,3245211,3245222,3245226,3245234,3245257,3245261,3246804,3246807,3246810,3246815,3246825,3246830,3246834,3246859,3246860,3248388,3248393,3248395,3248401,3248412,3248416,3248421,3248445,3248446,3249958,3249961,3249968,3249972,3249978,3249984,3249992,3250015,3250018,3251525,3251526,3251530,3251536,3251544,3251550,3251555,3251577,3251584,3253086,3253092,3253095,3253104,3253109,3253117,3253140,3253144,3254689,3254694,3254704,3254708,3254716,3254738,3254742,3256706,3256715,3256720,3256725,3256748,3256752,3258725,3258732,3258736,3258759,3258764,3260725,3260728,3260735,3260756,3260759,3262710,3262717,3262737,3262741,3264690,3264697,3264721,3264725,3266673,3266697,3266702,3268658,3268681,3268687,3268720,3270732,3270734,3270767,3272856,3272861,3272895,3274968,3274973,3275003,3277061,3277065,3277099,3279148,3279155,3279187,3281285,3281289,3281320,3283414,3283446,3285568,3287714,3289851,3291966,3294069,3296170,3298264,3341388,3343724,3343934,3346077,3346289,3348434,3348641,3350772,3350978,3353089,3353300,3355414,3355619,3357739,3357950,3357974,3358036,3360084,3360294,3360319,3360380,3362449,3362656,3362684,3362742,3364805,3365013,3365037,3365096,3367140,3367350,3367375,3367435,3369470,3369680,3369705,3369764,3371799,3372007,3372033,3372089,3374112,3374325,3374348,3374408,3376430,3376637,3376663,3376722,3378734,3378757,3378943,3378968,3379027,3381032,3381055,3381238,3381266,3381324,3383321,3383508,3383534,3383591,3385608,3385794,3385819,3385878,3387876,3388061,3388085,3388145,3390135,3390322,3390346,3390405,3392390,3392573,3392598,3392655,3394809,3394833,3394893,3397033,3397055,3397116,3399248,3399272,3399329,3401448,3401475,3401533,3403519,3403539,3403574,3403639,3403664,3403725,3405698,3405719,3405753,3405821,3405843,3405903,3407870,3407886,3407918,3407989,3408011,3408071,3410032,3410048,3410083,3410154,3410177,3410237,3412177,3412190,3412227,3412296,3412322,3412380,3414346,3414363,3414399,3414465,3414488,3414549,3416491,3416509,3416545,3416612,3416639,3416697,3418633,3418649,3418686,3418753,3418780,3418840,3420756,3420767,3420804,3420873,3420900,3420960,3422873,3422911,3422977,3423003,3423061,3424955,3424989,3425057,3425083,3425144,3427052,3427117,3427142,3427200,3429093,3429159,3429185,3429244,3431118,3431184,3431211,3431271,3433130,3433193,3433220,3433279,3435129,3435197,3435223,3435283,3437128,3437195,3437221,3437278,3439105,3439173,3439198,3439260,3441141,3441164,3441226,3443105,3443130,3443188,3445080,3445106,3445161,3447234,3447260,3447315,3449382,3449405,3449463,3451521,3451542,3451600,3453652,3453674,3453734,3455769,3455796,3455854,3457897,3457919,3457978,3460017,3460043,3460102,3462156,3462180,3462239,3464279,3464308,3464365,3466430,3466457,3466516,3468612,3468638,3468693,3470777,3470805,3470862,3472933,3472959,3473018,3475088,3475115,3475174,3477241,3477269,3477327,3479389,3479416,3479472,3481552,3481611,3483686,3483743,3485807,3485864,3487916,3487974,3490026,3490082,3492154,3492195,3492213,3494316,3494335,3496432,3496450,3498585,3498605,3500729,3500748,3502863,3502882,3504995,3505013,3507118,3507139,3509241,3509260,3511354,3511373,3513461,3513481,3515562,3515578,3517664,3519752,3521828,3523901,3525961,3534214,3536255,3538283,3540304,3542376,3544432,3546472,3548509,3550542,3552584,3554616,3556657,3816975,3817323,3817672,3818057,3818460,3818858,3819247,3819640,3836709,3836967,3837225,3837481,3837736,3844013,3844270,3844526,3844779,3845029,3845283,3845535,3845785,3845795,3846041,3846284,3846523,3852387,3852393,3852513,3852981,3852986,3853104,3853578,3853694,3854165,3854285,3854868,3855451,3856033,3856612,3857188,3857806,3858427,3859228,3860029,3860824,3861624,3862413,3863203,3863991,3864774,3865555,3866332,3867106,3867880,3868651,3869416,3870185,3870948,3871706,3872456,3873192,3873947,3874704,3875450,3876202,3876948,3877688,3878435,3879173,3879916,3880657,3881399,3882146,3882884,3883625,3884369,3885104,3885840,3886575,3887311,3888046,3888775,3889503,3890232,3890954,3891675,3892392,3893108,3893819,3894537,3895257,3895970,3897409,3898114,3898819,3899516,3900215,3900934,3901648,3902364,3903074,3923727,3924401,3925070,3925734,3926399,3926409,3927062,3927071,3927721,3927730,3928377,3928387,3929032,3929043,3929686,3929696,3930344,3930991,3931636,3932281,3953304,3953309,3953314,3953320,3953922,3953930,3953933,3953936,3954535,3954540,3954544,3954549,3955150,3955155,3955158,3955759,3955763,3955769,3956370,3963665,3964240,3964809,3965377,3965963,3979880,3980463,3981043,3994300,3994317,3994836,3995359,3995876,3996385,4035077,4035089,4035099,4035448,4035456,4036350,4036357,4037249,4037255,4038176,4039088,4051504,4052383,4053257,4054128,4054994,4055864,4056726,4125928,4126615,4127299,4127980,4128657,4129333,4132034,4132707,4133375,4134041,4134705,4135368,4136028,4136682,4137335,4137984,4279223,4279348,4279471,4279592,4279751,4279906)) 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





	Tatiana Tkachenko (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Tatiana Tkachenko (Dancer)
			

																
Tatiana Tkachenko (Dancer)

														
				


        




    

        
Born in Leningrad (St Petersburg).
Graduated from the Vaganova Academy of Russian Ballet in 2000.
Joined the Mariinsky theatre in 2000.
Her repertoire includes:
Giselle (Myrtha, Monna, Zulma);
Le Corsaire (Gulnara, The three Odalisques);
The Sleeping Beauty (Fleur de Farine, Fee Diamant);
Raymonda (Raymonda, Dream);
Don Quixote (Street dancer, Flower-sellers, Lady Dryad);
The Fountain of Bakhchisarai (Zarema);
The Legend of Love ( Mekhmeneh Bahnu, Gold);
The Young Lady and the Hooligan (Leader‘s Girl-friend);
Manon (Manon);
The Nutcracker (The Queen of the Snowflakes, The Canteen-Girl);
The Vertiginous Thrill of Exactitude;
In the Middle, Somewhat Elevated;
The Magic Nut (Temptress);
Ondine (Two naiads, Four naiads);
Naina‘s Magic Dances (in opera by Mikhail Glinka Ruslan and Lyudmila).
Copyright © 1998-2006 The State Academic Mariinsky 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