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 (20068,21555,23009,24461,25945,26385,27818,30406,31903,33408,34882,38157,38162,39624,39629,41015,41019,42426,42430,43811,43815,45168,45172,46517,46521,47860,47864,49197,49201,50529,50533,51853,51857,53170,53174,54487,55794,1072124,1074525,1076912,1079288,1081649,1084001,1086339,1088664,1091000,1093324,1095642,1097942,1100221,1102493,1104751,1106988,1109203,1111398,1113575,1115738,1117879,1120013,1122145,1124283,1126478,1128689,1130903,1133099,1135291,1137499,1139698,1141894,1144076,1146256,1148420,1150575,1152726,1154868,1157011,1159177,1161332,1163473,1165604,1167742,1169870,1171991,1174109,1176255,1178390,1180518,1182637,1184747,1186853,1188960,1191059,1193147,1195225,1197301,1199372,1201433,1203483,1205536,1207573,1209602,1211637,1213672,1215694,1217703,1219697,1221680,1223656,1225627,1227620,1229634,1231644,1233640,1235628,1237608,1239576,1424058,1425747,1427421,1429085,1430735,1432375,1434006,1435622,1437227,1438848,1440456,1442058,1443652,1445236,1446809,1448373,1449925,1451465,1452995,1454515,1456035,1457537,1459029,1460508,1461974,1463430,1464876,1466308,1467730,1469139,1470533,1471914,1473282,1474641,1475987,1477338,1478686,1480070,1481442,1482803,1484159,1485503,1486838,1488162,1489468,1490763,1492049,1493363,1494668,1495965,1497260,1498563,1499856,1501139,1502415,1503683,1504944,1506197,1507444,1508681,1509909,1511131,1512356,1513584,1514805,1516028,1517243,1518449,1519648,1520844,1522034,1523217,1524392,1525560,1526721,1527876,1529025,1530170,1531311,1532448,1533580,1534708,1535832,1536951,1538064,1539201,1540331,1541456,1542575,1543686,1544791,1545889,1546974,1548047,1549110,1550166,1551214,1552253,1553294,1553579,1554329,1554614,1555356,1555641,1556374,1556659,1557384,1557669,1558392,1558677,1559390,1559675,1561033,1562382,1564225,1566058,1567878,1570803,1573695,1576578,1579448,1582312,1585159,1587994,1590832,1593657,1596514,1599385,1602241,1605093,1607930,1610764,1613589,1616410,1619215,1622004,1624781,1627550,1630304,1633051,1635854,1638683,1641524,1644348,1647161,1649977,1652846,1655706,1658554,1661391,1664214,1667026,1669833,1672692,1675544,1678387,1681224,1684051,1686872,1689725,1692581,1695348,1698108,1700861,1703605,1706343,1709114,1711876,1714660,1717435,1720197,1722944,1725685,1728420,1731146,1733854,2908403,2911020,2913618,2916206,2918796,2921369,2923934,2926488,2929024,2931543,2934052,2936552,2939060,2941563,2944057,2946535,2948997,2951444,2953891,2953898,2956380,2956387,2958859,2958866,2961328,2961335,2963777,2963784,2966208,2966215,2968626,2968633,2971042,2971049,2973442,2973449,2975831,2975838,2978208,2978215,2980598,2980605,2982974,2982981,2985343,2985350,2987727,2987734,2990105,2990112,2992481,2992488,2994844,2994851,2997194,2997201,2999528,2999535,3001851,3001858,3004166,3004173,3006456,3006463,3008682,3008689,3010870,3010877,3013038,3013045,3015190,3015197,3017334,3017341,3019522,3019529,3021598,3021604,3023075,3023081,3024544,3024550,3026000,3026006,3027446,3027452,3028884,3028890,3030316,3030322,3031738,3031744,3033150,3033156,3034748,3034754,3036334,3036340,3037909,3037915,3039476,3039482,3041035,3041041,3042585,3042591,3044127,3044133,3045662,3045668,3047185,3047191,3048697,3048703,3050202,3050208,3051710,3051716,3053208,3053214,3054693,3054699,3056169,3056175,3057634,3057640,3059087,3059093,3060532,3060538,3061969,3061975,3063704,3063710,3065430,3065436,3067145,3067151,3068847,3068853,3070540,3070546,3072224,3072230,3073899,3073905,3075564,3075570,3077222,3077228,3078883,3078889,3080535,3080541,3082178,3082184,3083810,3083816,3085432,3085438,3087080,3087086,3088719,3088725,3090347,3090353,3091963,3091969,3093569,3093575,3095167,3095173,3096757,3096763,3098338,3098344,3099915,3099921,3101481,3101487,3103032,3103038,3104574,3104580,3106108,3106114,3107663,3114170,3114181,3115694,3115708,3117212,3117226,3118720,3118734,3120230,3120244,3121732,3121746,3123335,3123351,3125027,3125043,3126707,3126723,3128377,3128393,3130036,3130052,3131688,3131704,3133332,3133348,3134968,3134984,3136105,3136604,3136620,3137738,3138229,3138245,3139359,3139845,3139861,3140971,3141454,3141470,3142575,3143054,3143070,3144169,3144648,3144664,3145759,3146233,3146249,3147339,3147975,3148605,3149229,3149853,3150310,3150326,3151400,3151854,3151870,3152939,3153391,3153407,3154472,3154919,3154935,3155995,3156439,3156455,3157511,3157951,3157967,3159018,3159451,3159467,3160512,3160940,3160956,3161997,3162422,3162438,3163474,3163898,3163914,3164946,3165365,3165381,3166423,3166847,3166863,3167785,3167830,3168244,3168260,3169179,3169224,3169631,3169647,3170564,3170609,3171011,3171027,3171941,3171986,3172385,3172401,3173312,3173357,3173753,3173769,3174676,3174721,3175113,3175129,3176078,3176123,3176514,3176530,3177476,3177521,3177910,3177926,3178865,3178910,3179384,3179400,3180337,3180382,3180854,3180870,3181805,3181850,3182321,3182337,3183271,3183316,3183782,3183798,3184734,3184779,3185245,3185261,3186195,3186240,3186703,3186719,3187652,3187697,3188157,3188173,3189103,3189148,3189604,3189620,3190548,3190592,3191047,3191063,3191991,3192035,3192486,3192502,3193427,3193468,3194179,3194195,3195118,3195159,3195866,3195882,3196902,3196944,3197649,3197665,3198878,3198920,3199619,3199635,3200846,3200890,3201320,3201336,3202542,3202586,3203014,3203030,3204237,3204278,3204706,3204722,3205927,3205970,3206395,3206411,3207614,3207656,3208077,3208093,3209294,3209337,3209755,3209768,3210967,3211010,3211425,3211438,3212686,3212730,3213134,3213147,3214388,3214433,3214830,3214846,3216084,3216128,3216524,3216540,3217778,3217820,3218215,3218231,3219466,3219510,3219899,3219915,3221145,3221190,3221574,3221590,3222812,3222855,3223246,3223262,3224477,3224520,3224881,3224897,3226105,3226151,3226503,3226519,3227724,3227765,3228117,3228133,3229338,3229382,3229734,3229750,3230963,3231006,3231351,3231367,3232579,3232621,3232964,3232980,3234186,3234231,3234566,3234582,3235785,3235829,3236153,3236169,3237369,3237414,3237728,3237744,3238939,3238984,3239297,3239313,3240506,3240551,3240860,3240876,3242110,3242154,3242458,3242474,3243703,3243747,3244060,3245287,3245327,3245636,3246887,3246929,3248473,3248515,3250042,3250087,3251607,3251651,3253170,3253211,3254769,3254809,3256779,3256821,3258788,3258833,3260785,3260829,3262769,3262811,3264751,3264791,3266727,3266770,3268711,3268755,3270762,3270802,3272889,3272929,3274999,3275041,3277090,3277133,3279178,3279224,3281315,3281356,3283440,3283486,3285560,3285606,3287708,3287755,3289841,3289889,3291960,3292006,3294063,3294110,3296209,3298304,3300387,3302462,3304525,3306576,3308622,3310663,3312697,3314714,3316725,3318727,3320714,3322699)) 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





	Elena Popovskaya (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Elena Popovskaya (Soprano)

Elena Popovskaya (Soprano)

Elena Popovskaya (soprano) studied music theory, composition and singing (Margarita Landa’s class) at the Gnessins Musical College. In 1997, the singer graduated from the Moscow State Conservatory (Professor Kadinskaya’s class).
She joined the Novaya Opera Theatre in 1998. Elena made her debut at the Bolshoi as Lisa in a new production of Tchaikovsky’s The Queen of Spades in 2007 (music director and conductor Mikhail Pletnev).
Elena Popovskaya extensively tours abroad - in the Netherlands, France, Germany, Israel and other countries. She appeared as Renata in Prokofiev’s Fiery Angel at Theatre Royal de la Monnaie (Brussels, 2006; conductor Kazushi Ono, stage director Richard Jones) and as Lisa in Tchaikovsky’s The Queen of Spades at the Latvian National Opera (Riga, 2007). In 2008, Elena Popovskaya was the first Russian soprano to perform Turandot at Puccini’s Festival in Torre del Lago in Italy. Her repertoire also comprises the following parts: Maria in Tchaikovsky’s Mazepa, Tosca in Puccini’s Tosca, and the soprano part in Shostakovich’s Symphony 14.
In 2010, Elena Popovskaya sang the title role in Strauss’s Elektra (conducted by Gustav Kuhn), Manon in Puccini’s Manon Lescaut at Luciano Pavarotti Teatro di Modena. This summer the singer will perform the title role in Franco Zeffirelli’s new production of Puccini’s Turandot at Arena di Verona, conducted by Placido Domingo
.

Roles performed:

  • Gorislava in Glinka’s Ruslan and Lyudmila
  • Kupava in Rimsky-Korsakov's The Snow Maiden
  • Yaroslavna in Borodin's Prince Igor (in concert)
  • Dido in Purcell’s Dido and Aeneas
  • Elisabeth in Donizetti’s Maria Stuarda
  • Gertrude in Thomas’s Hamlet
  • Abigaille in Verdi's Nabucco
  • Santuzza in Mascagni’s Cavalleria Rusticana
  • Ortrud in Wagner's Lohengrin
  • soprano parts in the productions “O Mozart! Mozart…”, “Rossini”, “Richard Wagner”, “Maria Callas”, “Bravissimo!”, and “Viva Verdi!”

Awards and Honours:

  • Diploma-winner of the XLI International Competition for Opera Singers (Toulouse, 1996)