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 (14708,16160,17770,19173,20617,22100,23554,26734,27611,29072,30965,212288,213824,215360,216891,218420,219943,221461,222974,224483,225993,227498,228997,230982,232977,234967,236952,238926,240892,242853,244811,246771,248716,250660,252643,254617,256581,258542,260508,262468,264435,266395,268347,270288,272227,274160,276094,278019,279895,281761,283619,285476,287331,289180,291015,292911,294800,3029392,3029430,3030819,3030855,3032231,3032270,3033641,3033679,3035233,3035271,3036811,3036849,3038417,3039977,3041527,3043075,3044613,3046140,3047657)) 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





	Yury Alexeyev (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Yury Alexeyev (Tenor)

Yury Alexeyev (Tenor)

Prize winner at the All-Russian Vocal Competition (Belgorod, 1991).

Graduated from the Rostov Conservatoire in 1991 (class of Professor B. Mazur). Voronezh Opera and Ballet Theatre soloist since 1991, where his repertoire included Alfredo Germont (La traviata), Lensky (Eugene Onegin), Young Gypsy (Aleko) and Turiddu (Cavalleria rusticana).

Prize winner at the All-Russian Vocal Competition (Belgorod, 1991).

Graduated from the Rostov Conservatoire in 1991 (class of Professor B. Mazur). Voronezh Opera and Ballet Theatre soloist since 1991, where his repertoire included Alfredo Germont (La traviata), Lensky (Eugene Onegin), Young Gypsy (Aleko) and Turiddu (Cavalleria rusticana).

Joined the Mariinsky Theatre in 1996.
Repertoire includes:
Alfredo Germont (La traviata),
Lensky (Eugene Onegin),
Vladimir (Prince Igor),
Pinkerton (Madama Butterfly),
Radames (Aida),
Don Carlos (Don Carlos),
Antonio (Betrothal in a Monastery),
Melot (Tristan und Isolde),
Requiem by Verdi, Requiem by Mozart and Messa by Schubert.

Has toured with the Mariinsky Opera to Finland, the USA, Japan, Portugal, Luxembourg, Spain and China.Took part in the Exford Music Festival (Ireland) and the Pirolada Music Festival (Spain).

At the Mariinsky Theatre he also performs the role of Canio in Leoncavallo?s I pagliacci.

© State Academic Mariinkiy Opera and Ballet theatre