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 (8399,8425,8457,10132,10158,11715,11741,13298,13324,14651,14673,14741,16102,16127,16195,17737,17805,19198,20642,22125,23579,25043,26798,27717,29132,30991,32505,34074,34091,34157,35548,37179,38726,40179,41610,43003,43124,43129,44364,44482,44487,45715,45834,45839,47060,47179,47184,48400,48521,48526,49733,49856,49860,51061,51184,51188,52380,52503,52507,53817,53821,55126,55130,56425,56430,57790,57794,59860,59864,61922,61926,63979,63982,66024,66028,68069,68073,70111,70115,72148,72152,74178,74182,76196,76200,78206,78210,80212,80216,82211,82215,84204,84208,86189,86193,88167,88171,90135,90139,92093,92097,94046,94050,95994,95999,97933,97938,99862,99867,101783,101788,103696,103697,105600,105645,107539,109425,111302,113170,115031,116907,118782,120657,122522,124380,221422,221428,221440,221444,222936,222942,222954,222958,224445,224450,224462,224467,225950,225955,225969,225974,227455,227460,227475,227479,228954,228959,228973,228978,230939,230944,230958,230963,232934,232938,232953,232958,234924,234928,234943,234948,236909,236912,236928,236933,238883,238886,238902,238907,240849,240852,240866,240873,242810,242813,242827,242834,244767,244770,244784,244791,246721,246724,246738,246745,248668,248671,248685,248692,250612,250615,250629,250635,252595,252598,252612,252618,254569,254572,254586,254592,256532,256536,256550,256556,258494,258497,258511,258517,260460,260463,260477,260483,262420,262423,262437,262443,264387,264390,264404,264410,266347,266350,266364,266370,268298,268302,268316,268322,270239,270242,270257,270263,272178,272181,272196,272202,274111,274114,274129,274135,274197,276045,276048,276062,276069,276131,277972,277977,277992,277998,278056,279854,279868,279874,279933,281736,281742,281801,283595,283601,283659,285452,285458,285516,287312,287371,289213,289275,289318,289327,289352,291049,291112,291156,291165,291188,292945,293008,293052,293061,293084,294838,294897,294940,294950,294973,296718,296777,296820,296830,296853,298592,298655,298695,298704,298731,300463,300526,300565,300574,300602,302350,302413,302456,302466,302490,304233,304295,304338,304348,304374,306159,306219,306268,306280,306306,308083,308143,308192,308204,308230,310061,310110,310122,310148,311976,312024,312036,312062,313885,313933,313945,313971,315790,315838,315850,315876,317688,317736,317748,317774,319578,319626,319638,319664,321457,321505,321517,321543,323327,323374,323387,323413,325222,325270,325282,325308,327126,327171,327182,327209,329021,329069,329081,329107,330912,330960,330972,330998,332798,332846,332858,332884,334673,334721,334733,334759,336587,336599,336624,338453,338465,338491,340334,340346,340373,342258,342270,342297,342302,342401,344181,344192,344219,344225,344324,346097,346108,346135,346141,346240,348004,348015,348042,348048,348147,349894,349905,349932,349938,350037,351773,351786,351809,351816,351918,353650,353661,353687,353694,353793,355523,355535,355560,355567,355665,357401,357412,357437,357444,357542,359308,359319,359344,359351,359449,361218,361243,361250,361348,363110,363136,363142,363241,365020,365025,365125,366898,366904,367005,368773,368780,368880,370646,370652,370753,372510,372517,372617,374365,374371,374471,376210,376216,376316,378051,378151,379884,379984,381812,383633,385448,387256,389067,390868,392667,394463,396253,398038,399818,401585,403346,405100,406852,408599,410339,412106,413863,415606,417348,419085,420821,422551,457335,458901,460458,478022,478023,478046,478047,478053,478054,479593,479594,479616,479619,479624,479625,484115,484866,485610,485612,492689,492691,493371,493373,494049,494050,494721,494724,495386,495387,497341,497346,497349,497350,497407,497452,498805,498810,498813,498814,498871,498916,500259,500266,500268,500269,500326,500372,501714,501720,501722,501723,501780,501791,501802,501826,503212,503215,503216,503275,503283,503291,503316,504693,504694,504751,504759,504772,504797,506228,506229,506244,506269,507699,507707,507715,507741,509163,509170,509185,509210,510627,510634,510649,510673,512087,512088,512104,512129,513531,513539,513553,513577,515003,515012,515023,515049,516465,516473,516487,516513,517919,517927,517941,517966,519363,519369,519385,519410,520810,520811,520827,520852,522247,522255,522264,522289,523676,523684,523692,523718,525102,525111,525136,526520,526546,527924,527950,528018,529327,529353,529422,530752,530822,532148,532214,533533,533601,534967,535036,536392,536458,537822,537887,539314,539398,540730,540814,542160,542246,543606,543689,545076,545159,546530,546613,547986,548069,549436,549518,550879,550961,552315,552396,553741,553824,555157,555240,556565,556647,558049,559446,560839,562225,563607,564977,566338,567696,569050,570398,571738,573114,574486,575847,577205,578557,579897,584043,585357,586665,587972,589268,590909,592526,594155,595855,597545,599226,600898,602574,604242,605900,607549,609188,610875,612555,614228,614241,615892,615903,617541,617556,619175,619190,620807,620821,622429,622444,624043,624058,625668,625683,627286,627299,628891,628903,630487,630499,632076,632088,633672,635244,636806,693921,693932,693946,695169,695180,695194,696399,696408,696426,697622,697628,697645,698825,698835,698852,700026,700037,700049,701226,701238,702420,702434,703619,704793,921150,921169,921207,923826,923849,923887,926519,926543,926578,929232,929257,929295,931946,931966,932001,934648,934673,934709,937352,937378,937414,940089,940109,940144,942806,942826,942862,945511,945530,945567,948213,948232,948269,950919,950937,950975,953619,953636,953674,956309,956330,956364,958986,959007,959040,961641,961661,961695,964300,964338,966936,966974,969568,969606,972196,972234,974816,974853,977428,977465,980072,982663,985250,987874,990493,993107,995714,995791,995806,995842,995873,998309,998386,998401,998437,998468,1000893,1000970,1000985,1001021,1001052,1003474,1003551,1003566,1003602,1003633,1006124,1006139,1006175,1006205,1008691,1008709,1008742,1008772,1011250,1011268,1011301,1011331,1013830,1013848,1013881,1013911,1016395,1016411,1016443,1016476,1018942,1018961,1018990,1019025,1021489,1021508,1021537,1021572,1024034,1024053,1024084,1024117,1026568,1026587,1026616,1026652,1029098,1029117,1029146,1029182,1031624,1031643,1031676,1031706,1034126,1034146,1034177,1034209,1036616,1036636,1036666,1036699,1039108,1039125,1039155,1039188,1041592,1041609,1041639,1041676,1044068,1044085,1044115,1044152,1046535,1046552,1046582,1046619,1048991,1049008,1049039,1049076,1051450,1051483,1051520,1053883,1053913,1053950,1056310,1056340,1056377,1058731,1058762,1058799,1061171,1061208,1063572,1063609,1065965,1066003,1068351,1068384,1070720,1070754,1073120,1073154,1073214,1075513,1075546,1075607,1077896,1077929,1077990,1080300,1080361,1082659,1082721,1085004,1085066,1087332,1087393,1089652,1089714,1091982,1092044,1094365,1096671,1098968,1101245,1103516,1105765,1107992,1110206,1112392,1915699,1917911,1920110,1922310,1924500,1926748,1928989,1931218,1933431,1935629,1937825,1940014,1942192,1944363,1946522,1948671,1950807,1952939,1955065,1957141,1959205,1961260,1963298,1965319,1967346,1969359,1971376,1973386,1975383,1977368,1979340,1981336,1983328,1985315,1987291,1989261,1991216,1993157,1995090,1997019,1998945,2000859,2002762,2004654,2006528,2008414,2010298,2012175,2014040,2015880,2017706,2019517,2021324,2023125,2024915,2026911,2028901,2030880,2032845,2034804,2036758,2038703,2040641,2042566,2044479,2046373,2048266,2050144,2052017,2053885,2055836,2057872,2059905,2061931,2063951,2065960,2067962,2069968,2112758,2114664,2116566,2118456,2120337,2122208,2124068,3000383,3002701,3004997,3007229,3009416,3011595,3013752,3015895,3018034,3020227,3022077,3023553,3025020,3029499,3030926,3032343,3033747,3035339,3036918,3038487,3040047,3041600,3043143,3044679,3046213,3047726,3049234,3050742,3052245,3053736,3055217,3056692,3058149,3059596,3061041,3062777,3064508,3064638,3064644,3066233,3066358,3066362,3067942,3068069,3068072,3069638,3069767,3069770,3071453,3071456,3073130,3073135,3074801,3074807,3076462,3076464,3078113,3078123,3079774,3079777,3081420,3081431,3083059,3083069,3084688,3084696,3086340,3086346,3087986,3087993,3089615,3089621,3091239,3091245,3092850,3092859,3094454,3094458,3096044,3096049,3097629,3097638,3099206,3099213,3100777,3100784,3102337,3102343,3103879,3103884,3105418,3105423,3106971,3106977,3108515,3108522,3110084,3110086,3111644,3184717,3186178,3187635,3189086,3190532,3191973,3193411,3195103,3196884,3198861,3200830,3202526,3204221,3205908,3207594,3209277,3210952,3212670,3214372,3216069,3217760,3219449,3221129,3222733,3222740,3222794,3224400,3224405,3224459,3226030,3226032,3226087,3227646,3227650,3227707,3229263,3229267,3229320,3230884,3230888,3230947,3232501,3232503,3232563,3234111,3234113,3234168,3235707,3235711,3235767,3237293,3237296,3237351,3238861,3238865,3238925,3240429,3240435,3240488,3242032,3242038,3242091,3243628,3243631,3243685,3245208,3245211,3245271,3246810,3246815,3246872,3248395,3248401,3248459,3249968,3249972,3250026,3251530,3251536,3251593,3253092,3253095,3253152,3254689,3254694,3254752,3256706,3256763,3258772,3260773,3262753,3264733,3266710,3268696,3268716,3268724,3268786,3270745,3270764,3270774,3270837,3272873,3272890,3272901,3272963,3274984,3275000,3275012,3275074,3277076,3277093,3277103,3277167,3279162,3279184,3279195,3279258,3281297,3281317,3281329,3281392,3283423,3283443,3283455,3283521,3285542,3285562,3285574,3285638,3287692,3287712,3287724,3287787,3289847,3289855,3289926,3291963,3291974,3292040,3294066,3294078,3294142,3296168,3296178,3296245,3298272,3298339,3300354,3300424,3302429,3302495,3304559,3306608,3308654,3310695,3312731,3314750,3316761,3318762,3320747,3322733,3324883,3327150,3329537,3331922,3334287,3336639,3338988,3341326,3341330,3341334,3341342,3341358,3343663,3343665,3343674,3343680,3343695,3346018,3346025,3346027,3346037,3346055,3348376,3348382,3348387,3348405,3350719,3350727,3350742,3353050,3353067,3355368,3355383,3357697,3357714,3360056,3362423,3364777,3367112,3378783,3378790,3381078,3381086,3383348,3383350,3385633,3385636,3387901,3387906,3390161,3390170,3392413,3392419,3394648,3394652,3396869,3396875,3399087,3399095,3401288,3401297,3403478,3403486,3403519,3403574,3405660,3405666,3405698,3405753,3407835,3407870,3407918,3410032,3410083,3412177,3412227,3414346,3414399,3416491,3416545,3418633,3418686,3420756,3420804,3422911,3424989,3427052,3429093,3431118,3433130,3435129,3437128,3439105,3492192,3494317,3496433,3498587,3500730,3502864,3504996,3507119,3509242,3511356,3513464,3515558,3534196,3534214,3536231,3536255,3538265,3538283,3540285,3540304,3542359,3542376,3544413,3544432,3546472,3548509,3550542,3552584,3554616,3556657,3807843,3808219,3808592,3808961,3809329,3809695,3810057,3810417,3810772,3835748,3835990,3836230,3836709,3836967,3837225,3837481,3837736,3838013,3838268,3838522,3838773,3839026,3839276,3839524,3839768,3840009,3847488,3847720,3847948,3848172,3848401,3848626,3848848,3849069,3852387,3852511,3852981,3853107,3853696,3854282,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,3900274,3900993,3901707,3902422,3903132,3903840,3904545,3905244,3905942,3906635,3907309,3907327,3907999,3908016,3908684,3908704,3909369,3909389,3910049,3910066,3910739,3910757,3911445,3912127,3912812,3913490,3914169,3914843,3915521,3937460,3938111,3938757,3939399,3940039,3940678,3948247,3948889,3949530,3950162,3950794,3951423,3952048,3953304,3953307,3953309,3953314,3953922,3953925,3953930,3953933,3954535,3954539,3954540,3954544,3955148,3955150,3955155,3955759,3955763,3979872,3994300,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





	Igor Kolb (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Igor Kolb (Dancer)

Igor Kolb (Dancer)

Principal Dancer

Prizewinner of the Vaganova-Prix Ballet Competition (St Petersburg, 1995).

Born in Pinsk, Belarus.

Graduated form the Byelorussia State Ballet School.

Joined the Mariinsky Theatre in 1996. Became a Principal Dancer in 1998.

Repertoire includes:
La Sylphide (James);
Giselle (Albrecht);
Le Corsaire (Ali);
Paquita Grand pas;
Konstantin Sergeyev?s Swan Lake (Prince Siegfried);
Esmeralda Pas de six;
Konstantin Sergeyev?s The Sleeping Beauty (Prince Desire);
The Sleeping Beauty, the original 1890 production (Prince Desire);
La Bayadere, the original 1900 production (Solor);
Raymonda (Berangee)
Vasily Vainonen?s The Nutcracker (Prince);
The Fountain of Bakhchisarai (Vaslav)
Romeo and Juliet (Troubadour)
Alexey Ratmansky?s Cinderella (Prince);
Michel Fokine?s Chopiniana, Le Spectre de la rose;
George Balanchine?s Scotch Symphony, Symphony in C (1st Movement), Tchaikovsky Pas de deux, Jewels (Diamonds);
Jerome Robbins?s In the night (2nd Duet);
William Forsythe?s In the middle somewhat elevated, Steptext.

In 2002, Igor Kolb had his debut performance at the Rome Opera in Rudolf Nureyev?s version of the ballet The Sleeping Beauty.