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 (479553,481119,481867,482606,483340,484078,484829,485574,486312,487036,487751,488466,489179,489888,490590,491289,520803,522239,638533,640072,641602,643124,644637,646143,647637,649128,650625,652103,653579,655045,656500,657952,659400,660837,662264,663690,665104,666509,667944,669364,670803,672227,673644,675055,676450,677836,679242,680636,682023,683396,684763,910588,913200,915830,918534,921227,923906,926597,929314,932020,934728,937433,940164,942882,945588,948290,950996,953696,956386,959062,961717,964357,966993,969625,972253,974872,977484,980091,982682,985270,987894,987928,990513,990547,993123,993160,995734,995769,998329,998364,1000913,1000948,1003494,1003529,1003655,1006069,1006102,1006227,1008635,1008669,1008794,1011194,1011228,1011353,1013773,1013808,1013934,1016371,1016498,1018920,1019047,1021467,1021594,1024012,1024139,1024140,1024216,1024217,1026546,1026674,1026675,1026751,1026752,1029076,1029204,1029205,1029281,1029282,1031601,1031730,1031731,1031808,1031809,1034104,1034233,1034234,1034311,1034312,1036723,1036724,1036799,1036800,1039212,1039214,1039288,1039289,1041697,1041698,1041771,1041772,1044173,1044174,1044247,1044248,1046640,1046641,1046714,1046715,1049097,1049098,1049171,1049173,1051541,1051542,1051615,1051617,1053971,1053972,1054044,1054046,1056398,1056399,1056471,1056473,1058820,1058821,1058893,1058895,1061229,1061230,1061303,1061304,1063630,1063631,1063704,1063705,1066024,1066026,1066098,1066099,1068407,1068408,1068480,1068481,1070775,1070776,1070850,1070851,1073175,1073176,1073250,1073251,1075568,1075569,1075643,1075644,1077951,1077952,1078026,1078028,1080322,1080323,1080398,1080399,1082682,1082683,1082758,1082759,1085026,1085027,1085103,1085104,1087355,1087356,1087432,1087433,1089674,1089675,1089751,1089753,1092004,1092005,1092081,1092084,1094326,1094327,1094403,1094406,1096636,1096637,1096713,1096717,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,3314882,3316890,3318894,3320881,3322864,3325015,3327284,3329669,3332048,3334415,3336767,3339115,3341461,3343798,3346152,3348509,3350846,3353168,3355483,3357815,3360158,3362521,3364877,3367219,3369548,3371873,3374188,3376501,3378807,3381107,3383376,3385658,3387929,3390188,3390198,3392437,3392447,3394672,3394682,3396899,3396902,3399112,3399118,3401311,3401319,3403502,3403510,3405686,3405695,3407854,3407863,3410020,3410022,3412160,3412171,3414330,3414339,3416486,3418625,3953321,3953935,3954555,3955159,3955767,3956366,3956406,3957032,3957647,3958265,3958884,3959490,3960094,3960697,3961297,3961891,4051530,4052407,4053282,4054157,4055025,4055888,4056754,4057613,4058467,4059318,4060165,4061012,4061852,4062687,4125942,4126628,4127313,4127994,4128672,4129345,4130018,4130688,4131348)) 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





	Marina Mareskina (Mezzo soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Marina Mareskina (Mezzo soprano)

Marina Mareskina (Mezzo soprano)

Mezzo-soprano

• Prize-winner at the II Karamanov Contemporary Arts and Education international competition and festival in two categories – “vocals” (Moscow, 2006, 1st prize) and “chamber ensemble” (3rd prize) 
• Prize-winner at the II International Pechkovsky Opera Singers’ Competition (St Petersburg, 1996, 3rd prize)

Marina Mareskina was born in Ulan-Ude. In 1996 she graduated from the St Petersburg State Rimsky-Korsakov Conservatoire (class of I. I. Yushmanov). 
In 1996 she made her debut at the Mariinsky Theatre as the Little Brigand in Banevich’s opera The Story of Kai and Gerda
Since 2014 she has been a guest soloist with the Mariinsky Opera.

Roles performed at the Mariinsky Theatre include: 
The Governess (The Queen of Spades
A Woman (Boris Godunov
Nenila, Masha (The Enchantress
Filippievna (Eugene Onegin
Zakharievna (The Oprichnik
The Nurse (Prince Igor
Third Woman (Semyon Kotko
Dunyasha (War and Peace
Maria Kondratievna (The Brothers Karamazov
Little Brigand (The Story of Kai and Gerda
The Music Teacher (Lolita, concert performance) 
and Second Page, Heavenly Voice (Parsifal).

The singer’s repertoire also includes: Naina (Ruslan and Lyudmila), Konchakovna (Prince Igor), Polina (The Queen of Spades), Lyubyasha, Dunyasha (The Tsar’s Bride), Olga (Eugene Onegin), Marta (Iolanta), Stesha, Perfilievna, Vlasievna (The Maid of Pskov), Bobylikha (The Snow Maiden), Wet-Nurse, Mistress of the Inn (Boris Godunov), Ines (Il trovatore), Khivrya (Semyon Kotko), Anna (Les Troyens), Amneris (Aida), Deaconess (Król Roger) and the Old Gypsy (Aleko) as well as the mezzo-soprano roles in Prokofiev’s cantata Alexander Nevsky, Pergolesi’s Stabat Mater and Verdi’s Requiem. 
Marina Mareskina has toured with the Mariinsky Opera to prestigious venues in Spain, Germany, Italy, Great Britain, the USA (Metropolitan Opera), Japan, Belgium, France, Israel, Finland, China, South Korea, Turkey, Portugal, Argentina and Switzerland. 
The singer frequently performs chamber music programmes in St Petersburg and throughout Germany.