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 (478136,478240,479710,479811,497473,498936,500391,501845,502108,503334,503600,504816,505078,506287,506549,507759,508021,509227,509490,510690,510953,512146,512409,513596,513894,515066,515368,516530,516830,517983,518283,519427,519727,520869,521169,522306,522606,523740,524038,525157,525457,526567,526865,527971,528272,529374,529676,530774,531075,532170,532469,533550,533855,534987,535290,536412,536714,537843,538143,539266,539568,540681,540984,542116,542427,543557,543908,545379,546832,548288,549739,551182,552621,554045,555461,556868,558270,559669,561062,562449,563831,565200,566561,567918,569274,570621,571961,573336,574708,576073,577431,578783,580124,581457,582778,584106,585420,586725,588033,589329,590969,592610,594245,595945,597635,599316,600988,602664,604334,605992,607641,609279,610966,612643,614320,615982,617630,619265,620896,622519,624133,625758,627372,628982,630578,632166,633750,635323,636884,638437,639976,641506,643025,644539,646045,647540,649032,650526,652007,653483,654949,656404,657849,3860830,3861626,3862420,3863209,3863996,3864781,3865561,3866339,3867113,3867885,3868655,3869420,3870188,3870951,3871711,3873200,3873955,3874707,3875458,3876205,3876951,3877695,3878438,3879181,3879921,3880662,3881405,3882148,3882892,3883633,3884372,3885111,3885847,3886581,3887317,3888050,3888780,3889508,3890236,3890959,3891679,3892395,3893111,3893824,3894543,3895261,3895974,3896684,3897390)) 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





	Andreas Schager (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Andreas Schager (Tenor)

Andreas Schager (Tenor)

Austrian tenor Andreas Schager has been acclaimed throughout Europe and North America for his performances of highly demanding parts of the Heldentenor repertoire.

Mr. Schager starts the 2015-16 season singing the title role in Wagner´s Tannhäuser conducted by Dmitri Jurowski at Vlaamse Opera. Audiences in Berlin have the opportunity to hear him a number of times this season at the Staatsoper Berlin as Max in Weber´s Der Freischütz, Erik in Wagner´s Der fliegende Holländer, the title role in Wagner´s Parsifal under Daniel Barenboim, and at the end of the season at Staatsoper as Siegfried in Wagner´s Siegfried and Die Götterdämmerung, again under Daniel Barenboim. He sings Siegmund in Wagner´s Walküre at Theater Meiningen and at Oper Leipzig, where he also takes the stage singing the title role in Wagner´s Rienzi.  Andreas Schager will appear in two productions at the Mariinsky Theatre in St. Petersburg under Valery Gergiev, repeating Siegfried in Die Götterdämmerungand singing Tristan in Wagner´s Tristan und Isolde. In addition to his close collaboration with Daniel Barenboim and Valery Gergiev this season, Mr. Schager will also appear in concert twice with Marek Janowski and the Rundfunk-Sinfonieorchester Berlin, singing Beethoven´s Symphony No. 9 at the Konzerthaus Berlin and singing Siegfried at the Bunka Kaikan Concert Hall in Tokyo. On the concert stage, one of the highlights will be his performance of Schönberg’s Gurrelieder at Opéra Bastille in Paris under Philippe Jordan. In future seasons Andreas Schager will debut with the Canadian Opera Company and the Bayreuth Festival.

In the 2014-15 season some of Mr. Schager´s highlights included his concert performances as Menelas in Strauss´ Die Ägyptische Helena at Oper Frankfurt under Stefan Soltesz and his role debut as Parsifal at the Staatsoper Berlin under the baton of Daniel Barenboim and in a new production by Dmitri Tcherniakov. He also had his US and New York debuts as Apollo in Richard Strauss´ Daphne with the Cleveland Orchestra under Franz Welser-Möst in Cleveland and at Carnegie Hall in New York, a role he also sang in a staged production at Théâtre du Capitole in Toulouse. He was engaged as Tristan inTristan und Isolde under the baton of Myung-Whun Chung and Tokyo Philharmonic Orchestra, as well as with the West Eastern Divan Orchestra under Daniel Barenboim in Sevilla.

In 2013-14 he could be heard at Vlaamse Opera and at Staatstheater Darmstadt in the role of Tristan in Tristan und Isolde, as Siegfried in Siegried and Die Götterdämmerung at Oper Halle and as Max in Der Freischütz at Oper Köln. He also sang Apollo in Hartmut Haenchen's Daphne at the Théâtre du Capitole in Toulouse, and later in that season the first act of Valkyrie in concert with the Bamberg Symphony under the direction of Jonathan Nott.

Highlights of the 2012-13 season included his performance of Siegfried in Die Götterdämmerung at the Staatsoper Berlin conducted by Daniel Barenboim, a production also presented at the BBC Proms in London and his debut at the Teatro alla Scala with the same piece. Mr. Schager came to international attention through celebrated performances of the title role in Rienzi with the Deutsche Oper Berlin, Teatro Real in Madrid, Rome Opera and with the Hamburg State Opera.

Mr. Schager studied with Prof. Walter Moore at the University for Music in Vienna. He completed his studies with James King and Toma Popescu. He began gaining acclaim through his performances in various competitions: in 1998 he won the Special Jury Prize at the 5th International Viennese Music Competition. The following year, he won the medal of the Foundation „Jean-Frédéric Perrenoud“ in Neuchâtel in Switzerland, the Critic’s Prize and the Prize of the town Constanza in the International Competition for Tenors in Lugoj, Romania, which led to his opera debut as Ferrando in Così fan tutte at the Festival Mozart in Schönbrunn.

In the following years he sang numerous lyrical tenor roles appearing on stage in a large number of theaters and festivals, like the Teatro Comunale di Bologna, the Theater Koblenz, the Alte Oper Frankfurt, the International Music Festival Chiemgau, and the Wiener Festwochen. He has also performed the roles of Der Steuermann and Erik in Der Fliegende Holländer with the Tiroler Festspiele Erl, where he also performed David in Die Meistersinger von Nürnberg under the direction of Gustav Kuhn.

His concert repertoire includes the main works of Bach, Beethoven, Haydn, Mendelssohn and Mozart. Andreas Schager has been featured in performances in the Franz Liszt Hall in Budapest, the Wiener Konzerthaus, the Wiener Musikverein and the Mozarteum Salzburg. He has performed Mahler’s Das Lied von der Erde at the Gustav Mahler Music Weeks in Toblach and the tenor part in Beethoven’s Symphony No. 9 in Bolzano and Ravenna. He has given numerous Lied recitals, with Jörg Demus and Walter Moore, amongst others.