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 (3449391,3451528,3453658,3455778,3457906,3460028,3462165,3464291,3466438,3468617,3470785,3472942,3475098,3477252,3479396,3481535,3483666,3565044,3567064,3569089,3571105,3573115,3575128,3577035,3578939,3580838,3582699,3584561,3586418,3588271,3590124,3591971,3593816,3595798,3597792,3599768,3601728,3603674,3605613,3607538,3609457,3611364,3613264,3615186,3617099,3619008,3620908,3622807,3624697,3626576,3628445,3630306,3632165,3634016,3635860,3637696,3639521,3641331,3643133,3644929,3646713,3648492,3650263,3652022,3653768,3655511,3657244,3658963,3660683,3662408,3664123,3665827,3667523,3669213,3670890,3672563,3674228,3675883,3677527,3679164,3680801,3682432,3684054,3685673,3687282,3688882,3690478,3692071,3693652,3695230,3696798,3698355,3699897,3701437,3702970,3704494,3706012,3707522,3709019,3710504,3711990,3713466,3714936,3716403,3717861,3719315,3720765,3722204,3723642,3725070)) 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





	Pavel Baleff (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Pavel Baleff (Conductor)
			

																
Pavel Baleff (Conductor)

														
				


        




    

        
The Bulgarian conductor Pavel Baleff was born in 1970. In 1988 he conducted his first concert. In 1993 he received the Bulgarian Radio prize for the best young musician and produced radio and television recordings with the leading orchestras in the country. 

Since 1995 Pavel Baleff has been a participant in the Conductors Forum of the German Music Association. In 1996 Pavel Baleff won the 1st Prize in the International competition Carl Maria von Weber in Munich (prize winner concert with the Munich radio Orchestra in the Hercules Hall of the palace) and in 1999 he won the conducting competition of the German music schools in Weimar with the Herbert von Karajan – Foundation. In 2003 Pavel Baleff won the renowned Bad Homburg conductor award – one of the highest German conductor honours. 

Since December 1998 Pavel Baleff has been the Musical Director of the Dresden Chamber Opera. In September 1999 he was given the position of 1st conductor at the Rostock Opera. An 2000 he was made musical director for the length of the season. Since 2002 Pavel Baleff has worked as first conductor and deputy General Music Director at the opera in Halle. 

Mr. Baleff is a regular guest conductor of several national and international orchestras including the following: The National Opera in Hannover (year 2002, „The Rake’s progress”) as well as at the Komische Oper in Berlin (year 2004-2005, „Il barbiere di Siviglia”, „Fidelio”) and at the Semperoper Dresden (2006 - 2009 „Die Zauberflöte“, “ The flying Dutchman”, “Rigoletto”)., „Carmina Burana“ at the Oper Leipzig with Gewandhaus Orchestra, Bolschoi Theater Moscow - 2012. 

At the Oper Zurich Balleff conducts „Lucia di Lammermoor” - 2012, „Swan Lake“ – 2012, „Romeo and Julia” - 2013 and „Leonce and Lena” - 2015. 

Baleff has a Debut at the Theater Bremen with „Der Rosenkavalier”. 

Baleff works with a big success with the world famouse Singers like Edita Gruberova , Krassimira Stoyanova , Thomas Hampson, Vesselina Kasarova, Ramon Vargas, Piotr Beczala, Diana Damrau, Luca Pisaroni, Anna Netrebko.

He conducts the Christmas Concert for the Bundespresident of Germany together with the Star Violonist Anne – Sophie Mutter in December 2013 ( TV Channel ZDF) 
        

    

    

            


			

		





	


	

	

		


			

				

					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