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 (20720,22213,23667,25138,26982,28081,29333,31086,32604,34124,35523,72173,74203,76221,78231,80237,82236,84232,86213,88195,90163,92121,94070,96023,97961,99890,101811,103720,105620,107514,109400,111277,113146,306263,306304,308187,308228,310105,310146,312019,312060,313928,313969,315833,315874,317731,317772,319621,319662,321500,321540,323369,323410,325265,325305,327166,327206,329064,329104,330955,330995,332841,332881,334716,334756,336582,336627,338448,338488,340329,340371,342253,342295,344178,344221,346094,346137,348001,348044,349891,349934,351769,351811,353646,353689,355519,355562,357396,357439,359346,361245,363135,365017,366901,368776,370648,372512,374367,376212,709622,710768,711909,713047,714174,715286,716390,717483,718564,719636,720695,721744,722796,723852,724899,725939,726967,727988,729000,730002,730998,731986,732968,733957,734940,735914,736891,737859,738819,739772,741743,743719,745688,747649,749634,751616,753598,756474,759344,762211,765073,767929,770778,773621,776458,779291,782127,784960,787788,790612,793432,796238,799045,801848,804646,807439,810226,813007,815783,818553,821319,824075,826823,829567,832305,835041,837770,840497,843220,918432,918438,921125,921131,923805,923810,926495,926499,929212,929218,931920,931927,934628,934634,937333,937339,940064,940070,942781,942788,945486,945492,948188,948194,950894,950899,953599,1911108,1913256,1915415,1917624,1919824,1922021,1924213,1926461,1928702,1930931,1933148,1935347,1937542,1939731,1941910,1944081,1946241,1948390,1950527,1952659,1954787,1956863,1958927,2365681,2368760,2371830,2371861,2374887,2374914,2377931,2377958,2380965,2380995,2383994,2384024,2387017,2387048,2390080,2390103,2393136,2393166,2396188,2396215,2399228,2399251,2402245,2402276,2405260,2405292,2408274,2408304,2411270,2411300,2414261,2414294,2417243,2417273,2420251,2420281,2423249,2423272,2426234,2426261,2429217,2429247,2432193,2432216,2435152,2435179,2438108,2438138,2441046,2441077,2443974,2444004,2446897,2446927,2449813,2449843,2452714,2452743,2455606,2455636,2458482,2458511,2461354,2461386,2464213,2464241,2467066,2467096,2469967,2472897,2475808,2478750,2481674)) 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





	Natalia Mironova (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Natalia Mironova (Soprano)
			

																
Natalia Mironova (Soprano)

														
				


        




    

        Graduated from the St Petersburg State Conservatoire (class of professor Georgy Seleznyov).

Her repertoire includes:
— Violetta (La traviata)
— The Queen of Shemakha (The Golden Cockerel)
— Micaela (Carmen)
— Rosina (Il barbiere di Siviglia)
— Tsarevna Swan-Bird (The Tale of Tsar Saltan)
— Pamina, The Queen of the Night (Die Zauberflote)
— Fiordiligi (Cosм fan tutte)
— Adina (L`elisir d`amore)
— Lucia (Lucia di Lammermur)
— Zerlina, Donna Anna (Don Giovanni)
— Gilda (Rigoletto)
— Antonida (Ivan Susanin)
— Lyudmila (Ruslan and Lyudmila)
— Marfa (The Tsar’s Bride)
— Adele (Die Fledermaus) 
— Eudoxie (La Juive)

Awards:
Prize-winner of the International Competition dedicated to Shostakovich Classica Nova (Hannover)

        

    

    

            


			

		





	


	

	

		


			

				

					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