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 (1908188,1910345,1912495,1914660,1916878,1919084,1921284,1923481,1925717,1927964,1930198,1932419,1934625,1936823,1939018,1941201,1943377,1945541,1947696,1949837,1951971,1954102,1956181,1958250,1960309,1962351,1964382,1966406,1968427,1970442,1972455,1974460,1976453,1978431,1980399,1982394,1984384,1986367,1988335,1990296,1992244,1994183,1996115,1998043,1999962,2001871,2003767,2005650,2007534,2009412,2011298,2013165,2015010,2016842,2018660,2020472,2022277,2024072,2026070,2028065,2030050,2032021,2033989,2035948,2037898,2039841,2041768,2043686,2045590,2047486,2049375,2051253,2053121,2055080,2057118,2059157,2061188,2063212,2065227,2067234,2069232,2071231,2073218,2075195,2077164,2079168,2081164,2083151,2085083,2087005,2088916,2090823,2092724,2094614,2096493,2098358,2100319,2102270,2104231,2106186,2108131,2110066,2111990,2113902,2115805,2117700,2119587,2121464,2123331,2125183,2127024,2128858,2130684,2132500,2134307,2136101,2137885,2139728,2141562,2143387,2145201,2147005,2148799,2150579,2152346,2154105,2155854,2157592,3377724,3377726,3377732,3377736,3380024,3380026,3380032,3380036,3382307,3382309,3382315,3382319,3384597,3384600,3384606,3384611,3386871,3386874,3386880,3386885,3389131,3389134,3389140,3389145,3391385,3391388,3391394,3391399,3393628,3393631,3393637,3393642,3395857,3395860,3395866,3395871,3398073,3398076,3398082,3398087,3400280,3400283,3400289,3400294,3402474,3402477,3402483,3402488,3404657,3404660,3404666,3404671,3406829,3406832,3406838,3406843,3409002,3409005,3409011,3409016,3411153,3411156,3411162,3411167,3413282,3413285,3413291,3413296,3415436,3415439,3415445,3415450,3417578,3417581,3417587,3417592,3419710,3419713,3419722,3419729,3421819,3421822,3421831,3421838,3423908,3423911,3423920,3423927,3425975,3425978,3425987,3425994,3428023,3428026,3428035,3428042,3430054,3430057,3430066,3430073,3432068,3432071,3432080,3432087,3434075,3434078,3434087,3434094,3436075,3436078,3436087,3436094,3438062,3438065,3438074,3438081,3440035,3440038,3440047,3440054,3442001,3442004,3442013,3442020,3443979,3443982,3443991,3443998,3445955,3445959,3445970,3445978,3448106,3448110,3448121,3448129,3450249,3450253,3450264,3450272,3452384,3452388,3452399,3452407,3454508,3454512,3454523,3454531,3456627,3456631,3456642,3456650,3458751,3458755,3458766,3458774,3460890,3460894,3460905,3460913,3463020,3463024,3463035,3463043,3465170,3465174,3465186,3465194,3467314,3467318,3467330,3467338,3469487,3469491,3469503,3469511,3471649,3471653,3471665,3471673,3473803,3473807,3473819,3473827,3475959,3475963,3475975,3475983,3478109,3478113,3478125,3478133,3480251,3480255,3480267,3480275,3482383,3482387,3482399,3482407,3484510,3484514,3484526,3484534,3486628,3486632,3486644,3486652,3488738,3488742,3488754,3488762,3490871,3490875,3490887,3490895,3492997,3493001,3493013,3493021,3495117,3495121,3495133,3495141,3497274,3497278,3497290,3497298,3499421,3499425,3499437,3499445,3501561,3501565,3501577,3501585,3503694,3503698,3503710,3503718,3505822,3505826,3505838,3505846,3507945,3507949,3507961,3507969,3510061,3510065,3510077,3510085,3512173,3512177,3512189,3512197,3514275,3514279,3514291,3514299,3516369,3516373,3516385,3516393,3518456,3518460,3518472,3518480,3520542,3520546,3520558,3520566,3522616,3522620,3522632,3522640,3524685,3524689,3524701,3524709,3526741,3526745,3526757,3526765,3528806,3528810,3528822,3528830,3530858,3530862,3530874,3530882,3532900,3532904,3532916,3532924,3534940,3534944,3534956,3534964,3536973,3536978,3536990,3536998,3538999,3539004,3539016,3539024,3541038,3541043,3541055,3541063,3543099,3543104,3543116,3543124,3545147,3545152,3545164,3545172,3547185,3547190,3547202,3547210,3549219,3549224,3549236,3549244,3551261,3551266,3551278,3551286,3553298,3553303,3553315,3553323,3555339,3555344,3555356,3555364,3557369,3557374,3557386,3557394,3559387,3559392,3559404,3559412,3561396,3561401,3561413,3561421,3563396,3563401,3563413,3563421,3565421,3565433,3565441,3567449,3567457,3569472,3569480,3571491)) 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





	Marianne Beate Kielland (Mezzo soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Marianne Beate Kielland (Mezzo soprano)

Marianne Beate Kielland (Mezzo soprano)

Marianne Beate Kielland has established herself as one of the foremost singers of Scandinavia, and is one of the few Norwegian singers to have received a Grammy nomination. The versatile mezzo soprano started her international career as an ensemble member of the Staatsoper Hannover, and since then she has been working frequently with leading orchestras and ensembles and enjoying a vast concert repertoire spanning from early 17th century works through to Classical, Romantic and the contemporary eras.

Highlights in 16/17 season include Beethoven Missa Solemnis with the 18th Century Orchestra on tour to the Netherlands, Beethoven Symphony No.9 with the Bergen Philharmonic, Messiah with Malmö Symphony, Bach St John Passion with Oslo Philharmonic, St Matthew Passion with BBC Philharmonic, and Haydn Seven Last Words with L'Orchestre de Chambre de Genève.

Her recent symphonic and oratorio appearances include Bach's St. Matthew Passion with Oslo Philharmonic, NDR Radiophilharmonie and Cologne Chamber Orchestra, Mass in B minor with Gothenburg Symphony, Gli Angeli Genève and Norwegian Baroque Orchestra, Christmas Oratorio with Tonkünstler Orchestra and Trondheim Symphony Orchestra, Bach Cantatas with Bachstiftung St. Gallen, Couperin's Leçons de ténèbres with The King's Consort, Handel's Messiah with Musica Vitae, Pergolesi's Stabat Mater with Cologne Chamber Orchestra, Haydn's Arianna a Naxos with the Budapest Festival Orchestra, SWR Sinfonieorchester and Anima Eterna, Beethoven's Symphony No. 9 with Oslo Philharmonic, Swedish Chamber Orchestra and at the Sydney Opera House, Mahler's Symphony No. 2 and Das Lied von der Erde with Helsingborg Symphony Orchestra, Lieder eines fahrenden Gesellen with Trondheim Symphony Orchestra, Berio's Folksongs with Kristiansand Symphony Orchestra.

She has also appeared with other major orchestras and ensembles including Wiener Symphoniker, Bergen Philharmonic, Norwegian Radio Orchestra, Gothenburg Symphony, Iceland Symphony, Mahler Chamber Orchestra, Royal Flemish Orchestra, Akademie für alte Musik Berlin, Concerto Köln, Europa Galante, Les Talens Lyriques, RIAS Kammerchor, Anima Eterna, Le Concert des Nations, Collegium Vocale Gent and Bach Collegium Japan; and has worked with such distinguished conductors as Rinaldo Alessandrini, Fabio Biondi, Harry Christophers, Thomas Dausgaard, John Fiore, Philippe Herreweghe, Manfred Honeck, René Jacobs, Nicholas Kraemer, Andrew Manze, Marc Minkowski, Vasily Petrenko, Daniel Reuss, André de Ridder, Helmut Rilling, Christophe Rousset, Jukka-Pekka Saraste, Federico Maria Sardelli, Jordi Savall, Masaaki Suzuki, Thomas Søndergård and Robin Ticciati.

Kielland is also in great demand for Baroque operatic roles including Merope in Vivaldi's Oracolo in Messenia (an extensive tour with Europa Galante), Messaggiera and Proserpina in Monteverdi’s Orfeo, Fernando in Attilio Ariosti’s La Fede nei tradimenti, Apollo in Handel's Terpsichore, Ercole in Caldara’s Il piu bel nome, Monteverdi's Il Combattimento di Tancredi e Clorinda and Aronne in Francesco Nicolò Fago’s Il Faraone Sommerso.

Kielland has made more than 40 CD recordings of oratorios, operas, cantatas and songs by Bach, Handel, Vivaldi, Caldara, Scarlatti, Beethoven, Schumann, Mussorgsky, Martin, Chausson, Korngold, von Suppé, Schönberg, Webern, Berg and Sigurd Islandsmoen. In 2012 she was nominated to a GRAMMY Award in the category Best Classical Vocal Solo for the album Veslemøy Synsk, which features works by composers Edvard Grieg and Olav Anton Thommesen. She performs regularly with pianist Nils Anders Mortensen and the duo have appeared in Norway, Germany Estonia, Russia and Finland.