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,20027,21440,21442,21443,21462,21492,21494,21495,21514,22946,22948,22949,22968,24401,24402,24420,25884,25886,25887,25905,26171,26181,26188,26265,27571,27584,27592,27676,30345,30347,30348,30366,31851,33356,87820,89793,91757,93713,95664,97609,99544,101469,103384,105289,107186,109080,110962,112835,114701,116557,118429,120302,122172,124035,125890,127735,129571,131400,133229,135058,136881,138701,140514,142318,144114,145899,147674,149442,151198,152944,154683,156410,158126,159831,161554,163275,165022,166758,168488,170203,171912,173612,175303,251764,251768,251769,253744,253748,253749,255716,255720,255721,257683,257684,257685,259654,259655,259660,261619,261624,261625,263574,263578,263579,265538,265542,265543,267494,267498,267499,269444,269445,269446,271384,271385,271390,273322,273327,273328,275256,275260,275261,277186,277190,277191,279101,279106,279107,280974,280979,280980,282838,282843,282844,284696,284700,284701,286553,286558,286559,288402,288406,288407,290245,290249,290250,292146,292150,292151,294040,294044,294045,295927,295931,295932,297805,297809,297810,299680,299684,299685,301576,301580,301581,303464,303468,303469,305395,305399,305400,307325,307329,307330,309248,309252,309253,311166,311170,311171,313080,313084,313085,314988,314991,314992,316890,316894,316895,318788,318789,368091,369968,371836,373696,375546,377387,379221,381052,382877,384696,386508,388312,390120,391920,393719,395514,397303,399085,400859,402623,404383,406137,407888,409632,411372,413134,414885,416627,418368,420104,2117737,2119624,2121501,2123368,2125220,2127061,2128895,2130721,2132537,2134344,2136138,2137922,2139765,2141599,2143424,2145238,2147042,2148836,2150616,2152383,2154141,2155890,2157628,2159355,2161109,2162848,2164577,2166298,2168001,2436377,2439323,2442258,2445179,2445184,2448100,2448105,2451010,2451015,2453913,2453918,2456797,2456802,2754766,2757786,2760807,2763823,2766822,2769806,2772779,2775744,2778733,2781714,2784802,2787888,2790958,2794016,2797091,2800150,2800153,2803205,2803208,2806179,2806182,2809135,2809138,2812069,2812072,2814991,2814994,2817974,2817977,2820953,3267594,3269646,3271729,3273844,3275943,3278033,3280120,3282250,3284374,3286494)) 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





	Yan Godovsky (Leading Soloist) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Yan Godovsky (Leading Soloist)

Yan Godovsky (Leading Soloist)

Leading Soloist

Biography
Born in Tbilisi. In 1993, having completed his training at the Moscow College of Choreography (today the Moscow Academy of Choreography; Igor Uksusnikov's class), he joined the Bolshoi Theatre Company. At the present time, his teacher-repetiteur is Boris Akimov.


Main Repertory

1993
He-Devil (The Nutcracker; choreography by Yuri Grigorovich)

1994
Conrad (Tikhon Khrennikov's Love for Love; choreography by Vera Boccadoro; Shakespeare's Much Ado About Nothing adaptation to the ballet)
Peasant Pas de Deux (Giselle; Yuri Grigorovich production)
Boy (La Sylphide; choreography by August Bournonville in a version by E.M. von Rosen)
Jig (Don Quixote; choreography by Marius Petipa, Alexander Gorsky in a version by Yuri Grigorovich)

1995
Spanish Doll (The Nutcracker)
Fool (Swan Lake; choreography Alexander Gorsky, Marius Petipa, Lev Ivanov in a version by Yuri Grigorovich)

1996
Gnome Merry Fellow (Karen Khachaturyan's Snow White; choreography by Genrikh Mayorov)
Pas de Six (The Taming of the Shrew to music by Kurt-Heinz Stolze after Domenico Scarlatti; choreography by John Cranko)

1997
Godfather Pumpkin (Karen Khachaturyan's Cipollino; choreography by Genrikh Mayorov)
Pas d'Action (Giselle; Vladimir Vasiliev version)
Mime (Spartacus; choreography by Yuri Grigorovich)

1998
Friend to Prince (Swan Lake; Vladimir Vasiliev production)

1999
French Doll (The Nutcracker)

Coral (Rodion Shchedrin's The Humpbacked Horse; choreography by Nikolai Androsov)
1st Pas de Trois (Agon) - was among the creators of this ballet at the Bolshoi Theatre Poet (Insomnia by Sergei Zhukov. Alexander Petukhov production) - creation

2000
2nd Variation in Pas d'action (Cesare Pugni's La Fille du Pharaon; Pierre Lacotte production after Marius Petipa) - creation
Nutcracker-Prince (The Nutcracker)

2001
Soloist (Passacaille to music by Anton von Webern; choreography by Rolan Petit) - creator of the role at Bolshoi Theatre

2002
Alain (Louis Herolds La Fille mal gardee; choreography by Frederick Ashton)
Friend to Ferkhad (Arif Melikov's A Legend of Love; choreography by Yuri Grigorovich)
Magedaveya, Dance with drum (La Bayadere. Yuri Grigorovich production)

2003
Claude Frollo (Notre-Dame de Paris. Rolan Petit production) - creator of the role at Bolshoi Theatre
Ballet Dancer (Dmitry Shostakovich'sThe Bright Stream; choreography by Alexei Ratmansky)
Colas (La Fille mal gardee)
Romeo (Romeo and Juliet; Declan Donnelan and Radu Poklitaru production)

2004
Soloist Part 3 (Symphony in C; choreography by George Balanchine)
Tarantella (choreography by George Balanchine)
Soloist/Three Soloists (Yuri Krasavin's Magrittomania; choreography by Yuri Possokhov) - was among the creators of this ballet at the Bolshoi Theatre
Patient (Ward # 6 to music by Arvo Part; Radu Poklitaru creation)
Philostrat (Puck) (A Midnight's Summer Dream; choreography by John Neumeier) - creator of the role at Bolshoi Theatre

2005
Yan (Dmitry Shostakovich's Bolt; choreography by Alexei Ratmansky) - creation Soloist Part 1 (Symphony in C)
Fate (Les Presages to music by Pyotr Tchaikovsky. Choreography by Leonide Massine)
Soloist (Igor Stravinsky's Jeu de cards; Alexei Ratmansky сreation)

2006
Friend to Prince, Waltz' Soloist (Cinderella; Yuri Possokhov and Yuri Borisov production) - was among the creators of this ballet at the Bolshoi Theatre

2007
Soloist (Misericordes to music by Arvo Part; Christopher Wheeldon сreation)
Soloist (In the Upper Room. Music by Philip Glass. Choreography by Twyla Tharp) - was among the creators of this ballet at the Bolshoi Theatre
Pas d’Esclaves (Le Corsaire; production and new choreography by Alexei Ratmansky and Yuri Burlaka after Marius Petipa)

2008
James (Herman Levenskiold's La Sylphide; choreography by August Bournonville in a version by Johan Kobborg)

Awards

In 2006, was awarded the Golden Mask National Theatre prize for his performance of the part of Philostrat (Puck) in A Midnight's Summer Dream (season 2004/05). In 2008, he was awarded the Ballet magazine Soul of Dance prize (Star nomination).