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 (1477073,1478421,1482949,1482959,1484305,1484315,1485649,1485659,1486984,1486994,1488308,1488318,1489614,1489624,1490909,1490919,1492195,1492205,1493509,1493519,1494814,1494824,1496111,1496121,1497407,1497418,1498710,1498721,1500003,1500014,1501286,1501297,1502562,1502573,1503830,1503841,1505091,1505102,1506344,1506355,1507591,1507602,1508828,1508839,1510056,1510067,1511279,1511292,1512504,1512517,1513732,1513745,1514953,1514966,1516176,1516189,1517391,1517404,1518597,1518610,1519800,1519813,1520996,1521009,1522186,1522199,1523370,1523383,1524545,1524558,1525713,1525726,1526874,1526887,1528029,1528042,1529178,1529191,1530323,1530336,1531464,1531477,1532602,1532613,1533734,1533745,1534862,1534873,1535986,1535997,1537105,1537116,1538218,1538229,1539355,1539366,1540485,1540496,1541610,1541621,1542729,1542740,1543840,1543851,1544945,1544956,1546043,1546054,1547128,1547139,1548201,1548212,1549264,1549275,1550319,1550332,1551367,1551380,1552406,1552419,1553447,1553460,1554482,1554495,1555509,1555522,1556527,1556540,1557537,1557550,1558545,1558558,1559543,1559556,1560901,1560914,1562250,1562263,1564093,1564106,1565926,1565939,1567751,1567762,1570674,1570686,1573567,1573574,1576447,1576460,1579318,1579331,1582181,1582194,1585028,1585041,1587865,1587878,1590701,1590714,1593526,1593539,1596383,1596396,1599254,1599267,1602112,1602124,1604962,1604975,1607801,1607813,1610635,1610647,1613461,1613473,1616280,1616293,1619084,1619097,1621875,1621888,1624650,1624663,1627419,1627432,1630176,1630187,1632923,1632934,1635723,1635737,1638552,1638565,1641393,1641406,1644219,1644230,1647033,1647044,1649846,1649859,1652715,1652728,1655588,1658436)) 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





	Liparit Avetisyan (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Liparit Avetisyan (Tenor)
			

																
Liparit Avetisyan (Tenor)

														
				


        




    

        
Born on the 30th of November 1990 in Yerevan, Republic of Armenia, he graduated in 2008 from the Musical School in Feodosia, Crimea in the specialization of vocal.

In 2008, he joined the Tchaikovsky State Moscow Conservatory, and followed the class of Professor Boris Kudravtsev. In 2010, he won the second prize in the "Muse of the World" International Vocal contest in Moscow. In 2011, he was transferred to Yerevan Komitas State Conservatory, in the class of professor Rafael Hakobyants.

He had numerous solo recitals in Armenia and worldwide (Great Britain, France, Italy, Belgium, China, Russia and Ukraine).

He participated in prestigious festivals like the Armenian Young Talents, Viva Verdi, the XXI International Music Festival Stars of the White Nights and the Easter Music Festival.

In 2013, he won the second prize and the Audience Prize at the Maria Biesu II International Competition for opera singers.

Since 2013, he is a soloist of the Yerevan State Opera and Ballet Theatre – named after A. Spendiaryan. He sings leading roles in operas of Armenian and foreign composers (Saro in A. Tigranyan’s "Anoush", Alfredo in G. Verdi’s "La Traviata", the Young Gypsy in S. Rachmaninov’s "Aleko" and Don Jose in G. Bizet’s "Carmen"). His repertoire list also includes chamber music (W. A. Mozart’s Requiem, G. Verdi’s Requiem, G. Mahler Das Lied von der Erde – "The Song of the Earth", C. Saint-Saens’ Oratorio de Noel – "Christmas Oratorio", J. S. Bach’s Magnificat).

In 2014, he participated in the VII Mirjam Helin International Singing Competition for which he obtained a diploma. The same year, he won the second prize and special prizes in the III Muslim Magomaev International Singing Competition.

In 2015 debuted at the Stanislavsky and Nemirovich-Danchenko Music Theatre as des Grieux in Massenet's "Manon". Alsо performes here the parts of Almaviva in Rossini's "Il Barbiere di Siviglia" and Prince in Prokofiev's "The Love for Three Oranges".
 
        

    

    

            


			

		





	


	

	

		


			

				

					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