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 (2451004,2451021,2451027,2453907,2453924,2453930,2456808,2456814,2459687,2459693,2462557,2465412,2815072,2815082,2815103,2815112,2818055,2818065,2818086,2818095,2821031,2821041,2821062,2821071,2824003,2824013,2824034,2824043,2826979,2826989,2827010,2827019,2829938,2829948,2829969,2829978,2832880,2832890,2832911,2832920,2835807,2835817,2835838,2835847,2838741,2838751,2838772,2838781,2841665,2841675,2841696,2841705,2850239,2850249,2850270,2850279,2862917,2865694)) 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





	David Hansen (Countertenor ) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters David Hansen (Countertenor )

David Hansen (Countertenor )

Biography

David Hansen was born in Sydney, Australia. He studied singing with Andrew Dalton at the Sydney Conservatorium of Music and furthered his studies with James Bowman, David Harper and Graham Pushee. 

Highlights of David’s 2016/17 season included a return to Den Norske Opera in the title role of Gluck’s Orfeo ed Euridice under Rinaldo Alessandrini, Handel’s Parnasso in Festa under Marcon, Handel’s Theodora for the Händel-Festspiele Karlsruhe, Telemaco in Monteverdi’s Il ritorno d’Ulisse in patria under De Marchi for the Innsbruck Festival of Early Music and concerts with Brodsky Quartet. 

David made his European début in 2004 for the Aix-en-Provence Festival in Purcell’s Dido and Aeneas. Shortly thereafter, he made his UK début in concerts with the Scottish Chamber Orchestra under the baton of Emmanuelle Haïm, as well as performing the title-role in Handel’s Fernando with Il Complesso Barocco under Alan Curtis. 

Other operatic engagements include the title-role in Handel’s Serse under Jean-Christophe Spinosi, Ligeti’s Le Grand Macabre (Fiore/Den Norske Opera), Monteverdi’s Il ritorno d’Ulisse in patria (De Marchi/Den Norske Opera), Bertarido in Handel’s Rodelinda (Curtis/Bilbao), Trinculo in the American premiere of Thomas Adès’ The Tempest (Alan Gilbert/Santa Fe Opera), Handel’s Giulio Cesare (De Marchi/Sächsische Staatsoper Dresden; René Jacobs/Theater an der Wien; Alessandrini/Den Norske Opera; Spering/Teatro de la Maestranza, Sevilla), Monteverdi’s L’Orfeo (Jacobs/Deutsche Staatsoper-Berlin), Mozart’s Mitridate(Christophe Rousset/Théâtre Royal de la Monnaie), Handel’s Semele (Rousset/Théâtre Royal de la Monnaie), Nerone in Monteverdi’s L’incorinazione di Poppea (Boston Early Music Festival; Teatro Calderón), the title-role in Bontempi’s Il Paride (Christina Pluhar/Innsbruck Festival of Early Music) and Cherubino in Mozart’s Le nozze di Figaro (Teatro Verdi, Sassari). He has worked with directors including Stefan Herheim, Katie Mitchell, Jonathan Kent, Barrie Kosky and Christof Loy. 

Concert highlights include Carmina Burana with the Berliner Philharmoniker under Sir Simon Rattle, Handel’s Saul at the Wiener Musikverein under Nikolaus Harnoncourt, the title-role in Handel’s Solomon with René Jacobs and the Orchestra of the Age of Enlightenment, Bach’s Johannes-Passion with Les Musiciens du Louvre Grenoble under Marc Minkowski and Handel’s Messiah under Fabio Biondi. 

David’s debut solo recording for Sony/dhm, Rivals – Arias for Farinelli & Co., with Academia Montis Regalis and Alessandro De Marchi was released in August 2013 to critical acclaim. His other recordings include Purcell: Music For Queen Mary, with the Academy of Ancient Music and the choir of King’s College Cambridge, available on EMI Classics, Cavalli’s Giasone and Vivaldi’s Griselda, both recorded for Pinchgut Opera Live, Bach’s Johannes-Passion with Les Musiciens du Louvre Grenoble under Minkowski for Erato/Warner Classics and Handel’s Parnasso in festa under Marcon for Pentatone.