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 (35578,37119,37187,37206,38671,38737,38761,40189,40209,212326,213861,215397,216928,218457,219980,221499,223013,224522,226033,227538,229037,231022,233017,235006,236991,238965,240931,242892,244850,246804,248751,250695,252678,254652,256616,258577,260543,262503,264470,266429,268381,270322,272261,274194,276128,278052,279929,281797,283660,285517,287372,289214,291052,292948,294836,296716,298590,300461,302353,304235,306161,308085,342306,344230,346146,348053,349943,351820,353699,355571,357448,359355,361254,363146,365028,366909,368785,370654,372519,374373,376221,378056,379889,381717,497397,498860,500316,501770,503261,504742,506214,507684,509150,509154,510612,510618,512067,512073,513518,513520,514989,514993,516453,516455,517906,517910,519354,549554,551001,552436,553859,555275,556681,558083,559480,560873,562259,563641,565010,566371,567730,569084,570432,571773,573150,574522,575883,577241,578593,579934,581267,582592,583916,585229,586540,587843,589139,732032,733017,734006,734989,735961,736935,737903,738863,739819,741790,743766,745735,747696,749681,751663,753645,756521,759391,762257,765120,767976,770825,773668,776505,779338,782174,785007,787835,790659,793479,796284,799091,801894,804692,807484,810270,813051,815828,818599,821363,824119,826868,829612,832352,835086,837815,840542,843265,846010,848750,851481,854214,856943,859665,862382,865089,867784,870467,873150,875833,878520,1039310,1041794,1044270,1044324,1046737,1046791,1049197,1049248,1051641,1051692,1054071,1054121,1056498,1056548,1058920,1058970,1061328,1061379,1063729,1063780,1066122,1066174,1068504,1068556,1070874,1070926,1073274,1073326,1075667,1075719,1078050,1078102,1080421,1080473,1082782,1082836,1085127,1085181,1087455,1087510,1089775,1089828,1092105,1092158,1094427,1094481,1096737,1096791,1099034,1099088,1101311,1101365,1103582,1103636,1105831,1105885,1108058,1108113,1110265,1110320,1112455,1112507,1114623,1114676,1116772,1116825,1118907,1118964,1121038,1121092,1123181,1123235,1125315,1125367,1127502,1127559,1129725,1129779,1131928,1131983,1134119,1134174,1136323,1136378,1138525,1138580,1140723,1140780,1142914,1142970,1145153,1147323,1149479,1151632,1153778,1155919,1155951,1158091,1158123,1160253,1160283,1162399,1162432,1164533,1164566,1166662,1166692,1168829,1170954,1173071,1175180,1177320,1179449,1181576,3550553,3552595,3554627,3556666,3558690,3560704,3893835,3894558,3895274,3895988,3896695,3897403,3898108,3898809,3899512,3900208,3900927,3926435,3927099,3927757,3928418,3929072,3929726,3930374,3931021,3931666,3932309,3932950,3933593,3934232,3934870,3935506,3936141,3936796,3937447,3938099,3956419,3957042,3957663,3958281,3958894,3959502,3960108,3960705,3961307,3961905,3962492,3963070)) 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





	Nadezhda Vassilieva (Soloist) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Nadezhda Vassilieva (Soloist)

Nadezhda Vassilieva (Soloist)

Born in Kazakhstan. Graduated from the Leningrad State Conservatoire (vocal solo class of Professor Barinova). Postgraduate course as assistant to Professor Kovaleva at the St Petersburg Conservatoire from 1991-1993. International competition diploma winner.
Mariinsky Theatre soloist since 1993.

Diploma recipient at the International Rimsky-Korsakov Opera Singers’ Competition (1994, St Petersburg).

Nadezhda Vasilieva was born in Kazakhstan. She studied at the conducting and choral faculty of the Leningrad Institute of Culture. Graduated from the Leningrad State Rimsky-Korsakov Conservatoire in 1984 (class of Professor Barinova). She was a soloist with the Sverdlovsk Opera and Ballet Theatre from 1984-1986, where she performed the roles of the Angel (The Demon), Marina Mnishek (Boris Godunov), Siebel (Faust), Lyubasha (The Tsar’s Bride) and Olga (Eugene Onegin). Carried out an assistantship with Professor Kovaleva at the St Petersburg Conservatoire from 1991-1993.
Mariinsky Theatre soloist since 1993.

Roles she has performed at the Mariinsky Theatre include:
Ratmir (Ruslan and Lyudmila)
Fekla (The Marriage)
Hostess of the Inn, Xenia’s Nurse (Boris Godunov)
Sister-in-Law (May Night)
Bobylikha (The Snow Maiden)
Nezhata (Sadko)
Solokha (Christmas Eve)
Petrovna (The Tsar’s Bride)
Babarikha (The Tale of Tsar Saltan)
Kashcheyevna (Kashchei the Immortal)
Alkonost (The Legend of the Invisible City of Kitezh and the Maiden Fevronia)
Amelfa (The Golden Cockerel)
Marthe (Iolanta)
Old Gypsy Woman (Aleko)
Death (Le Rossignol)
Smeraldina (The Love for Three Oranges)
Fortune-Teller, Nun (The Fiery Angel)
Duenna (Betrothal in a Monastery)
Sonetka (Katerina Ismailova)
The Snow Queen, Grandmother (The Story of Kay and Gerda)
Berta (Il barbiere di Siviglia)
Zita (Gianni Schicchi)
Siegrune (Die Walkьre)

She has appeared in premiere performances of productions of The Tale of Tsar Saltan and Kashchei the Immortal (1993), Ruslan and Lyudmila and The Legend of the Invisible City of Kitezh and the Maiden Fevronia (1994), Katerina Ismailova (1995), Betrothal in a Monastery (1996), Gianni Schicchi (2003), The Snow Maiden (2004) and Christmas Eve (2009).

She has toured with the Mariinsky Opera Company and independently to Germany (Hamburg Opera), Italy, Spain, Japan, the USA, Belgium, the Netherlands, Portugal, Great Britain and Israel. With the Kazan Theatre of Opera and Ballet she has toured to Great Britain, appearing in the role of Amneris (Aida).