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 (3222688,3222716,3222777,3224352,3224381,3224444,3225981,3226014,3226071,3227601,3227628,3227689,3229214,3229243,3229306,3230839,3230865,3230927,3232455,3232481,3232545,3234063,3234092,3234154,3235662,3235691,3235752,3237246,3237275,3237336,3238849,3238906,3240416,3240474,3242014,3242077,3243608,3243613,3243671,3245189,3245192,3245251,3246791,3246793,3246853,3248377,3248383,3248440,3250011,3251574,3253134,3254734,3256746,3258757,3260753,3262734,3264715,3266692,3268677,3268696,3268739,3270727,3270745,3270788,3272853,3272873,3272914,3274964,3274984,3275025,3277058,3277076,3277119,3279145,3279162,3279206,3281297,3281342,3283423,3283466,3285542,3285588,3287692,3287737,3289871,3291985,3294091,3296191,3298284,3300367,3302445,3304507,3306555,3308601,3310643,3403547,3405727,3407898,3410060,3412206,3414372,3416521,3418661,3420781,3422885,3424963,3427023,3429067,3536259,3538286,3540312,3542383,3544440,3546480,3548516,3550548,3552590,3554621,3556663,3558689,3810793,3810802,3811183,3811193,3811568,3811578,3811948,3811958,3812326,3812334,3812700,3812712,3813079,3813448,3817697,3818083,3818488,3818885,3819276,3819666,3820051,3820436,3820813,3821188,3821558,3821922,3822286,3822648,3835758,3836000,3836240,3836473,3836705,3836964,3837221,3840275,3840525,3840808,3841087,3841362,3841634,3841901,3842163,3842423,3842690,3842955,3845812,3846058,3846301,3846540,3846778,3847012,3847241,3847469,3847495,3847701,3847727,3847955,3848179,3848408,3848633,3848855,3849076,3849295,3849529,3849761,3852485,3852506,3853078,3853098,3853670,3853689,3854257,3854278,3854842,3854863,3855424,3855444,3855448,3856006,3856026,3856029,3856585,3856606,3856607,3857161,3857182,3857186,3857779,3857799,3857805,3858396,3858417,3858418,3859199,3859219,3859224,3859999,3860019,3860023,3860798,3860817,3860819,3861594,3861614,3861619,3862387,3862407,3862412,3863177,3863197,3863199,3863964,3863984,3863989,3864747,3864767,3864771,3865527,3865547,3865551,3866305,3866325,3866328,3867079,3867100,3867101,3867851,3867872,3867877,3868621,3868640,3868642,3869388,3869408,3869413,3870154,3870174,3870176,3870917,3870937,3870939,3871678,3871699,3871703,3872451,3873166,3873185,3873189,3873921,3873941,3873944,3874673,3874693,3874695,3875424,3875444,3875446,3876171,3876191,3876193,3876918,3876937,3876939,3877662,3877682,3877686,3878405,3878424,3878426,3879147,3879167,3879169,3879888,3879908,3879913,3880628,3880649,3880654,3881372,3881393,3881397,3882115,3882135,3882137,3882857,3882878,3882880,3883599,3883619,3883621,3884338,3884358,3884360,3885076,3885097,3885102,3885812,3885834,3885837,3886547,3886568,3886571,3887282,3887303,3887308,3888016,3888036,3888037,3888745,3888767,3888771,3889476,3889495,3889499,3890222,3890223,3890946,3890951,3891665,3891668,3892382,3892385,3893098,3893099,3893810,3893813,3894530,3894533,3895253,3897422,3898126,3898829,3899529,3900228,3900947,3901660,3902374,3903085,3903794,3904498,3905197,3932312,3932952,3933597,3934239,3934873,3935509,3936143,3936798,3937454,3938103,3938747,3979878,3979886,3980462,3980473,3981047,3981052,3981629,3982204,3982776,3994323,3994850,3995366,3995882,3996397,3996900,3997405,4125914,4126605,4132015,4132032,4132039,4132685,4132702,4132708,4133371,4133379,4134036,4134043,4134701,4134706,4135363,4135372,4136023,4136031,4136678,4136683,4137330,4137336,4137987,4138656)) 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





	Camilla Mazzi (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Camilla Mazzi (Dancer)
			

																
Camilla Mazzi (Dancer)

														
				


        




    

        
• Prize-winner at the III All-Russian Competition of Young Performers Russian Ballet (2017, Moscow, 2nd prize)
Graduated from the Moscow State Academy of Choreography in 2017. 
Joined the Mariinsky Ballet as a trainee the same year.
Repertoire includes: 
La Sylphide (sylphs); choreography by August Bournonville, revised version by Elsa-Marianne von Rosen, 
Giselle (Zulma); choreography by Jean Coralli, Jules Perrot and Marius Petipa, 
The Sleeping Beauty (the White Cat, Tenderness Fairy); choreography by Marius Petipa, revised version by Konstantin Sergeyev, 
Swan Lake (Neapolitan Dance); choreography by Marius Petipa and Lev Ivanov, revised version by Konstantin Sergeyev, 
Le Corsaire (Trio of Odalisques); production by Pyotr Gusev after the composition and choreography of Marius Petipa, 
Le Carnaval (Coloumbine, Estrella, Chiarina), Chopiniana (Prelude), Le Spectre de la rose (The Maiden); choreography by Michel Fokine, 
A Midsummer Night’s Dream (Helena); choreography by George Balanchine, 
The Fountain of Bakhchisarai (Polish Noblewomen); choreography by Rostislav Zakharov, 
The Nutcracker (Doll, Louisa, Pas de trois, Waltz of the Flores); choreography by Vasily Vainonen, 
dances in the opera Ruslan and Lyudmila (Dances of Naina’s Charms).
        

    

    

            


			

		





	


	

	

		


			

				

					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