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 (8404,8422,8430,8436,10111,10128,10137,10139,11694,11711,11720,11722,13277,13294,13303,13305,14653,14658,14757,16106,16112,16211,16946,16952,16982,16988,17018,17024,17054,17060,17090,17096,17716,17722,17821,19215,20655,22142,23596,25059,26837,27782,29172,31007,32523,34045,35584,37125,37139,37162,38672,38687,38709,38759,40139,40159,40207,41643,43037,44396,45748,47093,48434,49766,51094,52413,53728,55037,56340,57704,59773,61837,63892,105610,105619,105651,105689,105718,107505,107513,107545,107583,107612,109391,109399,109432,109470,109499,111276,111309,111347,111376,113145,113178,113216,113245,115039,115077,115106,116915,116953,116982,118790,118831,118857,120660,120701,120726,122526,122567,122591,124384,124425,124449,126233,126274,126298,128114,128138,129942,129967,131771,131796,133604,133629,135429,135454,137250,137275,139067,139093,140877,140903,142678,142703,144468,144493,146249,146273,148044,149801,151551,153295,198436,199753,201070,202752,204426,205850,206131,207548,207829,209236,209517,210900,211182,212414,212715,213952,214255,215488,215791,217019,217322,218548,218851,220071,220374,221406,221430,221590,221893,222920,222944,223104,223407,224429,224453,224613,224916,225934,225958,226124,226426,227439,227463,227629,227931,228938,228962,229128,229430,230923,230947,231113,231415,232918,232942,233108,233410,234908,234932,235098,235400,236893,236917,237083,237385,238867,238891,239057,239359,240833,240857,241023,241325,242794,242818,242984,243285,244751,244775,244944,245246,246709,246729,246897,247197,248656,248676,248844,249144,250600,250620,250788,251088,252583,252603,252771,253071,254557,254576,254745,255045,256521,256544,256710,257010,258482,258502,258670,258983,260448,260472,260637,260950,262408,262432,262597,262910,264374,264395,264563,264876,266334,266355,266523,266836,268286,268310,268474,268787,270227,270251,270415,270728,272166,272189,272354,272667,274122,274153,274287,274600,276056,276087,276221,276534,277980,278012,278148,278464,279857,279889,280025,280341,281725,281756,281893,282209,283615,283752,284068,285472,285609,285925,287326,287464,287779,289174,289272,289273,289300,289301,289308,289323,289326,289335,289341,289621,291007,291105,291106,291138,291139,291145,291161,291164,291173,291176,291521,292903,293001,293002,293034,293035,293041,293057,293060,293069,293072,293417,294889,294890,294922,294923,294930,294946,294949,294958,294961,295306,296770,296771,296802,296803,296810,296826,296829,296838,296841,297186,298648,298649,298681,298682,298685,298700,298703,298712,298718,299060,300519,300520,300551,300552,300555,300570,300573,300582,300588,300932,302406,302407,302439,302440,302446,302462,302465,302474,302477,302823,304288,304289,304322,304323,304328,304344,304347,304356,304358,304704,306214,306215,306251,306252,306257,306275,306279,306288,306290,306635,308138,308139,308175,308176,308181,308199,308203,308212,308214,308560,310056,310057,310093,310094,310099,310117,310121,310130,310132,310477,311970,311971,312007,312008,312013,312031,312035,312044,312046,312391,312398,313879,313880,313916,313917,313922,313940,313944,313953,313955,314300,314307,315784,315785,315820,315822,315827,315845,315849,315858,315860,316205,316212,317682,317683,317719,317720,317725,317743,317747,317756,317758,318103,318110,319572,319573,319609,319610,319614,319633,319637,319646,319648,319993,320000,321451,321452,321488,321489,321493,321512,321516,321525,321528,321872,321879,323321,323322,323357,323358,323363,323382,323386,323395,323398,323742,323749,325216,325217,325253,325254,325258,325277,325281,325290,325292,325647,325654,327120,327121,327154,327155,327157,327172,327181,327187,327192,327554,327561,329015,329016,329052,329053,329058,329076,329080,329089,329091,329453,329460,330906,330907,330944,330945,330949,330967,330971,330980,330982,331346,331353,332792,332793,332829,332830,332835,332853,332857,332866,332869,333232,333239,334703,334704,334710,334728,334732,334741,334744,335107,335114,336569,336570,336575,336594,336598,336607,336610,336974,336980,338436,338437,338441,338459,338464,338473,338476,338855,338861,340316,340317,340322,340341,340345,340354,340356,340783,340791,342240,342241,342246,342265,342269,342278,342280,342319,342339,342353,342368,342409,342707,342715,344161,344162,344170,344188,344191,344200,344205,344242,344263,344279,344292,344332,344631,344639,346077,346078,346086,346104,346107,346116,346121,346158,346179,346190,346208,346248,346554,346562,347984,347985,347994,348011,348014,348023,348028,348065,348086,348097,348115,348155,348461,348469,349874,349875,349883,349901,349903,349913,349918,349955,349976,349988,350005,350044,350351,350359,351761,351777,351784,351791,351795,351834,351855,351871,351882,351926,352232,352238,353639,353657,353659,353669,353674,353712,353731,353744,353761,353800,354109,354116,355527,355534,355541,355546,355585,355604,355616,355632,355672,355993,355999,357404,357411,357419,357424,357462,357481,357493,357509,357549,357870,357876,359311,359318,359326,359330,359369,359388,359400,359416,359454,359776,359783,361210,361217,361225,361229,361268,361287,361299,361315,361353,361677,361684,363109,363118,363122,363159,363178,363194,363208,363247,363566,363574,364998,365002,365042,365061,365073,365089,365133,365450,365458,366878,366882,366920,366939,366957,366969,367012,367329,367338,368756,368760,368799,368819,368830,368846,368884,369207,369214,370630,370670,370689,370701,370717,370761,371078,371086,372534,372553,372565,372581,372625,372942,372950,374389,374407,374420,374436,374480,374796,374805,376231,376252,376265,376281,376325,376641,376650,378067,378087,378101,378116,378159,378477,378485,379899,379920,379934,379949,379992,380310,380318,381726,381748,381762,381776,381820,382138,382146,383550,383571,383584,383599,383640,383959,383967,385366,385383,385397,385412,385456,385774,385782,387173,387194,387209,387222,387263,387581,387590,389002,389018,389034,389075,389393,389401,390806,390817,390833,390876,391193,391202,392606,392622,392633,392672,392996,393002,394400,394416,394430,394469,394788,394796,396191,396204,396219,396261,396582,396588,396688,397989,398004,398044,398367,398373,398472,399771,399781,399826,400143,400151,400252,401535,401551,401590,401913,401920,402019,403309,403354,403671,403679,403780,405067,405105,405429,405436,405537,406819,406858,407181,407188,407287,408566,408604,408928,408935,409034,410344,410668,410675,410774,412111,412435,412442,412541,413868,414193,414199,414298,415610,415935,415942,416041,417349,417678,417685,417784,419089,419418,419425,419524,420829,421151,421158,421259,422559,422881,422888,422987,424283,424605,424613,424714,426320,426327,426426,428018,428026,428125,429712,429720,429819,431427,431434,431533,433130,433136,433246,434827,434834,434944,436521,436528,436638,438203,438211,438321,439872,439879,439989,441527,441535,441646,443169,443177,443289,444802,444807,444919,446424,446429,446543,448037,448043,448156,449640,449646,449759,451230,451237,451350,452820,452827,452940,454408,454415,454528,455988,455995,456108,457375,457562,457569,457682,458941,459128,459136,459249,460497,460684,460692,460805,462045,462232,462241,462353,463597,463784,463793,463905,465145,465332,465341,465453,466687,466875,466883,466995,468385,468576,468587,468702,470085,470285,470296,470417,471636,471836,471847,471968,473178,473378,473389,473510,474758,474958,474969,475090,476535,476546,476667,477966,478011,478110,478121,478242,479533,479578,479681,479690,479813,481101,481146,481848,481893,482586,482631,483320,483365,484059,484107,484809,484858,485555,485603,486292,486341,487017,487065,487735,487780,488446,488490,489205,489914,490616,491314,492001,492679,493361,494038,494710,495375,497355,497357,497400,497432,497442,497591,498819,498821,498864,498896,498906,499053,500274,500277,500320,500352,500366,500509,501728,501731,501774,501806,501816,501963,503218,503223,503266,503295,503308,503457,504699,504702,504744,504777,504792,504934,506171,506173,506218,506249,506263,506406,507642,507644,507689,507721,507733,507878,509113,509156,509190,509204,509347,510622,510654,510668,510810,512076,512109,512124,512266,513524,513557,513567,513741,514997,515026,515039,515214,516458,516492,516502,516678,517912,517946,517958,518132,519357,519390,519400,519576,520799,520832,520842,521018,522269,522279,522454,523696,523711,523886,525115,525130,525305,526524,526540,526710,527928,527945,528115,529331,529348,529519,530731,530743,530919,532137,532314,533524,533699,534963,535133,536557,537987,539357,539380,539411,540773,540796,540827,542205,542224,542259,543652,543668,543706,545121,545138,545176,546575,546591,546628,548031,548047,548084,549481,549498,549535,550924,550941,550978,552360,552377,552413,553784,553801,553837,555200,555218,555253,556607,556624,556660,558010,558032,558062,559407,559428,559459,560800,560821,560852,562186,562202,562238,563568,563584,563620,564938,564960,564990,566301,566322,566354,567660,567679,567710,569013,569035,569067,570363,570383,570415,571717,571754,573097,573130,574469,574502,575865,577223,578575,579916,581249,582575,583897,583970,583977,583992,584028,585287,585290,585305,585347,586595,586602,586616,586653,587901,587904,587919,587961,589197,589200,589215,589257,590838,590841,590859,590896,592455,592458,592473,592514,594081,594088,594107,594142,595785,595788,595807,595841,597475,597477,597496,597531,599156,599158,599177,599212,600827,600831,600850,600884,602504,602507,602526,602561,604172,604174,604193,604228,605830,605832,605851,605886,607481,607499,607535,609138,609173,610825,610860,612506,612541,614178,614214,615876,615940,616017,616045,617530,617589,617665,617694,619165,619227,619302,619330,620795,620854,620931,620959,622419,622481,622556,622584,624033,624095,624170,624198,625658,625720,625795,625823,627275,627334,627414,627436,628939,629017,629041,630534,630613,630637,632123,632202,632230,633707,633786,633814,635280,635358,635387,636842,636920,636949,638399,638473,638502,639938,640012,640040,641468,641542,641570,642987,643062,643090,644497,644575,644604,646003,646081,646110,647505,647579,647607,649069,649097,650563,650591,652045,652073,653521,653549,654987,655014,656442,656469,657889,657917,659338,659366,660774,660802,662200,662229,663625,663653,665034,665062,666441,666472,667876,667907,669299,669330,670766,672192,673609,675014,676413,693892,693917,695165,696395,697614,698821,875876,875899,878563,878586,881247,881270,883933,883956,886608,886631,889273,889296,891934,891958,894589,894613,897243,897267,899898,899920,902535,902557,905189,907805,910419,913029,1082787,1085131,1087460,1089780,1092110,1094432,1096741,1099038,1101315,1103585,1105834,1108067,1110274,1112459,1114627,1116780,1118914,1121046,1123186,1125318,1127509,1129730,1131937,1134126,1136329,1138531,1140729,1142920,1145103,1847808,1849960,1852106,1854246,1856389,2112801,2114706,2116608,2118500,2120381,2122252,2124112,2125956,2127794,2129623,2131443,2133254,2135055,2136845,2138686,2678771,2681153,2683523,2685891,2688247,2690597,2692935,2695259,2697924,2700998,2704080,2707152,2710188,2713223,2716247,2719312,2722386,2934921,2937416,2939917,2942414,2944901,2947371,2949820,2952260,2954705,2957186,2959661,2962123,2964561,2966981,2969395,2971813,2974205,3030857,3030867,3032271,3032284,3033675,3033686,3035267,3035278,3036850,3036859,3038418,3038428,3039978,3039988,3041528,3041538,3043071,3043081,3044609,3044621,3046143,3046151,3047659,3047669,3049176,3050684,3222700,3222710,3222727,3222742,3222754,3224364,3224377,3224391,3224407,3224417,3225993,3226006,3226022,3226035,3226046,3227608,3227622,3227637,3227654,3227662,3229226,3229238,3229254,3229271,3229279,3230850,3230860,3230877,3230892,3230903,3232465,3232476,3232494,3232509,3232518,3234076,3234089,3234100,3234116,3234127,3235675,3235688,3235699,3235715,3235728,3237259,3237272,3237283,3237299,3237311,3238828,3238841,3238855,3238872,3238882,3240396,3240405,3240423,3240438,3240449,3241998,3242012,3242023,3242040,3242050,3243603,3243618,3243636,3243645,3245186,3245199,3245218,3245226,3246786,3246804,3246818,3246830,3248388,3248404,3248416,3249958,3249976,3249984,3251525,3251539,3251550,3253101,3253109,3254700,3254708,3256708,3256720,3256729,3258720,3258732,3258742,3260728,3260739,3262710,3262718,3264690,3264702,3266677,3268664,3268681,3270711,3270732,3272856,3274968,3277061,3279148,3281285,3357971,3360317,3362678,3365034,3367373,3369703,3372029,3374346,3376657,3378965,3381261,3383531,3385816,3388084,3390343,3392593,3394831,3397052,3399267,3401470,3403662,3405842,3408010,3410174,3412319,3414486,3416633,3418774,3420897,3422999,3425079,3427139,3429180,3431205,3433197,3433217,3435203,3435219,3437198,3437215,3439179,3439196,3441145,3441162,3443110,3443127,3445084,3445102,3447236,3447254,3449384,3449402,3451523,3451540,3453654,3453671,3455776,3455792,3457900,3457916,3460022,3460040,3462160,3462178,3464286,3464301,3466435,3466453,3468615,3468631,3470783,3470801,3472939,3472956,3475095,3475112,3477246,3477264,3479392,3479410,3481531,3481550,3483682,3485804,3487913,3490022,3492166,3492170,3494289,3494293,3496405,3496409,3498556,3498562,3500707,3504995,3505010,3507118,3507134,3509241,3509255,3511354,3511367,3513461,3513477,3515562,3515572,3517663,3519748,3521826,3523896,3550629,3552674,3554705,3556745,3558771,3560782,3562781,3564784,3566803,3568817,3570835,3572846,3574855,3576765,3578665,3580562,3582451,3584312,3586170,3588022,3589876,3591725,3593569,3595523,3597514,3599494,3807829,3808205,3808578,3816960,3817313,3817657,3817677,3817680,3817697,3818045,3818063,3818066,3818083,3818449,3818466,3818470,3818488,3818864,3818867,3818885,3819255,3819259,3819276,3819646,3819648,3819666,3820033,3820037,3820051,3820416,3820419,3820436,3820798,3820813,3821188,3821558,3821922,3822286,3822648,3994300,3994317,3994836,3995359,3995876,3996385,3998403,3998909,4035089,4035448,4036350,4037249,4051491,4052370,4053244,4125936,4126621,4127307,4127989,4128668,4129341,4130014,4130683)) 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





	Ivan Oskorbin (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Ivan Oskorbin (Dancer)

Ivan Oskorbin (Dancer)

• Prize-winner at the XXV Theatre festival Paradise in the category “Best Male Role in Ballet” as Conrad in the ballet Le Corsaire (Novosibirsk, 2012) 
• Recipient of the Gold Medal at the XII Youth Delphi Games of Russia in the category “Classical Dance” 
• Recipient of the Silver Medal at the XIII Youth Delphi Games of Russia in the category “Classical Dance” (2014) 
• Diploma-recipient at the XXVI International Ballet Competition in Varna (Bulgaria, 2014)

Graduated from the Novosibirsk State School of Dance in 2009. From 2008-2014 he was a lead soloist with the Novosibirsk Opera and Ballet Theatre. Has performed roles in the ballets Giselle (Count Albrecht), Swan Lake (Prince, von Rothbart), La Bayadиre (Solor), The Sleeping Beauty (Prince Fortunй, Bluebird), Le Corsaire (Conrad), Don Quixote(Espada), The Nutcracker (the Nutcracker Prince; choreography by Vasily Vainonen), The Nutcracker (Prince Orshad; choreography by Lev Ivanov, Vasily Vainonen and Sergei Vikharev), Spartacus (Crassus, choreography by Yuri Grigorovich), Michel Fokine’s Chopiniana, Roland Petit’s Carmen (Escamillo) and George Balanchine’s Who Cares?. 
Joined the Mariinsky Ballet in 2014.