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 (20005,20007,20008,20015,20017,20025,20030,20031,20044,21440,21442,21443,21450,21452,21460,21465,21466,21479,21492,21494,21495,21502,21504,21512,21517,21518,21531,22946,22948,22949,22956,22958,22966,22971,22972,22985,24401,24402,24408,24410,24418,24423,24424,24437,25884,25886,25887,25893,25895,25903,25908,25909,25922,26171,26181,26188,26214,26226,26251,26282,26285,26323,27571,27584,27592,27623,27635,27667,27686,27692,27730,30345,30347,30348,30354,30356,30364,30369,30370,30383,31835,31837,31848,31855,31856,31875,33359,33360,33379,33437,34884,34910,39556,39558,39573,39576,39578,39591,39609,40983,41000,42411,42418,42429,42431,42443,42467,42492,43796,43803,43814,43816,43828,43851,43876,45153,45160,45171,45173,45185,45208,45232,46509,46520,46522,46534,46557,46581,47852,47863,47865,47877,47900,47924,49189,49200,49202,49214,49237,49262,50532,50534,50546,50569,50593,51856,51858,51870,51893,51917,53173,53175,53187,53210,53234,54486,54488,54500,54523,54547,55795,55807,55830,55854,57174,57197,57221,59249,59272,59296,61318,61341,61365,63379,63402,63426,65431,65454,65478,67478,67501,67525,69547,69571,71587,71611,73620,73644,75645,75669,77659,77683,79668,79692,81672,81696,83670,83694,85660,85684,87666,87735,87780,87789,87817,89639,89708,89753,89762,89789,91602,91672,91719,91726,91753,93559,93628,93673,93682,93709,95509,95579,95624,95633,95660,97454,97524,97569,97578,97605,99390,99460,99505,99514,99540,101385,101430,101439,101465,103300,103345,103354,103380,105205,105250,105259,105285,107101,107147,107156,107182,108995,109041,109051,109076,110879,110923,110933,110958,112751,112798,112807,112831,114617,114662,114672,114697,116475,116518,116527,116553,118347,118390,118399,118426,120220,120263,120272,120299,122090,122133,122142,122169,123953,123996,124005,124031,125808,125851,125860,125886,127652,127698,127707,127731,129488,129532,129542,129567,131317,131361,131371,131396,133146,133190,133199,133225,134975,135019,135029,135054,136798,136842,136852,136877,138618,138662,138671,138697,140431,140475,140484,140510,142280,142289,142314,144076,144085,144110,145861,145870,145895,147636,147645,147670,149404,149413,149438,151160,151169,151194,152906,152915,152940,154642,154651,154679,156369,156378,156406,158085,158094,158122,159793,159802,159827,161525,161550,163246,163271,165018,166754,168484,170199,171908,173609,183823,185461,187089,188707,190314,191909,193493,195080,195462,195844,196226,201854,203532,205204,206908,208602,210260,211827,213360,214898,216431,217962,219487,221008,222525,224037,225545,227053,228556,230053,232037,234031,236019,237999,239969,241932,243892,245850,247800,251706,251707,251710,251711,251735,251761,251764,251768,251769,253686,253687,253690,253691,253715,253741,253744,253748,253749,255658,255659,255662,255663,255687,255715,255716,255720,255721,257622,257623,257626,257627,257651,257679,257683,257684,257685,259593,259594,259597,259598,259622,259650,259654,259655,259660,261558,261559,261562,261563,261587,261615,261619,261624,261625,263516,263517,263520,263521,263545,263571,263574,263578,263579,265480,265481,265484,265485,265509,265535,265538,265542,265543,267440,267441,267465,267491,267494,267498,267499,269412,269440,269444,269445,269446,271352,271380,271384,271385,271390,273290,273318,273322,273327,273328,275220,275253,275256,275260,275261,277150,277183,277186,277190,277191,279074,279098,279101,279106,279107,280947,280971,280974,280979,280980,282812,282835,282838,282843,282844,284671,284693,284696,284700,284701,286526,286550,286553,286558,286559,288399,288402,288406,288407,288412,290242,290245,290249,290250,290255,292143,292146,292150,292151,292156,294037,294040,294044,294045,294050,295924,295927,295931,295932,295937,297802,297805,297809,297810,297815,299677,299680,299684,299685,299690,301573,301576,301580,301581,301586,303461,303464,303468,303469,303474,303484,303488,303546,303550,303551,303554,305392,305395,305399,305400,305405,305415,305419,305477,305481,305482,305485,307322,307325,307329,307330,307335,307345,307349,307407,307411,307412,307415,309245,309248,309252,309253,309258,309268,309272,309330,309334,309335,309338,311163,311166,311170,311171,311176,311186,311190,311248,311252,311253,311256,313077,313080,313084,313085,313090,313100,313104,313162,313166,313167,313170,314984,314988,314991,314992,314997,315009,315013,315070,315074,315075,315078,316890,316894,316895,316900,316910,316914,316972,316976,316977,316980,318788,318789,318794,318804,318808,318866,318870,318871,318874,320678,320688,320692,320750,320754,320755,320758,322564,322568,322626,322630,322631,322634,324433,324437,324495,324499,324500,324503,326337,326341,326399,326403,326404,326407,328241,328245,328303,328307,328308,328311,330137,330141,330199,330203,330204,330207,332034,332090,332094,332095,332098,333971,333975,333976,333979,335842,335846,335847,335850,337707,337711,337712,337715,339587,339591,339592,339595,341515,341519,341520,341523,343436,343440,343441,343445,345356,345360,345361,345365,347275,347279,347280,347284,349180,349183,349184,349187,351066,351070,351071,351075,352944,352948,352949,352953,354820,354824,354825,354829,356700,356704,356705,356708,358571,358575,358576,358580,358591,358594,358596,358597,360474,360478,360479,360483,360494,360497,360499,360500,360548,362371,362375,362376,362380,362391,362394,362396,362397,362445,364262,364266,364267,364271,364278,364282,364284,364286,364333,366142,366146,366147,366152,366159,366162,366165,366166,366214,368019,368023,368024,368028,368039,368042,368043,368045,368073,368074,368079,368082,368091,368107,368108,369897,369901,369902,369906,369913,369917,369919,369921,369951,369952,369955,369958,369968,369983,369984,371764,371769,371770,371774,371781,371784,371787,371788,371819,371820,371822,371825,371836,371851,371852,373629,373630,373634,373641,373645,373648,373649,373676,373680,373683,373686,373696,373711,373712,375484,375491,375495,375498,375499,375526,375530,375532,375536,375546,375561,375562,377332,377335,377338,377339,377367,377371,377373,377377,377387,377402,377403,379166,379169,379172,379173,379201,379205,379207,379211,379221,379236,379237,380997,381000,381003,381004,381008,381032,381036,381041,381042,381052,381067,381068,382822,382825,382828,382829,382833,382860,382861,382866,382867,382877,382892,382893,384644,384647,384648,384652,384679,384680,384683,384684,384696,384711,384712,386459,386460,386464,386491,386492,386497,386498,386508,386523,386524,388268,388295,388296,388301,388302,388312,388327,388328,390103,390104,390109,390110,390120,390135,390136,391903,391904,391909,391910,391920,391935,391936,393702,393703,393708,393709,393719,393734,393735,395497,395498,395503,395504,395514,395529,395530,397286,397287,397292,397293,397303,397318,397319,399067,399068,399072,399073,399085,399101,399102,400843,400844,400849,400850,400859,400875,400876,402608,402609,402613,402614,402623,402640,402641,404365,404367,404370,404371,404383,404396,404397,406122,406123,406127,406128,406137,406154,406155,407873,407874,407878,407879,407888,407905,407906,409616,409617,409622,409623,409632,409649,409650,411356,411357,411362,411363,411372,411387,411389,413124,413125,413134,413150,413151,414885,414901,414902,416627,416643,416644,418368,418384,418385,420104,420120,420121,421850,421851,421883,421898,423579,423580,423607,423627,425301,425302,425330,425349,427009,427010,427037,427057,428707,428708,428734,428756,430433,430448,432135,432156,433844,433861,435539,435556,437227,437244,438920,440584,442235,443873,467614,467616,467618,467619,467642,469319,469321,469323,469324,469347,471035,471036,471039,471040,471062,472584,472585,472588,472589,472611,474107,474109,474111,474113,474118,474119,474125,474127,474129,474130,474153,475687,475689,475691,475693,475698,475699,475705,475707,475709,475710,475733,477264,477266,477268,477271,477275,477276,477283,477284,477287,477288,477310,478838,478839,478841,478843,478849,478850,478856,478858,478860,478861,478884,480405,480406,480408,480411,480416,480417,480423,480425,480427,480428,480451,481157,481159,481161,481164,481168,481169,481176,481177,481180,481181,481203,481902,481903,481905,481907,481912,481913,481920,481922,481924,481925,481948,482639,482640,482642,482644,482649,482650,482657,482659,482661,482662,482685,483375,483377,483379,483384,483385,483391,483393,483395,483396,483419,484119,484121,484126,484127,484133,484135,484137,484138,484164,484870,484875,484876,484882,484884,484886,484887,484913,485618,485619,485625,485627,485629,485630,485656,486355,486357,486359,486360,486386,487076,487078,487080,487081,487107,487790,487792,487794,487795,487821,488502,488504,488506,488507,488533,489214,489216,489218,489219,489245,489923,489925,489926,489952,490625,490626,490652,491347,492032,492715,493397,494073,494742,495403,496052,496690,498160,501095,501109,501115,501151,501155,501159,501163,501167,501169,502544,502559,502563,502598,502602,502606,502610,502614,502617,504029,504043,504048,504081,504085,504089,504094,504097,504102,505506,505518,505526,505561,505565,505569,505573,505577,505579,506977,506990,506997,507029,507033,507037,507042,507045,507050,508449,508462,508469,508501,508505,508509,508514,508517,508522,509929,509936,509971,509975,509976,509981,509984,509989,511389,511396,511431,511435,511439,511443,511447,511449,512843,512848,512883,512887,512891,512894,512899,512901,514320,514327,514362,514366,514370,514374,514378,514380,515796,515832,515836,515840,515844,515848,515850,517257,517293,517297,517301,517305,517309,517311,518744,518748,518752,518756,518760,518762,520186,520190,520195,520198,520203,520206,521629,521633,521637,521641,521645,521647,523061,523065,523070,523073,523078,523081,524486,524490,524495,524498,524503,524506,525904,525908,525912,525916,525920,525922,527311,527315,527319,527323,527327,527329,528717,528721,528725,528729,528733,528735,530120,530124,530128,530133,530137,530139,531518,531522,531526,531531,531535,531537,532908,532912,532916,532921,532925,532927,534346,534350,534354,534358,534363,534367,535777,535781,535785,535791,535795,535797,537203,537207,537212,537217,537221,537223,538631,538635,538640,538645,538649,538652,540056,540061,540066,540069,540073,541473,541476,541481,541485,541504,541507,541511,541512,542928,542932,542934,542953,542958,542961,542962,544409,544411,544432,544435,544439,544440,545879,545898,545903,545906,545907,547333,547352,547357,547360,547361,548807,548811,548814,548815,550256,550261,550264,550265,551697,551702,551705,551706,553130,553134,553137,553138,554551,554556,554559,554560,555963,555968,555971,555972,557369,557373,557377,557378,557385,557393,558769,558773,558777,558778,558785,558793,560166,560170,560174,560175,560183,560190,561560,561564,561565,561573,561580,562951,562952,562960,562967,564336,564345,565703,565711,567063,567072,568421,568430,568438,568452,568463,568464,569783,569792,569806,569817,569818,571126,571135,571149,571160,571161,572509,572517,572532,572543,572544,573889,573898,573912,573923,573924,575267,575281,575292,575293,576627,576641,576652,576653,577983,577998,578009,578010,579333,579349,579359,579360,580687,580697,580698,582016,582026,582027,583346,583357,583358,584666,584677,584678,585979,585990,585991,586000,586002,586004,586009,586013,587287,587299,587300,587309,587311,587313,587318,587322,588600,588601,588610,588612,588614,588619,588623,589894,589895,589911,589915,589920,589927,589931,591514,591515,591531,591535,591540,591547,591551,593170,593174,593179,593186,593190,594874,594877,594883,594888,594895,596571,596574,596580,596585,596592,598258,598263,598267,598274,598278,599936,599942,599947,599954,601624,601631,601635,603300,603307,604970,642149,642153,642157,642161,642187,642188,643665,643669,643673,643677,643704,643705,645178,645182,645187,645191,645214,645215,646684,646689,646693,646719,646721,648184,648188,648214,648216,649687,649713,649715,651201,651203,652682,652684,652698,652707,654154,654156,654170,654179,655615,655617,655631,655640,657066,657068,657082,657091,658521,658523,658537,658546,659976,659986,661412,661421,662836,662845,664253,664262,665672,667111,688076,688088,688123,688129,688135,688136,688142,689375,689387,689422,689428,689434,689435,689441,690673,690708,690714,690720,690721,690727,691949,691984,691990,691996,691997,692003,693215,693249,693255,693261,693262,693267,694506,694512,694518,694519,694525,695745,695751,695757,695758,695764,696971,696977,696983,696984,696990,698184,698190,698196,698197,698203,699386,699392,699398,699399,699405,700580,700586,700592,700593,700599,701767,701773,701779,701780,701786,702959,702965,702971,702972,702978,704146,704152,704153,704159,705322,705323,705329,706479,844476,844486,844532,847214,847225,847271,849947,849957,850004,850019,850020,852676,852686,852733,852748,852749,855406,855417,855463,855478,855479,858131,858141,858188,858203,858204,860851,860861,860907,860923,860924,863563,863573,863619,863635,863636,866264,866273,866320,866335,866336,868953,868963,869010,869025,869026,871637,871647,871694,871709,871710,874321,874330,874377,874391,874392,877000,877011,877056,877072,877073,879684,879695,879740,879756,879757,882364,882375,882420,882436,882437,885047,885058,885103,885119,885120,887717,887728,887775,887785,887791,890382,890393,890438,890454,890455,893042,893053,893098,893114,893115,895700,895711,895756,895772,895773,898360,898407,898417,898423,901007,901051,901066,901067,903688,903701,903702,906312,906325,906326,908927,908940,908941,911540,911550,911556,914177,914187,914193,916885,916896,916897,919585,919599,919600,919654,919662,919663,919669,919684,919690,919723,919724,919737,919743,922271,922285,922286,922341,922347,922348,922354,922370,922376,922409,922410,922423,922428,924971,924986,924987,925040,925046,925048,925053,925071,925078,925109,925110,925124,925129,927663,927677,927678,927733,927741,927742,927748,927763,927770,927803,927804,927816,927821,930376,930390,930391,930446,930453,930454,930461,930476,930483,930516,930517,930529,930534,933095,933096,933151,933159,933160,933167,933181,933189,933222,933223,933236,933240,935804,935805,935860,935868,935869,935875,935890,935898,935931,935932,935944,935949,938505,938506,938571,938579,938580,938589,938605,938611,938650,938651,938665,938668,941293,941302,941303,941312,941329,941335,941373,941375,941389,941392,944006,944016,944017,944026,944041,944047,944086,944087,944102,944106,946707,946713,946714,946723,946744,946752,946794,946795,946806,946809,949409,949415,949421,949431,949451,949460,949488,949497,949510,949516,952116,952125,952127,952136,952152,952158,952198,952199,952212,952215,954808,954814,954820,954830,954850,954859,954887,954896,954909,954915,957494,957504,957505,957514,957528,957535,957574,957575,957590,957595,960156,960165,960166,960174,960189,960195,960236,960238,960251,960256,962804,962805,962806,962815,962836,962843,962886,962887,962900,962906,965442,965451,965452,965459,965474,965481,965521,965522,965536,965541,968074,968083,968084,968091,968106,968113,968153,968154,968168,968173,970702,970708,970714,970724,970744,970753,970780,970789,970802,970808,973324,973330,973336,973346,973366,973375,973403,973412,973425,973431,975951,975952,975960,975976,975984,976023,976024,976039,976043,978573,978590,978597,978636,978638,978652,978656,981188,981193,981234,981235,981250,981254,983778,983783,983822,983823,983839,983843,986404,986410,986449,986450,986466,986470,989026,989033,989070,989071,989088,989092,991646,991655,991683,991692,991705,991711,991715,994258,994295,994296,994313,994316,994321,996894,996895,996911,996915,996921,999480,999481,999499,999503,999509,1002062,1002063,1002081,1002085,1002091,1002124,1002131,1002137,1002144,1002146,1004641,1004650,1004663,1004669,1004673,1004702,1004708,1004713,1004719,1004724,1004744,1007210,1007219,1007232,1007238,1007242,1007271,1007277,1007282,1007288,1007293,1007313,1009774,1009775,1009793,1009797,1009804,1009836,1009843,1009848,1009854,1009856,1009873,1012325,1012334,1012347,1012353,1012357,1012386,1012392,1012397,1012403,1012408,1012428,1014916,1014920,1014925,1014960,1014966,1014971,1014979,1014980,1014995,1017473,1017479,1017483,1017512,1017518,1017523,1017529,1017534,1017554,1020020,1020026,1020030,1020059,1020065,1020070,1020076,1020081,1020101,1022566,1022572,1022605,1022612,1022616,1022623,1022624,1022642,1025113,1025142,1025148,1025153,1025159,1025164,1025184,1027673,1027679,1027684,1027690,1027695,1027716,1030198,1030205,1030210,1030217,1030219,1030241,1032709,1032715,1032720,1032726,1032731,1032752,1035204,1035210,1035215,1035221,1035226,1035247,1037692,1037698,1037704,1037710,1037711,1037735,1037751,1037792,1037793,1037818,1037819,1040177,1040183,1040189,1040195,1040196,1040220,1040236,1040277,1040278,1040303,1040304,1042661,1042667,1042673,1042674,1042698,1042714,1042753,1042755,1042780,1042781,1045138,1045143,1045144,1045169,1045185,1045224,1045226,1045250,1045251,1047611,1047612,1047630,1047646,1047685,1047687,1047710,1047711,1050080,1050097,1050135,1050137,1050161,1050162,1052516,1052533,1052570,1052571,1052597,1052598,1054945,1054963,1054997,1055003,1055026,1055031,1057371,1057389,1057423,1057429,1057452,1057457,1059790,1059808,1059842,1059848,1059871,1059876,1062211,1062248,1062249,1062275,1062276,1064610,1064644,1064650,1064673,1064678,1066996,1067031,1067033,1067065,1067066,1069407,1069408,1069434,1069436,1071775,1071777,1071801,1071802,1071868,1071871,1071897,1071899,1074169,1074175,1074203,1074204,1074261,1074269,1074292,1074300,1076556,1076562,1076585,1076590,1076653,1076659,1076681,1076687,1078932,1078938,1078961,1078966,1079029,1079035,1079057,1079063,1081299,1081302,1081327,1081328,1081395,1081396,1081422,1081425,1083651,1083653,1083679,1083680,1083745,1083746,1083774,1083778,1086016,1086017,1086081,1086082,1086112,1086116,1088338,1088339,1088402,1088405,1088436,1088439,1090674,1090679,1090742,1090748,1090770,1090776,1093001,1093003,1093064,1093067,1093099,1093101,1095384,1095390,1095412,1095418,1097684,1097690,1097712,1097718,1097750,1097756,1097766,1099962,1099965,1099994,1099995,1100027,1100035,1100049,1102235,1102237,1102265,1102266,1102299,1102307,1102321,1104493,1104494,1104523,1104524,1104557,1104565,1104579,1106729,1106731,1106760,1106762,1106794,1106801,1106814,1108977,1108978,1109010,1109017,1109030,1111171,1111174,1111205,1111212,1111225,1113348,1113352,1113386,1113391,1113402,1115542,1115549,1115560,1117682,1117689,1117701,1119817,1119824,1119836,1121947,1121954,1121966,1124085,1124092,1124104,1126280,1126287,1126299,1128471,1128479,1128489,1130690,1130703,1132899,1135088,1137293,1139494,1141689,1152565,1152569,1152601,1152604,1152608,1152618,1152623,1152630,1152633,1152660,1152667,1152668,1154713,1154717,1154749,1154750,1154756,1154766,1154772,1154781,1154782,1154808,1154811,1154819,1156849,1156853,1156885,1156886,1156891,1156905,1156909,1156915,1156916,1156946,1156956,1156957,1159018,1159021,1159058,1159059,1159063,1159072,1159078,1159082,1159083,1159109,1159117,1159118,1161173,1161176,1161210,1161211,1161218,1161227,1161233,1161237,1161238,1161265,1161274,1161275,1163312,1163316,1163348,1163351,1163355,1163365,1163370,1163377,1163380,1163407,1163414,1163415,1165445,1165448,1165482,1165483,1165491,1165499,1165504,1165509,1165510,1165536,1165544,1165545,1167581,1167585,1167617,1167620,1167624,1167634,1167639,1167646,1167649,1167676,1167683,1167684,1169715,1169749,1169750,1169758,1169766,1169771,1169776,1169777,1169803,1169811,1169812,1171871,1171872,1171880,1171888,1171893,1171898,1171899,1171925,1171933,1171935,1173984,1173987,1173991,1174001,1174006,1174013,1174016,1174043,1174050,1174051,1176130,1176133,1176137,1176147,1176152,1176159,1176162,1176189,1176196,1176197,1178265,1178268,1178272,1178282,1178287,1178294,1178297,1178324,1178331,1178332,1180393,1180396,1180400,1180410,1180415,1180422,1180425,1180452,1180459,1180460,1182512,1182515,1182519,1182529,1182534,1182541,1182544,1182571,1182578,1182579,1184622,1184625,1184629,1184639,1184644,1184651,1184654,1184681,1184688,1184689,1186736,1186737,1186743,1186751,1186755,1186766,1186767,1186788,1186796,1186797,1188842,1188843,1188849,1188857,1188861,1188872,1188873,1188894,1188902,1188903,1190948,1190957,1190961,1190971,1190972,1190993,1191001,1191002,1193043,1193048,1193059,1193060,1193087,1193089,1193090,1195122,1195127,1195138,1195139,1195166,1195168,1195169,1197198,1197203,1197214,1197215,1197242,1197244,1197245,1199269,1199276,1199279,1199306,1199313,1199314,1201337,1201340,1201367,1201374,1201375,1203393,1203394,1203421,1203432,1203433,1205470,1205477,1205478,1207507,1207514,1207515,1209536,1209543,1209544,1211578,1211588,1211589,1213606,1213613,1213614,1215628,1215635,1215636,1217644,1217645,1227627,1229641,1231650,1233647,1235633,1237615,1239583,1241539,1243522,1276650,1276653,1276660,1276711,1276715,1276727,1276728,1276733,1276771,1276780,1278507,1278512,1278518,1278568,1278572,1278580,1278581,1278591,1278626,1278636,1280357,1280361,1280365,1280375,1280420,1280423,1280431,1280432,1280441,1280473,1280481,1280491,1282198,1282203,1282206,1282213,1282265,1282268,1282277,1282278,1282285,1282315,1282322,1282332,1284033,1284037,1284042,1284048,1284098,1284102,1284110,1284111,1284121,1284147,1284156,1284166,1285857,1285861,1285866,1285872,1285922,1285926,1285934,1285935,1285945,1285971,1285980,1285990,1287668,1287672,1287677,1287683,1287733,1287737,1287745,1287746,1287756,1287782,1287791,1287801,1289462,1289466,1289471,1289477,1289527,1289531,1289539,1289540,1289550,1289576,1289585,1289595,1291247,1291251,1291256,1291262,1291312,1291316,1291324,1291325,1291335,1291361,1291370,1291380,1293057,1293061,1293066,1293072,1293122,1293126,1293134,1293135,1293145,1293171,1293180,1293190,1294863,1294868,1294874,1294924,1294928,1294936,1294937,1294947,1294973,1294982,1294992,1296663,1296669,1296719,1296723,1296731,1296732,1296742,1296768,1296777,1296787,1298455,1298505,1298509,1298517,1298518,1298528,1298554,1298563,1298573,1300276,1300280,1300288,1300289,1300299,1300325,1300334,1300344,1302035,1302039,1302048,1302050,1302058,1302086,1302094,1302104,1303784,1303788,1303796,1303797,1303807,1303833,1303842,1303852,1305532,1305536,1305544,1305545,1305555,1305581,1305590,1305600,1307272,1307276,1307284,1307285,1307295,1307321,1307330,1307340,1309002,1309006,1309014,1309015,1309025,1309051,1309060,1309070,1310720,1310724,1310732,1310733,1310743,1310769,1310778,1310788,1312639,1312643,1312651,1312652,1312662,1312688,1312697,1312707,1314556,1314560,1314568,1314569,1314579,1314605,1314614,1314624,1316490,1316494,1316502,1316503,1316513,1316539,1316548,1316558,1318417,1318421,1318429,1318430,1318440,1318466,1318475,1318485,1320340,1320348,1320349,1320359,1320385,1320394,1320404,1322257,1322258,1322268,1322294,1322303,1322313,1324158,1324159,1324169,1324195,1324204,1324215,1326056,1326082,1326091,1326102,1327955,1327962,1327972,1329811,1329820,1329831,1329868,1329871,1331698,1331707,1331718,1331755,1331758,1333575,1333584,1333595,1333632,1333635,1335442,1335451,1335462,1335499,1335502,1337298,1337307,1337318,1337355,1337358,1339152,1339163,1339200,1339203,1340993,1341030,1341033,1342810,1342847,1342850,1344656,1344659,1346463,1346466,1348260,1348263,1350050,1350053,1351955,1351958,1353847,1353850,1355728,1355731,1357602,1381553,1381562,1381563,1381585,1381587,1381592,1383369,1383378,1383379,1383401,1383403,1383408,1385178,1385187,1385188,1385211,1385213,1385219,1386982,1386991,1386992,1387015,1387017,1387023,1388776,1388785,1388786,1388809,1388811,1388817,1390556,1390565,1390566,1390589,1390591,1390597,1392325,1392334,1392335,1392358,1392360,1392366,1394085,1394094,1394095,1394118,1394120,1394126,1395863,1395872,1395873,1395896,1395898,1395904,1395916,1397629,1397638,1397639,1397662,1397664,1397670,1397682,1399386,1399395,1399396,1399419,1399421,1399427,1399439,1401138,1401147,1401148,1401171,1401173,1401179,1401191,1402880,1402889,1402890,1402913,1402915,1402921,1402933,1404613,1404622,1404623,1404646,1404648,1404654,1404666,1406336,1406345,1406346,1406369,1406371,1406377,1406389,1408057,1408066,1408067,1408090,1408092,1408098,1408110,1409781,1409790,1409791,1409814,1409816,1409822,1409834,1411508,1411517,1411518,1411541,1411543,1411549,1411561,1413258,1413267,1413268,1413291,1413293,1413299,1413311,1415018,1415027,1415028,1415051,1415053,1415059,1415071,1416765,1416777,1416778,1416793,1416800,1416803,1416815,1418503,1418512,1418513,1418536,1418538,1418544,1418556,1420230,1420239,1420240,1420263,1420265,1420271,1420283,1421947,1421956,1421957,1421980,1421982,1421988,1422000,1423650,1423659,1423660,1423683,1423685,1423691,1423703,1425339,1425348,1425349,1425372,1425374,1425380,1425392,1427013,1427022,1427023,1427046,1427048,1427054,1427066,1428677,1428686,1428687,1428710,1428712,1428718,1428730,1430327,1430336,1430337,1430360,1430362,1430368,1430380,1431967,1431976,1431977,1432000,1432002,1432008,1432020,1433598,1433607,1433608,1433631,1433633,1433639,1433651,1435223,1435224,1435247,1435249,1435255,1435267,1436828,1436829,1436852,1436854,1436860,1436872,1438473,1438475,1438481,1438493,1440081,1440083,1440089,1440101,1441682,1441684,1441690,1441702,1443276,1443278,1443284,1443296,1444862,1444868,1444880,1446444,1446456,1448020,1449572,1463108,1463113,1463124,1464559,1464570,1466002,1467424,1545882,1545887,1546967,1546972,1548040,1548045,1549103,1549108,1550163,1550167,1551211,1551215,1552250,1552254,1553291,1553295,1554326,1554330,1555353,1555357,1556371,1556375,1557381,1557385,1558389,1558393,1559391,2754711,2757732,2760753,2763769,2766768,2769752,2772725,2775690,2778679,2781660,2784748,2787834,2790904,2793962,2797037,2880928,2883700,2886458,2889193,2891916,2894619,2897308,2900005,2902696,2905280,2907872,2910489,2913087,2915675,2918265,2920838,2923403,2925958,2928494,2931013,2933521,3325722,3325738,3328007,3330390,3413092,3413093,3413097,3415246,3415247,3415251,3417388,3417389,3417393,3419520,3419521,3419525,3421629,3421630,3421634,3423718,3423719,3423723,3425785,3425786,3425790,3427833,3427834,3427838,3429864,3429865,3429869,3431878,3431879,3431883,3431915,3431926,3433885,3433886,3433890,3433922,3433933,3435885,3435886,3435890,3435922,3435933,3437872,3437873,3437877,3437909,3437920,3439845,3439846,3439850,3439882,3439893,3441811,3441812,3441816,3441848,3441859,3443774,3443778,3443810,3443812,3443817,3443821,3445749,3445781,3445783,3445788,3445792,3447932,3447934,3447939,3447943,3450075,3450077,3450082,3450086,3452210,3452212,3452217,3452221,3454334,3454336,3454341,3454345,3456453,3456455,3456460,3456464,3456495,3458577,3458579,3458584,3458588,3458619,3460707,3460709,3460714,3460718,3460753,3462837,3462839,3462844,3462848,3462883,3464987,3464989,3464994,3464998,3465033,3467133,3467138,3467142,3467177,3469315,3469350,3471512,3473666,3475822,3477972,3480114,3482246,3484373,3486491,3488600,3490733,3492859,3494979,3497136)) 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
Anna Antropova (Dancer) - uVisitRussia
She was born in Moscow. In 1993 she graduated from the Moscow College of Choreography with distinction and in 1998 — also with distinction — the Department of “Choreographic arts” at the Bolshoi Ballet Institute with qualifications “ballet dancer” and “teacher-repetiteur”. (In 1995 the Сollege and the Institute were merged into the Moscow State Academy of Choreography). After graduation she joined the Bolshoi Ballet Company. Her teacher-repetiteur is Yuliana Malkhasyants. In 2008 she graduated from the Moscow State Academy of Choreography as manager.
Repertoire
1995
Friends to Giselle (Giselle by A. Adam; choreography by Jean Coralli, Jules Perrot, Marius Petipa production by Y. Grigorovich)
1996
Courtesans (A. Khachaturian’s Spartacus, choreography by Y. Grigorovich) Lorenzo’s wife (Don Quixote by L.Minkus, choreography by Marius Petipa, Alexander Gorsky in the version by Y. Grigorovich)
1997
Nancy (Herman Lovenskjold’s La Sylphide; choreography August Bournonville in a version by E. M. von Rosen) Folk dance (Romeo and Juliet by S. Prokofiev. Choreography by L. Lavrovsky)
1998
Mother Raddish, flowers (Cipollino. Music by Karen Khachaturyan. Genrikh Mayorov production) Krakowiak and mazur (Polish ball in Ivan Susanin by M. Glinka. choreography by R. Zakharov) Bolero (Don Quixote)
1999
Three gypsies ((Anyuta to music of V. Gavrilin, choreography by V. Vassiliev) Peasant dance (The Sleeping Beauty by P.Tchaikovsky, choreography by M. Petipa, Y. Grigorovich version) Spanish dance (Raimonda. Music by A. Glazunov, choreography Marius Petipa in the version by Y.Grigorovich) Gypsies (Rodion Shchedrin’s The Humpbacked Horse; production by N. Androsov) Gypsies (Balda to music by Dmitry Shostakovich. Vladimir Vasiliev production) Gypsy, Spanish dances, bolero ( Don Quixote, production by A. Fadeechev)
2000
Servants (Romeo and Juliet) Hungarian dance (Swan Lake by P. Tchaikovsky, V, Vasiliev version)
2003
Friends to Zina, milkmaid (The Bright Stream. Music by Dmitry Shostakovich. Alexei Ratmansky production) — was among the creators of the ballet Hungarian dance, mazur (Raimonda) Dance with a drum (La Bayadere; choreography by Marius Petipa, in the version by Yuri Grigorovich) Effi ( (La Sylphide) Friends to Lise (La Fille mal gardee. Music by Louis Herold; choreography by Frederick Ashton)
2004
Countesses Cherry (Cipollino) Anxious-to-be-younger-than-she-is Dacha Dweller (The Bright Stream)
Basya (Leah to music by Leonard Bernstein. Alexei Ratmansky production, the second version) — creator of the role Nurse (cook) (Ward # 6 to music by Arvo Part; Radu Poklitaru creation)
2005
Fermented Dough (The Bolt by D. Shostakovich, choreography by A.Ratmansky) — creator of the role Jota (was among the creators of this ballet in Russia), Miller’s Wife (Manuel de Falla’s Le Tricorne. Choreography by Leonide Massine) Flower girl (Gaite parisienne to music by Jacques Offenbach, in M. Rozental’s adaptation, choreography by L. Massine) — creator of the role in Russia Russian doll (Nutcracker by by P. Tchaikovsky, production by Yuri Grigorovich)
2006
Blue Angel (Snow White by S. Prokofiev, choreography by Y. Posokhov, production by Y. Borisov) — creator of the role Nepmen (The Golden Age by D. Shostakovich, production by Yuri Grigorovich)
2007
Soloist in the pirates dance/ danse des forbans (Le Corsaire. Production and new choreography by Alexei Ratmansky and Yuri Burlaka after Marius Petipa) — was among the creators of this ballet in Russia
2008
Effi (Herman Levenskiold’s La Sylphide; choreography by August Bournonville in a version by Johan Kobborg) Auvergne dance (Boris Asfiev’s The Flames of Paris. Production and new choreography by Alexei Ratmansky after Vasily Vainonen) — was among the creators of this ballet
2009
Mazur (participant of the opening night performance at the Bolshoi Theater), czardas (Coppelia. Choreography by M. Petipa and Enrico Cecchetti; revival and new choreographic version by Sergei Vikharev) “Old Paris waltz” (participant of the opening night performance), Megaera (Cesare Pugni’s La Esmeralda; Choreography by M. Petipa, production and new choreographic version by Y. Burlaka, V. Medvedev)
2010
Nurse to Juliet (Romeo and Juliet by S. Prokofiev. Production by Y. Grigorovich) 2nd dancer (Petrushka, by I. Stravinsky choreography by M. Fokin, new choreographic version by S. Vikharev)
2011
Berenice (Illusions perdues. Music by Leonid Desyatnikov, choreography by Alexei Ratmansky) Old Madge, a village sorceress (La Sylphide in a version by Johan Kobborg)
In 1998 she took part in the Bolshoi Theatre’s New Year Premieres of works by young choreographers, dancing in The Ups and Downs of Love" to the music of W.A. Mozart staged by Jörg Mannes.
In 2005 she participated in the Choreographers of the Bolshoi project (2nd Workshop of New Choreography), appearing in the piece Kiss of the wind by A. Rubtsov (choreography by A. Melanyin)
Sign in to our website using your Facebook or Google+ account.
Why Do You Need Our Travel Expert
Contact our experts, and they will help you to plan your best trip to Russia, with attention to every detail!
Our Experts have been in the travel industry for many years, guarantee to offer first class customer service, excellent value for money and unbiased advice. They are standing by to find and build your dream holiday to one of the world's most fascinating destinations - Russia. Your personal Travel Expert will guide you through each stage of the travel process, from choosing a program that fits you best to support during your trip.
Just tell us your e-mail, and we'll take care of everything!
Your tour request has been received. Thank you ! We have sent you the confirmation message to [email]
Please make sure that you receive this message (sometimes e-mail messages may go to the spam/junk mail). If you did not get this message, it means you will not get message with the tours' selection as well. If you use a Yahoo!, Gmail, AOL or Hotmail, we recommend to add request@uvisitrussia.comto your address book.
We recommend to leave your phone number. If we will not heard back that you received the e-mail with the tours' selection, we will contact you by phone. And you will not miss the best tour for you.
Thank you ! Your request for Travel Expert assistance has been sent. We will e-mail you within 1 hour.
Sorry, some changes needed
Add your E-mail
There was a problem with your request
Missing contact person. Please correct and try again.