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 (8417,10123,11706,13289,14741,14777,16195,16229,17805,17839,19198,19232,20642,20673,22125,22157,23579,23611,25043,25073,26798,26865,27717,27860,29132,29204,30991,31021,32505,32539,34060,37191,38746,40193,41608,43000,44361,45712,47057,48397,49730,51058,221396,221422,221440,222910,222936,222954,224419,224445,224462,225924,225950,225969,227429,227455,227475,228928,228954,228973,230913,230939,230958,232908,232934,232953,234898,234924,234943,236882,236909,236928,238858,238883,238902,240824,240849,240866,242784,242810,242827,244741,244767,244784,246695,246721,246738,248642,248668,248685,250585,250612,250629,252569,252595,252612,254541,254569,254586,256506,256532,256550,258467,258494,258511,260433,260460,260477,262393,262420,262437,264359,264387,264404,266319,266347,266364,268298,268316,270239,270257,272178,272196,274111,274129,276045,276062,277972,277992,279868,281736,283595,285452,289249,291086,292982,294870,296751,298627,300498,302386,304269,306195,308119,310037,311952,313861,315766,317664,319554,321433,323303,325198,457398,458964,460521,462068,463619,465167,466709,468407,470109,471660,473200,474780,476357,477929,479503,481063,481813,497357,497376,498821,498845,500277,500298,501731,501753,503223,503244,504702,504726,506173,506198,507644,507668,509113,509138,510602,512057,513499,514975,539301,539309,540717,540725,542141,542151,542157,543583,543594,543599,545052,545064,545069,546506,546516,546523,547966,547978,547979,549417,549429,549435,550860,550872,550878,552307,552313,553732,553738,555154,583945,584026,585259,585340,586566,586650,587873,587954,589168,589249,590808,590890,592427,592507,594056,594137,595754,595837,597527,599207,600880,602556,604223,605881,607530,609172,610859,612539,614213,615875,616005,616079,617524,617654,617728,619159,619290,619362,620790,620920,620993,622413,622544,622616,624027,624158,624230,625652,625783,625855,627398,627474,629003,629078,630598,630673,632187,632260,633771,633844,635347,635417,636909,636979,638462,638532,640000,640071,641529,641601,643050,643122,644562,644636,646068,646142,647564,647642,649055,649127,650551,650623,652031,652108,653507,653584,654973,655050,656427,656505,657872,657957,659321,659405,660762,660842,662188,662268,663607,663687,665022,665101,666507,667942,669363,670801,672225,673650,675054,676448,677834,679241,680634,682021,683394,684761,694014,694026,694040,695262,695274,695288,696494,696507,696519,697711,697727,697738,698917,698934,698946,700114,700129,700142,701308,701318,701330,702502,702514,702528,703689,703698,703710,704863,704873,704885,706020,706030,706045,707164,707176,707190,708295,708305,708320,709417,709433,709442,710562,710579,710588,711703,711719,711729,712840,712857,712867,713969,713981,713995,715083,715095,715105,716184,716198,716207,717278,717290,717304,718373,718386,719443,719457,720516,721565,859670,862387,865094,867788,870472,873154,875836,875872,878523,878559,881207,881243,883929,886603,889268,891930,894585,897242,899891,921198,923873,926568,929281,1075647,1078030,1080401,1082761,1082791,1085106,1085136,1087435,1087465,1089754,1089785,1092083,1092115,1094405,1094436,1096715,1096746,1099010,1099043,1101288,1101320,1103559,1103591,1105808,1105840,1108036,1108075,1110243,1110282,1112427,1112468,1114598,1114636,1116753,1116783,1118885,1118924,1121019,1121049,1123156,1123194,1125289,1125324,1127481,1127514,1129701,1129735,1131945,1134135,1136339,1138539,1140736,1142925,1145108,1147278,1915738,1917950,1920150,1922349,1924538,1926786,1929027,1931256,1933470,1935669,1937865,1940053,1942232,1944403,1946564,1948710,1950850,1952982,1955105,1957181,1959245,1961297,1963334,1965362,1967382,1969402,1971141,1971147,1971412,1973153,1973155,1973423,1975148,1975154,1975419,1977136,1977138,1977405,1979105,1979111,1979376,1981105,1981107,1981374,1983099,1983366,1985351,1987329,1989299,1991253,1993193,1995130,1997059,1998981,2000895,2002798,2004692,2006564,2008453,2010338,2012215,2014075,2015915,2017742,2019552,2021359,2023160,2024955,2026946,2028936,2030915,2032881,2034839,2036794,2038738,2040676,2042602,2044514,2046411,2048301,2050183,2052056,2053921,2055872,2057911,2059944,2061971,2063990,2066000,3000403,3002614,3002655,3002721,3002737,3004951,3005017,3005033,3007183,3007249,3007265,3009370,3009436,3009452,3011551,3011614,3011630,3013708,3013771,3013787,3015914,3015930,3018053,3018069,3020246,3020262,3022091,3022103,3023562,3023572,3025029,3025039,3026479,3026491,3027921,3027932,3029364,3030791,3064572,3064618,3064638,3064647,3066295,3066339,3066358,3066366,3068003,3068048,3068069,3068079,3069703,3069747,3069767,3069776,3071390,3071435,3071453,3071462,3073068,3073112,3073130,3073141,3074738,3074781,3074801,3074809,3076397,3076442,3076462,3076472,3078049,3078094,3078113,3078129,3079711,3079752,3079774,3079783,3081361,3081404,3081420,3081432,3083000,3083042,3083059,3083075,3084622,3084666,3084688,3084702,3086277,3086323,3086340,3086357,3087919,3087963,3087986,3087994,3089554,3089599,3089615,3089629,3091174,3091221,3091239,3091252,3092828,3092850,3092863,3094430,3094454,3094462,3096026,3096044,3096056,3097610,3097629,3097639,3099182,3099206,3099216,3100755,3100777,3100788,3102316,3102337,3102347,3103862,3103879,3103895,3105418,3105429,3106971,3106982,3108515,3108526,3110084,3110094,3111655,3113202,3177292,3178683,3180155,3181623,3183089,3184552,3186013,3187470,3188921,3190366,3191807,3193243,3194934,3196719,3198694,3200661,3202360,3204052,3205743,3207430,3209110,3268691,3268695,3268720,3270737,3270747,3270767,3272864,3272872,3272895,3274975,3274982,3275003,3277068,3277077,3277099,3279158,3279161,3279187,3281293,3281296,3281320,3283419,3283422,3283446,3283475,3285538,3285541,3285568,3285595,3287691,3287714,3287745,3289851,3289878,3291966,3291994,3294069,3294100,3296170,3296201,3298264,3298293,3300376,3302452,3304517,3306564,3308610,3310652,3312686,3314706,3316715,3390170,3392419,3394652,3396875,3399095,3401297,3403486,3405666,3407835,3505013,3507139,3509260,3511373,3513481,3515578,3517664,3519752,3521828,3523901,3525961,3550638,3552679,3554715,3556753,3558776,3560788,3562795,3564793,3566812,3568822,3570844,3572855,3574865,3576772,3578673,3580574,3582459,3584319,3586178,3588031,3589884,3591729,3593577,3595536,3597526,3599500,3601463,3603409,3910075,3910766,3911452,3912135,3912819,3913498,3914175,3914849,3915530,3916206,3916883,3917556,3926412,3927074,3927734,3928393,3929047,3929698,3930350,3930994,3931642,3932284,3932922,3994325,3994846,3995368,3995883,3996393,3996903,3997406,4035089,4035094,4035448,4035452,4036350,4036354,4037249,4037254,4038169,4051483,4138006,4138676,4139342,4140006,4140666,4141318,4141971,4142622)) 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





	Grigory Popov (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Grigory Popov (Dancer)

Grigory Popov (Dancer)

• Prize-winner at the International Competition Vaganova-Prix (St Petersburg, 2002).
Born in Chelyabinsk.
Graduated from the Vaganova Academy of Russian Ballet. Joined the Mariinsky Theatre in 2002.

Repertoire includes:
La Sylphide (James);
Giselle (the classical duet);
Le Corsaire (Lankedem);
La Bayadere (Maghedaveya, Little God and the Indian Dance);
The Sleeping Beauty (Blue Bird, Puss in Boots);
Swan Lake (Jester);
Le Spectre de la rose;
Romeo and Juliet (Jester);
Prodigal Son (Friend of the Prodigal Son);
The Fountain of Bakhchisarai (Nurali);
The Legend of Love (Jesters’ dance);
The Young Lady and the Hooligan (Hooligan);
Carmen (Bandit);
The Nutcracker (Fritz, Chinese Dance, Petroushkas’ dance), production by Mihail Chemiakin, choreography by Kirill Simonov;
Cinderella (Hairdresser, detective), choreography by Alexei Ratmansky;
The Magic Nut (Chef, King’s Jester);
Ondine (Tarantella);
'Overcoat' after Gogol (Bureaucrat delivering the military letter);
Aria Suspended.

Dances in operas: Life for the Tzar (Cracovienne), Prince Igor (Polovtsian Dances).

Has toured in Europe and America with the Mariinsky Theatre Company.