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 (3030873,3032291,3033692,3035284,3036867,3038436,3039995,3041544,3043087,3044625,3046156,3047674,3049180,3050688,3052192,3268768,3268770,3270815,3270818,3272943,3272946,3275052,3275055,3277145,3277148,3279236,3279238,3281369,3281373,3283498,3283499,3285619,3285622,3287767,3287771,3289901,3289904,3292017,3292018,3294123,3294125,3296222,3296226,3298316,3298317,3300400,3300403,3302475,3302478,3304539,3304542,3306587,3306590,3308633,3308636,3310674,3310678,3312708,3312711,3314727,3314728,3316739,3316741,3318739,3318742,3320727,3320730,3322712,3322715,3324859,3324862,3327132,3327133,3329518,3329519,3331898,3331901,3334266,3334268,3492168,3494291,3496407,3498560,3500705,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,3816970,3817318,3817667,3818053,3818452,3818854,3852489,3853082,3853674,3854262,3854850,3855430,3856012,3856591,3857167,3857785,3858401,3859202,3860002,3860803,3861598,3862392,3863182,3863968,3864754,3865530,3866308,3867083,3867858,3868625,3869394,3870158,3870921,3871683,3873170,3873926,3874677,3875428,3876177,3876921,3877666,3878410,3879151,3879893,3880634,3881377,3882119,3882864,3883605,3884342,3885083,3885819,3886555,3887286,3888020,3888750,3889481,3890206,3890930,4035099,4035456,4036357,4037255,4038176,4039088,4260340,4260646)) 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





	Yevgeny Deryabin (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Yevgeny Deryabin (Dancer)

Yevgeny Deryabin (Dancer)

Born in Almaty (Kazakhstan). 
Graduated from the Almaty School of Dance in 2005. He worked at the State Academic Dance Theatre of the Republic of Kazakhstan from 2005-2007, the Universal Ballet Company (Seoul, South Korea) from 2007-2008, the Abai Kazakh State Academic Opera and Ballet Theatre from 2008-2009, the St Petersburg Eifman Ballet from 2009-2010 and the Mikhailovsky Theatre from 2010-2013.

Joined the Mariinsky Ballet in 2013.

Repertoire includes: 
La Sylphide (Gurn); choreography by August Bournonville, revised version by Elsa-Marianne von Rosen, 
Swan Lake (von Rothbart, Mazurka); choreography by Marius Petipa and Lev Ivanov, revised version by Konstantin Sergeyev, 
La Bayadère (Slave); choreography by Marius Petipa, revised version by Vladimir Ponomarev and Vakhtang Chabukiani,
Don Quixote (Espada); choreography by Alexander Gorsky after motifs of the production by Marius Petipa,
Pétrouchka (Grooms); choreography by Michel Fokine,
A Midsummer Night’s Dream (Bottom); choreography by George Balanchine, 
Romeo and Juliet (Paris); choreography by Leonid Lavrovsky, 
Leonid Yakobson’s ballets Shurale (Matchmakers), Spartacus (Erostenes), 
Sylvia (Apollo); choreography by Frederick Ashton, 
The Stone Flower (Skomorokhs, Severian's Guards); choreography by Yuri Grigorovich, 
The Little Humpbacked Horse (Horses, Seahorses); choreography by Alexei Ratmansky, 
Sacre; choreography by Sasha Waltz, 
The Bronze Horseman (Ibrahim the Blackmoor); choreography by Yuri Smekalov, 
Paquita (Gypsies); choreography by Yuri Smekalov, reconstruction and staging of Marius Petipa's choreography (Act III Grand Pas) by Yuri Burlaka, 
Vladimir Varnava's ballets Pétrouchka (The Strongman) and Yaroslavna. The Eclipse (Mercenaries).

Repertoire also includes:
Labyrinth; choreography by Ksenia Zvereva,
Orpheus in the Underworld (Sisyphus); choreography by Yuri Smekalov.