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 (479597,497324,3137888,3139509,3141121,3142725,3144319,3145909,3147489,3148125,3148755,3149379,3150003,3151550,3153089,3154622,3156145,3157661,3159168,3160662,3162147,3163625,3165097,3166581,3167981,3169375,3170760,3172137,3173508,3174872,3176274,3177672,3179065,3180537,3182005,3183467,3184932,3186393,3187850,3189301,3190746,3192187,3193645,3195337,3197122,3199096,3201042,3202740,3204433,3206123,3207810,3209490,3211163,3212882,3214586,3216282,3217976,3219664,3221343,3222700,3222759,3223016,3224364,3224424,3224681,3225993,3226052,3226310,3227608,3227669,3227926,3229226,3229286,3229543,3230850,3230910,3231166,3232465,3232526,3232782,3234076,3234133,3234391,3235675,3235733,3235990,3237259,3237317,3237574,3238828,3238886,3239144,3240396,3240454,3240711,3241998,3242058,3242314,3243650,3243905,3245234,3245487,3246834,3247089,3248421,3248675,3249992,3250245,3251555,3251810,3253117,3253413,3254716,3255063,3256725,3257074,3258736,3259084,3260735,3261081,3262717,3263064,3264697,3265045,3266673,3267031,3268658,3269016,3271107,3273233,3275343,3277433,3279525,3281658,3283785,3285908,3288056,3290190,3292305,3294410,3296511,3298604,3300689,3302764,3304829,3306877,3308924,3310965,3312996,3315014,3317024,3319027,3321015,3322997,3325144,3327415,3329803,3332184,3334551,3336903,3339252,3341597)) 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





	Anna Smirnova (Mezzo soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Anna Smirnova (Mezzo soprano)

Anna Smirnova (Mezzo soprano)

Russian mezzo-soprano Anna Smirnova is one of the most exciting Verdi mezzos on the international scene. She possesses a true dramatic Verdi mezzo-soprano voice, in the tradition of Simionato, Cossotto and the young Obraztsova. Born in Moscow to a family of musicians, she studied at the Tchaikovsky Conservatory in Moscow. She made one of her very first operatic appearances on the stage of the Teatro alla Scala in 2007 as the Principessa in Adriana Lecouvreur. Within two years of this debut, Smirnova was engaged to debut in every major opera company in the world.

She appeared in 2007 as Amneris in Aida at the Berlin Staatsoper, a role she later sang at the Deutsch Oper in Berlin. She was heard as Eboli in Don Carlo under the direction of Lorin Maazel in Valencia in 2008 and appeared as Eboli that same year at La Scala. She has also appeared as Eboli during La Scala's tour to Japan in September of 2009.

Other engagements for the 2008-2009 season included her debut in Verona as Amneris in Aida, a role she also sang that season at the Rome Opera and at La Scala.

She sang her first performances of Santuzza in Cavalleria rusticana at the Teatro la Fenice in 2009 and appeared in this role in the 2009/2010 season in Valencia conducted by Lorin Maazel. Also in the 2009/2010 season, she appeared in Il trovatorein Florence and as Amneris in Tel Aviv.

In the 2010/2011 season, Anna Smirnova appeared at the Deutsche Oper in Berlin in Adriana Lecouvreur opposite Angela Gheorghiu and Jonas Kaufmann. She made her Vienna State Opera debut that season as Amneris and made her debut at the Royal Opera, Covent Garden in the same role. She sang her first performances as Lady Macbeth in Verdi's opera at the Deutsch Oper in Berlin and made her Metropolitan Opera debut in Don Carlo.

In the 2011/2012 season, she made her debut at the Chicago Lyric Opera as Amneris. Further engagements also included her Chicago Lyric Opera debut as Amneris, her debut at the Bayerische Staatsoper in Munich as Eboli in Don Carlo and her debut at the Liceu in Barcelona as Preziosilla in La forza del destino. She was also be heard in Munich, Savonlinna and in Arena di Verona as Amneris.

In 2013 she has sung as Eboli in Don Carlo at the Metropolitan Opera, Azucena in Il trovatore in Bayerische Staatsoper Munich, Amneris in Napoli and Rio de Janeiro, and Abigaille in Nabucco in Deutsche Oper Berlin.

Recent and upcoming engagements: 
In 2014/15 she is going to sing Abigaille in Nabucco in Wiener Staatsoper, Azucena in Il trovatore in Munich, Eboli in Deutsche Oper Berlin and Eboli at the Opernfestspiele Munich.