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 (3064581,3066300,3068009,3069706,3071393,3073072,3074744,3076403,3078058,3079713,3081366,3083005,3084632,3086283,3087928,3089557,3091181,3092794,3268728,3270779,3272905,3275016,3277109,3279199,3281333,3283460,3283475,3285580,3285595,3287725,3287745,3289859,3289878,3291979,3291994,3294083,3294100,3296185,3296201,3298278,3298293,3300357,3300376,3302435,3302452,3304500,3304517,3306564,3308610,3310652,3312686,3314706,3316715,3403547,3405727,3407898,3410060,3412206,3414372,3416521,3418661,3420781,3422885,3424963,3427023,3429067,3505024,3507146,3509269,3511383,3513490,3515591,3517676,3519759,3521839,3523911,3525971,3528020,3530083,3550612,3552651,3554684,3556726,3558750,3560763,3562766,3564768,3566785,3568796,3570817,3572824,3574838,3576746,3578649,3580548,3582437,3584299,3586154,3588009,3589861,3591708,3807850,3808226,3808599,3808968,3809336,3809702,3810064,3810423,3810774,3810789,3811165,3811178,3811565,3811945,3812322,3816955,3817304,3817650,3817697,3818083,3818488,3818885,3819276,3819666,3820051,3820436,3820813,3821188,3821558,3821922,3822286,3822648,3838001,3838006,3838013,3838258,3838262,3838268,3838510,3838516,3838522,3838761,3838767,3838773,3839015,3839020,3839026,3839270,3839276,3839518,3839524,3839768,3840009,3845792,3846038,3846281,3847478,3847710,3847938,3848162,3897409,3898114,3898819,3899516,3900215,3900934,3901648,3902364,3903074,3914867,3915541,3916219,3916898,3917571,3918236,3918275,3918917,3918949,3919607,3919638,3920289,3920326,3921005,3921683,3922355,3923036,3923714,3923730,3924389,3924404,3925054,3925073,3925737,3926398,3926405,3927061,3927067,3927720,3927727,3928380,3928385,3929035,3929041,3929685,3929693,3930342,3930989,3931635,3937465,3938116,3938762,3939403,3940044,3940682,3941318,3941956,3998415,3998922,3999424,3999923,4000416,4000914,4051498,4052376,4053254,4054125,4054991,4055857,4066003,4066014,4066031,4066037,4066821,4066833,4066850,4066854,4067648,4067665,4067671,4068461,4068478,4068484,4069268,4069287,4069292,4070091,4070096,4070890,4070892,4071685,4071691,4072481,4072485,4073272,4073275,4074060,4074066,4074850,4125925,4126613,4127297,4127977,4128655,4137999,4138668,4139337,4139997,4140656,4260339,4260645)) 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





	Shamala Guseinova (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Shamala Guseinova (Dancer)
			

																
Shamala Guseinova (Dancer)

														
				


        




    

        
Born in Kineshma, Ivanovo Region. 
Graduated from the Vaganova Academy of Russian Ballet in 2014 (class of Irina Sitnikova) and joined the Mariinsky Ballet the same year.
Repertoire includes: 
La Sylphide (Sylphs); choreography by August Bournonville, revised version by Elsa-Marianne von Rosen, 
Giselle (Myrtha); choreography by Jean Coralli, Jules Perrot and Marius Petipa, 
The Sleeping Beauty (Silver Fairy, Fairy Violente); choreography by Marius Petipa, revival of the 1890 production, staging by Sergei Vikharev, 
The Sleeping Beauty (Diamand Fairy, Gold Fairy, Sapphire Fairy, Courage Fairy); choreography by Marius Petipa, revised version by Konstantin Sergeyev, 
Swan Lake (Friends of the Prince, Swans); choreography by Marius Petipa and Lev Ivanov, revised version by Konstantin Sergeyev, 
La Bayadère (Grand pas, Trio of Shades); choreography by Marius Petipa, revised version by Vladimir Ponomarev and Vakhtang Chabukiani, 
Raymonda (variation in the scene The Dream, Grand pas); choreography by Marius Petipa, revised version by Konstantin Sergeyev, 
Le Corsaire (Odalisques, Forban Dance); production by Pyotr Gusev after the composition and choreography by Marius Petipa, 
Don Quixote (Flower-Sellers); choreography by Alexander Gorsky after motifs of the production by Marius Petipa, 
Schéhérazade (Odalisques); choreography by Michel Fokine, 
The Stone Flower (Amethysts); choreography by Yuri Grigorovich, 
The Fountain of Bakhchisarai (Young Polish Noblewomen); choreography by Rostislav Zakharov, 
Romeo and Juliet (Folk Dance); choreography by Leonid Lavrovsky, 
The Nutcracker (Waltz of the Snowflakes, Waltz of the Flowers); choreography by Vasily Vainonen, 
Leonid Yakobson’s ballets Shurale (Fiery Witch), Spartacus (Etruscan),
The Nutcracker (the Nutcracker’s Sisters); production by Mihail Chemiakin, choreography by Kirill Simonov, 
The Little Humpbacked Horse (Gypsy Dance); Concerto DSCH;  choreography by Alexei Ratmansky,
Le Parc; choreography by Angelin Preljocaj, 
Anton Pimonov's ballets Bambi (Grasshopper), In the Jungle (Lana), Violin Concerto No 2, 
Symphony in Three Movements; choreography by Radu Poklitaru; 
The Bronze Horseman (Contredanse); choreography by Rostislav Zakharov, Yuri Smekalov, 
Paquita (Paquita’s friends); choreography by Yuri Smekalov, reconstruction and staging of Marius Petipa's choreography (Act III Grand Pas) by Yuri Burlaka, 
The Four Seasons; choreography by Ilya Zhivoi, 
Ballet No 2; choreography by Maxim Petrov.
Repertoire also includes:
SeasonS; choreography by Ilya Zhivoi, 
as part of the project The Dreamers: Beyond; choreography by Maxim Petrov, Lose Yourself to Dance; choreography by Maxim Petrov and Ilya Zhivoi.
        

    

    

            


			

		





	


	

	

		


			

				

					Deals & Discounts 
					Subscribe to our email newsletter
				



				
				


			

			

		

		

	

	




 



	

		

			
    		

    

        

		
		
Award-winning
Group Tour Packages

        

        

		
Useful Links &
Company Information

        

        

        
    
		

	





	

		

			
© 2001 – 2024 by Northern Crown, Ltd. uVisitRussia and uVisitRussia.com are registered trademarks. Terms & Conditions  Privacy Policy