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.date>='2024-05-14' AND tmp.date<='2024-06-03' AND tmp.perf_id=1717) ORDER BY date ASC, ves DESC, time ASC
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


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.date>='' AND tmp.date NOT BETWEEN '2024-05-14' AND '2024-06-03' AND tmp.perf_id=1717) ORDER BY date ASC, ves DESC, time ASC
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


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.date>='' AND tmp.perf_id<>1717 AND tp.id_base=-1 AND tmp.city_id=2 ORDER BY date ASC, ves DESC, time ASC
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


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.date>='' AND tmp.perf_id<>1717 AND tp.id_base=-1 AND tmp.city_id=1 ORDER BY date ASC, ves DESC, time ASC
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





	27 November 2021, 19:00 - Die Fledermaus Operetta in two acts by Johann Strauss - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Saint Petersburg Hermitage Theatre 27 November 2021, 19:00 - Die Fledermaus Operetta in two acts by Johann Strauss
			

			
				


    

        
27November

        
19:00

        
2021 | Saturday

    

    

        
Die Fledermaus Operetta in two acts by Johann Strauss

        
Opera

	
Hermitage Theatre, Saint Petersburg

            

    

            

    





        
    
Go to events list (All venues, -11)



    

        
Duration: 2 hours 50 minutes

THE BAT
Operetta in two acts by Johann Strauss
performs in russian language
libretto by Carl Haffner and Richard Genee
directed by KERO Miklos Gabor Kerenyi (Hungary)
Edited by — Istvan Kallai and Gyorgy Bohm (Hungary)
Russian text — Sergey Volskiy
Lyrics — Eugeny Gerken and Sergey Volskiy
Musical leader and conductor — Peter Guth (Austria)
Conductors — Maksim Alekseev, Arif Dadashev
Set design by — Khell Csorsz (Hungary)
Costume designer — Irina Dolgova
Ballet master — Jeno Loscei (Hungary)
Chief chorus master — Alexey Nefedov
Opening night took place on 30th of October 2010.
“The Bat” is one of the most brilliant among operettas in the whole history of genre. It is still staged to this very day in theatres enriching the repertoire of both opera and operetta companies. It is hard to believe today that opening of “The Bat” that took place on 5th of April 1874 in Vienna got a cool welcome and was presented to the audience just 17 times. Only after one hundred performance in Berlin Vienna reverted to this play again. It is hard to find one more operetta which was conducted by such prominent conductors as Gustav Mahler, Bruno Walter, Felix Weingartner, Hans Knappertsbusch, Herbert von Karajan.
The story took place in Vienna. Intrigue decided by one of the heroes is nothing but a practical joke: everybody are cheating each other, flirting, going the whole hog, imprisoning guiltless… And such a mess is happening in the vortex of waltzes and polkas of great Strauss, bringing delight to audience for already 130 years. 
“The Bat” will be staged in our theatre already for the sixth time. Original libretto was created by well-known French play writers Henri Meilhac and Ludovic Halevy on the base of funny comedy “Le Reveillon”. Budapest Operetta Theatre and authors of libretto Istvan Kallai and Gyorgy Bohm have created their own version. Performance will be staged by Hungarian director Miklos Gabor Kerenyi, he is already known well by St. Petersburg audience by his productions of “Bayader” and “Countess Maritza”. By this production theatre will continue collaboration with Hungarian masters of genre.
Casts & Credits
Composer: Johann Strauss
        

    

    

                
    
                    

        

            

                            

            

                            

        

    

	

        
Composer: Johann Strauss
    

    

			

		





	


	

	

		


			

				

					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