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 (1915732,1917944,1920145,1922343,1924532,1926780,1929022,1931251,1933465,1935664,1937860,1940049,1942228,1944399,1946560,1948708,1950843,1952974,1955102,1957178,1959242,1961290,1963328,1965356,1967377,1969395,1971407,1973417,1975414,1977400,1979371,1981369,1983361,1985346,1987324,1989294,1991252,1993188,1995129,1997057,1998976,2000890,2002793,2004684,2006559,2008446,2010331,2012207,2014070,2015910,2017736,2019547,2021354,2023155,2024948,2026941,2028931,2030910,2032874,2034834,2036788,2038737,2040675,2042601,2044509,2046409,2048296,2050181,2052053,2053916,2055867,2057906,2059939,2061966,2063986,2065996,2067998,2070004,2071995,2073974,2075946,2077910,2079908,2081899)) 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





	Olga Yakovleva (Mezzo soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Olga Yakovleva (Mezzo soprano)

Olga Yakovleva (Mezzo soprano)

• Prize-winner at the Pavel Lisitsian Competition (Vladikavkaz, 2006, 2nd prize)
• Prize-winner at the Bella voce international students’ competition (Moscow, 2005)

Born in St Petersburg. In 2007 she graduated from the St Petersburg State Rimsky-Korsakov Conservatoire (class of senior lecturer L.N. Fedotova). At the Conservatoire’s Opera Studio she performed roles including Dido (Purcell’s Dido and Aeneas), Dorabella (Mozart’s Cosн fan tutte), Cherubino (Mozart’s Le nozze di Figaro), Lyubasha (Rimsky-Korsakov’s the Tsar’s Bride) and Dolly (Vladislav Uspensky’s musical Anna Karenina).
Since 2005 she has been a soloist with the Mariinsky Academy of Young Singers.

Repertoire at the Mariinsky Theatre:
Fata Morgana (The Love for Three Oranges)
Matryosha the Gypsy (War and Peace)
Second Witness (The Lawsuit)
La Ciesca (Gianni Schicchi)
Miss Jessel (The Turn of the Screw)
Judith (Duke Bluebeard's Castle)

Repertoire also includes: Lyubasha (The Tsar’s Bride), Lyubava (Sadko), Olga (Eugene Onegin), Polina (The Queen of Spades), Eboli (Don Carlo), Amneris (Aida), Fenena (Nabucco), Santuzza (Cavalleria rusticana), Suzuki (Madama Butterfly), Siegrune (Die Walkьre), Verdi’s Requiem and Mozart’s Requiem.

She has toured to the USA and Hong Kong, and taken part in concerts by the Mariinsky Academy of Young Singers in Russia and abroad.