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 (1494108,1495409,1496704,1497997,1499295,1500580,1501859,1503133,1504395,1505655,1506904,1508146,1509377,1510603,1511832,1513055,1514278,1515505,1516727,1517936,1519138,1520339,1521531,1522718,1523897,1525069,1526234,1527392,1528544,1529691,1530834,1531973,1533107,1534237,1535363,1536484,1537600,1538740,1539873,1541000,1542122,1543239,1544346,1545448,1546540,1547620,1548688,1549745,1550797,1551841,1552886,1553927,1554961,1555984,1556995,1558007,1559008,1560007,1561360,1563050,1564886,1566713,1569355,1572253,1575140,1578017,1580884,1583737,1586577,1589411,1592240,1595063,1597937,1600803,1603657,1606499,1609336,1612166,1614987,1617798,1620598,1623382,1626151)) 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





	Vello Pahn (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Vello Pahn (Conductor)

Vello Pahn (Conductor)

Vello Pähn graduated from Tallinn State Conservatory in 1981, having studied conducting with Roman Matsov and continued his studies at St. Petersburg Conservatory in 1981–1986 with Arvīds and Maris Jansons. In 1982–1984 he was engaged at the Estonian National Opera. Since autumn 2012 he is the Artistic Director and Chief Conductor of the Estonian National Opera. He has conducted numerous operas, including Bizet’s “Carmen”, Puccini’s “Madama Butterfly”, Verdi’s “La traviata”, Mussorgsky’s “Khovanshchina”, Donizetti’s “L’elisir d’amore”, Tchaikovsky’s “Eugene Onegin”, Mozart’s “Le nozze di Figaro”, Wagner’s “Der fliegende Holländer”, Gounod’s “Faust”, etc, and ballets, such as Prokofiev’s “Cinderella”, Neumeier’s “Othello” to the music of Pärt, Schnittke, Vasconcelos et al, and “Die Kameliendame” to the music of Chopin, Stravinsky’s “The Rite of Spring”, etc. Since 1988 he has conducted at Opera National de Paris, since 1992 at Hamburg State Opera, since 1999 at Dresden Semperoper and since 2000 at Staatsoper Berlin and has worked with the legendary dancers and choreographers Rudolf Nureyev, John Neumeier and Maurice Bejart, etc. In addition to the aforementioned, he has been a guest conductor at Staatstheater Stuttgart, Deutsche Oper Berlin, Teatro alla Scala, Teatro San Carlo in Napoli, Wiener Staatsoper, Gothenburg Opera, Leipzig Opera, Dresden Semperoper and many others. Vello Pähn has conducted various orchestras in Italy, France, Russia, Japan, USA, Greece, Sweden, Latvia, Finland, Denmark, Spain, etc. At the Estonian National Opera, Vello Pähn has been the music director for the following operas and ballets: Gounod’s “Faust” (2012), Strauss’ “Der Rosenkavalier” (2012, concert performance) and “Arabella” (2015, first time in Estonia, concert performance ), Wagner’s “Tannhäuser” (2013), Tõnu Kõrvits’ “Butterfly” (2013, world premiere), Gounod’s “Roméo et Juliette” (2013, concert performance), Rimsky-Korsakov’s “Snegurochka” (2014, first time in Estonia, concert performance), Gianluca Schiavoni’s “Medea” (2014, world premiere), Tchaikovsky’s ballet “The Sleeping Beauty” (2014), John Cranko’s “Onegin” (2015, first time in Estonia), Hindemith’s Cardillac” (2015, first time in Estonia), Tubin’s “The Goblin” (2015), Verdi’s “Aida” (2016), Wagner’s “Der fliegende Holländer” (2016) and Adam’s “Giselle” (2017). Vello Pähn is the winner of the Annual Estonian Theatre Award 2016 for the interpretation of Hindemith’s “Cardillac” and Strauss’ “Arabella” on a high artistic level and the Estonian Music Council Interpretation Prize 2016.vel.