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 (8439,10149,11732,13315,14661,16113,16953,16989,17025,17061,17097,17723,37155,37186,38702,38736,40156,40188,41673,43065,44426,45778,47123,48462,49796,51124,52443,53758,55071,56371,57735,59805,61868,63923,65970,68015,70057,72094,74124,76142,78152,80158,105713,107607,108023,109493,109910,111370,111787,113239,113657,115100,115518,116976,117395,118851,119269,120720,121140,122586,123006,124444,124864,126293,126713,128133,128553,129961,130382,131790,132211,133623,134044,135448,135869,137269,137690,139087,139508,140897,141318,142698,143119,144488,144909,146268,146689,148038,148460,149795,150218,151545,151968,153709,155439,157160,158871,160597,162326,164076,165817,167547,169268,170980,172685,174382,176066,177739,179402,181055,182702,184343,185974,187596,189208,190808,192397,193977,195268,195650,196032,196766,196778,198080,198092,199397,199409,200714,200726,202396,202408,204068,204080,205741,205750,207438,207448,209125,209138,210789,210802,212301,212308,212326,213836,213843,213861,215372,215379,215397,216903,216910,216928,218432,218439,218457,219955,219962,219980,221474,221481,221499,222988,222995,223013,224497,224504,224522,226007,226015,226033,227512,227520,227538,229011,229019,229037,230996,231004,231022,232991,232999,233017,234980,234989,235006,236964,236973,236991,238939,238948,238965,240905,240912,240931,242867,242873,242892,244824,244831,244850,246778,246785,246804,248725,248732,248751,250669,250676,250695,252653,252659,252678,254627,254633,254652,256591,256602,256616,258552,258558,258577,260519,260530,260543,262478,262490,262503,264445,264451,264470,266405,266416,266429,268357,268368,268381,270298,270309,270322,272237,272248,272261,274170,274181,274194,274237,276104,276114,276128,276170,278029,278039,278052,278095,279906,279916,279929,279972,281774,281784,281797,281840,283633,283643,283660,283699,285489,285500,285517,285556,287344,287354,287372,287411,289186,289196,289214,289254,291025,291036,291052,291093,292921,292932,292948,292989,294810,294821,294836,294877,296690,296701,296716,296758,298565,298575,298590,298631,300444,300461,300501,302335,302353,302393,304235,304275,306161,306201,308085,308125,310043,311958,313867,315772,317670,319560,321439,323309,325204,327101,424277,424287,424308,426001,426022,427721,429415,431103,432806,457371,458938,460494,462042,463594,465140,466682,468379,470082,471633,477982,477983,479552,479553,481117,481119,481866,481867,482604,482606,483338,483340,484077,484078,484828,484829,485573,485574,486311,486312,487035,487036,487750,487751,488464,488466,489178,489179,489887,489888,490589,490590,491288,491289,497402,497426,497439,498867,498890,498903,500323,500348,500358,501777,501800,501813,503269,503292,503302,504750,504773,504784,506222,506245,506255,507691,507716,507727,509162,509186,509197,510625,510650,510661,512079,512105,512115,513527,513550,513564,515001,515024,515037,516464,516488,516499,517918,517942,517953,519361,519386,519397,520803,520828,520839,522239,522265,522276,523693,523708,525112,525127,526521,526533,527925,527937,529328,529340,530739,532133,533522,549495,550937,552373,553798,555214,556621,558023,559420,560813,562199,563582,564952,566312,567669,569025,570373,571709,573091,584004,585317,586629,587930,589232,590873,592489,594117,595816,597505,599186,600859,602535,604202,605860,607509,609148,610835,612515,614189,615851,617499,638472,640011,641541,643064,644574,646080,647578,649068,650565,652044,653520,654986,656443,656467,657890,657915,659339,659364,660775,660806,662201,662232,663620,663650,665035,665067,666443,666471,667878,667906,669300,669326,670765,672189,673612,675018,676412,910581,910587,910588,913192,913198,913200,915822,915827,915830,918526,918531,918534,921220,921225,921227,923897,923904,923906,926590,926595,926597,929307,929312,929314,932014,932019,932020,934722,934727,934728,937427,937432,937433,940158,940163,940164,942875,942881,942882,945580,945586,945588,948282,948288,948290,950988,950995,950996,953688,953695,953696,956377,956385,956386,959054,959061,959062,961709,961716,961717,964349,964356,964357,966985,966992,966993,969618,969624,969625,972245,972252,972253,974865,974871,974872,977477,977483,977484,980084,980090,980091,982677,982681,982682,985262,985269,985270,987886,987893,987894,987928,987929,990505,990512,990513,990547,990548,993116,993122,993123,993160,993161,995726,995733,995734,995769,995770,998321,998328,998329,998364,998365,1000906,1000912,1000913,1000948,1000949,1003486,1003493,1003494,1003529,1003530,1003655,1003656,1006061,1006068,1006069,1006102,1006103,1006227,1006228,1008628,1008634,1008635,1008669,1008670,1008794,1008795,1011188,1011193,1011194,1011228,1011229,1011353,1011354,1013772,1013773,1013808,1013809,1013934,1013936,1016371,1016372,1016498,1016499,1018920,1018921,1019047,1019048,1021467,1021468,1021594,1021595,1024012,1024013,1024139,1024140,1024216,1024217,1026546,1026547,1026674,1026675,1026751,1026752,1029076,1029077,1029204,1029205,1029281,1029282,1031601,1031602,1031659,1031724,1031730,1031731,1031808,1031809,1034104,1034105,1034162,1034227,1034233,1034234,1034311,1034312,1036652,1036717,1036723,1036724,1036799,1036800,1039141,1039206,1039212,1039214,1039288,1039289,1041625,1041690,1041697,1041698,1041771,1041772,1044101,1044166,1044173,1044174,1044247,1044248,1046568,1046633,1046640,1046641,1046714,1046715,1049025,1049090,1049097,1049098,1049171,1049173,1051469,1051534,1051541,1051542,1051615,1051617,1053899,1053964,1053971,1053972,1054044,1054046,1056326,1056391,1056398,1056399,1056471,1056473,1058746,1058813,1058820,1058821,1058893,1058895,1061155,1061222,1061229,1061230,1061303,1061304,1063556,1063623,1063630,1063631,1063704,1063705,1065949,1066017,1066024,1066026,1066098,1066099,1068331,1068399,1068407,1068408,1068480,1068481,1070767,1070775,1070776,1070850,1070851,1073167,1073175,1073176,1073250,1073251,1075560,1075568,1075569,1075643,1075644,1077943,1077951,1077952,1078026,1078028,1080314,1080322,1080323,1080398,1080399,1082673,1082682,1082683,1082758,1082759,1085018,1085026,1085027,1085103,1085104,1087347,1087355,1087356,1087432,1087433,1089666,1089674,1089675,1089751,1089753,1091996,1092004,1092005,1092081,1092084,1094318,1094326,1094327,1094403,1094406,1096628,1096636,1096637,1096713,1096717,1098925,1098932,1098933,1099009,1099012,1101209,1101210,1101290,1101291,1103480,1103481,1103561,1103562,1105810,1105811,1108038,1108039,1110245,1110246,1112429,1112430,1114600,1114601,1116746,1116749,1118887,1118889,1121012,1121015,1123159,1123160,1125291,1125292,1127483,1127484,1129703,1129704,1175180,1177320,1179449,1181576,1256702,1258665,1260620,1262562,1264491,1266412,1268338,1270253,1272156,1274050,1275924,1277783,1279638,1281486,1283326,1285156,1286980,1288782,1290564,1292376,1294187,1295986,1297777,1299558,1301324,1303074,1304824,1306567,1308303,1310027,1311746,1313667,1315603,1317529,1319452,1321367,1323270,1325167,1327043,1328905,1330762,1332644,1334515,1553858,1554892,1555913,1556926,1557936,1558939,1559931,1561284,1562978,1564816,1566644,1569281,1572176,1575063,1577940,1580807,1583660,2386985,2390049,2393105,2396161,2399196,2402214,2405229,2408241,2411239,2414231,2417212,2420220,2423217,2426203,2429185,2432160,2435120,2438075,2441014,2443941,2446865,2449780,3268767,3270817,3272944,3275053,3277147,3279237,3281371,3283501,3283677,3285620,3285792,3287770,3287944,3289902,3290076,3292021,3292195,3294122,3294296,3296224,3296399,3298315,3298494,3300401,3300575,3302476,3302649,3304538,3304716,3306589,3306764,3308635,3308809,3310677,3310851,3312710,3312886,3314731,3314903,3316740,3316911,3318741,3318912,3320729,3320901,3322714,3322886,3324861,3325036,3327131,3327301,3329517,3329695,3331900,3332073,3334267,3334439,3336789,3339142,3341483,3343824,3346175,3348532,3350866,3353192,3355509,3357837,3360186,3362549,3364899,3367240,3369569,3371895,3374212,3376522,3378831,3381127,3381238,3383396,3383508,3385681,3385794,3387946,3388061,3390207,3390322,3392460,3392573,3394699,3394809,3396922,3397033,3399134,3399248,3401335,3401448,3403525,3403639,3405707,3405821,3407875,3407989,3410039,3410154,3412181,3412296,3414354,3414465,3416498,3416612,3418641,3418753,3420762,3420873,3422868,3422977,3425057,3427117,3429159,3431184,3433193,3435197,3437195,3439173,3441141,3443105,3445080,3447234,3449382,3451521,3453652,3455769,3457897,3460017,3460110,3462156,3462248,3464279,3464373,3466430,3466525,3468612,3468705,3470777,3470873,3472933,3473031,3475088,3475187,3477241,3477336,3479389,3479484,3481623,3483752,3485872,3487984,3490093,3492221,3494345,3496463,3498614,3500759,3502894,3505025,3507148,3509270,3511384,3513492,3515585,3517675,3519765,3521842,3523913,3525968,3528024,3530081,3534271,3536308,3538341,3540361,3542432,3544489,3546529,3548568,3550601,3552642,3554674,3556715,3558737,3560751,3562755,3564757,3566775,3568787,3570806,3572812,3574828,3576732,3578636,3580537,3582428,3584289,3586147,3807852,3808228,3808601,3808970,3809338,3809704,3810066,3810426,3810784,3811175,3811559,3893835,3894558,3895274,3895988,3896695,3897403,3898108,3898809,3899512,3900208,3900927,3953301,3953918,3956419,3957042,3957663,3958281,3958894,3959502,3960108,3960705,3961307,3961905,3962492,3963070,4138023,4138690,4139356,4140019,4140680,4141333,4141985,4142633,4143282,4143920,4144558)) 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





	Irina Vasilieva (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Irina Vasilieva (Soprano)

Irina Vasilieva (Soprano)

Soprano

• Prize-winner at the International Vocal Competition in Verona (Italy, 1999).
• Prize-winner at the International Elena Obraztsova Competition (St Petersburg, 1999).
• Recipient of a special diploma and prize for best performance of a work by a 20th century composer at the IV International Rimsky-Korsakov Young Opera Singers? Competition (St Petersburg, 2000).
• Prize-winner at the International Izabella Yurieva Competition (Tallinn, 2004).
Soprano

• Prize-winner at the International Vocal Competition in Verona (Italy, 1999).
• Prize-winner at the International Elena Obraztsova Competition (St Petersburg, 1999).
• Recipient of a special diploma and prize for best performance of a work by a 20th century composer at the IV International Rimsky-Korsakov Young Opera Singers? Competition (St Petersburg, 2000).
• Prize-winner at the International Izabella Yurieva Competition (Tallinn, 2004).

Graduated from the St Petersburg State Rimsky-Korsakov Conservatoire (composition class of Professor Slonimsky and vocal class of Yevgenia Perlasova).
Soloist with the Mariinsky Academy of Young Singers from 1999.
Made her Mariinsky Theatre debut in 2000 as Wellgunde in the premiere of Wagner?s Das Rheingold. Joined the Mariinsky Opera Company in 2005.

Repertoire includes:
Polovtsian Maiden (Prince Igor),
Brigitta (Iolanta in concert),
Povarikha (The Tale of Tsar Saltan),
soprano part (Les Noces),
Arsinoia (Cimarosa?s Cleopatra),
Corinna (Il viaggio a Reims),
Anna (Nabucco),
Musetta (La boheme),
Amour (Orphee et Eurydice in concert),
Mercedes (Carmen),
Wellgunde (Das Rheingold and Gotterdammerung),
Ortlinde (Die Walkure),
Echo and Naiad (Ariadne auf Naxos),
Mozart?s Requiem,
Mahler?s Eighth Symphony.

At the Great Hall of the St Petersburg Shostakovich Philharmonic in 2003 she performed Handel?s Messiah with the Lege Artis chorus, and in 2005 she performed Richard Strauss? Vier Letzten Lieder cycle for voice and orchestra. In 2003 at the Tchaikovsky Concert Hall (Moscow) she performed the soprano part in Beethoven?s Ninth Symphony. In 2005 at the Great Hall of the Moscow Conservatoire she performed the role of the Mermaid in the opera of the same name by Dvorak.
Has worked with conductors including Gergiev, Bertini, Glinka, Bashmet, Walander, Kantorov and Sokhiev.

© State Academic Mariinkiy Opera and Ballet theatre