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 (3167858,3169252,3170637,3172014,3173385,3174749,3176151,3177549,3178938,3180410,3181878,3183344,3184809,3186270,3187727,3189178,3190624,3192065,3193501,3195190,3196975,3198951,3200918,3202617,3204309,3206000,3207686,3209366,3211039,3212758,3214464,3216159,3217853,3219541,3221220,3222888,3224553,3226181,3227798,3229415,3231038,3232653,3234262,3235861,3237445,3239014,3240581,3242186,3243775,3245359,3246960,3248545,3250115,3251680,3253241,3254840,3256851,3258861,3260860,3262841,3264821,3266798,3268783,3270834,3272961,3275070,3277163,3279252,3281388,3283514,3285637,3287786,3289918,3292036,3294139,3296241,3298332,3300416,3302492,3304556,3306604,3308651,3310691,3312726,3314744,3316757,3318758,3320746,3322731,3324876,3327146,3329533,3331914,3334281,3336632,3338981,3341324,3343661,3346019,3530369,3532416,3534456,3536492,3538525,3540546,3542617,3544674,3546714,3548754,3550784,3552828,3554863,3556898,3558924,3560938,3562941,3564944,3566958,3568971,3570990,3572999,3575015,3576920,3578822,3580724,3582584,3584444,3586302,3588154,3590007,3591857,3593701,3595683,3597676,3599651,3601610,3603561,3605497,3607422,3609342,3611249,3613146,3615068,3616985,3618893,3620791,3622690,3624583,3626460,3628328,3630193,3632052,3633902,3635744,3637579,3639405,3641217,3643019,3644813,3646602,3648381,3650150,3651910,3653656,3655398,3657129,3658851,3660570,3662295,3664008,3665713,3667409,3669097,3670778,3672451,3998402,3998908)) 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





	Ayuna Bazargurueva (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Ayuna Bazargurueva (Soprano)
			

																
Ayuna Bazargurueva (Soprano)

														
				


        




    

        
• Prize-winner at the Linkhovoin International Competition (2003) 
• Diploma-recipient at the I All-Russian Music Competition (2010) 
• Prize-winner at the international Сompetizione dell’Opera (2012) 
• Prize-winner at the Mikhailov International Young Opera Singers Competition (Kaluga, 2014)
From 2004-2006 she studied at the Novosibirsk State Glinka Conservatoire (class of Zinaida Didenko) and graduated from the St Petersburg State Rimsky-Korsakov Conservatoire in 2009 (class of Sergei Nikulshin).
Since September 2009 she has been a soloist with the Buryatia State Academic Tsydynzhapov Opera and Ballet Theatre. 
Soloist with the Mariinsky Academy of Young Opera Singers.
Repertoire includes: 
Parasya (Sorochintsy Fair), Tatiana (Eugene Onegin), Liza (The Queen of Spades), Marfa (The Tsar’s Bride), Iolanta (Iolanta), Maddalena (Maddalena), Aida (Aida), Cio-Cio-San (Madama Butterfly), Nedda (I pagliacci), Frasquita, Micaëla (Carmen), Serpina (La serva padrona) and Senta (Der Fliegende Holländer), and Princess (Rusalka by Antonín Dvořák), Madama Butterfly (Madama Butterfly).
        

    

    

            


			

		





	


	

	

		


			

				

					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