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 (539375,540790,542226,543672,545142,546596,548052,549503,550946,552381,553805,555220,556626,558026,559430,560823,562203,563591,564959,566321,567678,569034,570382,571721,573094,574473,918384,918556,921077,921249,923933,926623,929339,932045,934752,937457,940188,942906,945611,948313,951021,953721,956410,959087,961743,964388,967024,969656,972284,974904,977516,980123,982715,985297,987921,990540,993156,995761,998356,1000940,1003521,1006092,1008659,1011224,1013804,1016364,1018916,1021463,1024008,1026542,1029071,1031597,1325156,1327032,1328894,1330754,1911015,1911108,1913157,1913256,1915322,1915415,1917624,1919824,1922021,1924213,1926461,1928702,1930931,1933148,1935347,1937542,1939731,1941910,1944081,1946241,1948390,1950527,1952659,1954787,1956863,1958927,2365694,2368777,2371846,2374904,2377948,2380982,2384011,2387030,2390092,2393153,2396206,2399241,2402261,2405276,2408287,2411285,2414278,2417261,2420269,2423262,2426252,2429235,2432207,2435170,2438122,2441060,2443988,2446911,2449827,2452729,2455621,2458497,2461370,2464227,2467079,2469952,2472884,2475793,3449450,3451591,3453723,3455840,3457964,3460092,3462227,3464352,3466501,3468683,3470851,3473005,3475161,3477316,3479460,3481598,3483730,3485854,3487962,3490073,3492200,3494323,3496438,3498591,3500734,3502869,3505000,3507128,3509246,3511360,3511416,3511504,3513467,3513522,3513614,3515566,3515620,3515708,3517654,3517709,3517798,3519740,3519794,3519885,3521873,3521960,3523943,3524031,3526004,3526091,3528055,3528144,3530116,3530204,3532161,3532248,3534199,3534291,3536240,3536329,3538270,3538358,3540292,3540383,3542362,3542450,3544418,3544507,3546460,3546551,3548497,3548587,3550618,3552660,3554695,3556733,3558756,3560771,3562774,3564773,3566791,3568805,3570823,3572834,3574847,3576751,3578654,3580556,3595512)) 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 Nalbandyants (Singer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Anna Nalbandyants (Singer)

Anna Nalbandyants (Singer)

Anna Nalbandyants graduated from the Minsk Musical Glinka School in 2008. The same year, she entered the St Petersburg State Rimsky-Korsakov Conservatoire (Vocal Department). In 2013, she became a trainee and assistant of Irina Bogacheva at the Conservatoire. Since 2014, she has been a guest soloist with the Bolshoi Opera, where she debuted in 2014 as Gerda in the new production of Banevich’s Story of Kai and Gerda. In 2015, she performed there Barbarina in the new production of Mozart’s Le nozze di Figaro. She has also participated in several concerts at the Beethoven Hall of the Bolshoi Theatre (musical director of the concerts — Semyon Skigin) in the framework of the Bolshoi Theatre Young Artists Opera Program under the directorship of Dmitry Vdovin. In 2015, she underwent a traineeship at the Monte Carlo Opera Academy where she worked on her French and Italian répertoire and performed in the gala concert at the Garnier Hall of the Monte Carlo Opera on completion. 

Since 2015, she has been a trainee with the Mikhailovsky Opera. At the Mikhailovsky Theatre, she performs soprano parts in the operas by Gaetano Donizetti, Antonín Dvořák, and Boris Asafyev.