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 (-1)) 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





	Konstantin Pluzhnikov (Director) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Konstantin Pluzhnikov (Director)

Konstantin Pluzhnikov (Director)

Awards include:
1968 - Glinka All-Russia Vocal Competition III prizewinner;
1970 - International Enesku Competition in Bucharest (1 prize);
1983 - People‘s Artist of Russia;
1972 - International Competition in Geneva I prizewinner.

Born in Georgia. Graduated from the St. Petersburg Conservatory (vocal class under professor E.Olhovski) in 1970.
1968-1971 - Principal singer of Maly Opera and Ballet Theatre, St Petersburg.
1971 - joined Kirov Opera Company.
1998 - Appointed Director of the newly founded Academy of Young Singers of the Mariinsky Theatre.

His repertoire includes: Afanasy Ivanovich (Sorochinsky Fair), Edgar (Lucia di Lammermoor), Don Carlos (Don Carlos), Mephistopheles (The Fiery Angel), Count Almavira (Il Barbiere di Siviglia), Faust (Faust), Lohengrin (Lohengrin), Vladimir Igorevich (Prince Igor), Shuisky (Boris Godunov), Scrivener, Golitsyn (Khovanshchina), Kashchei (Kashchei the Immortal), Grishka Kutierma (The Legend of the Invisible City of Kitezh), Fisherman (The Nightengale), Finn, Bayan (Ruslan and Ludmila), Herodes (Salome), Don Gerome (Betrothal in a Monastery), Loge (Das Rheingold).
He also has a vast chamber music repertoire.
Has performed abroad and toured with the company: Italy, Germany, Spain, Scotland (Edinburgh Festival), Finland, Israel, USA (Metropolitan Opera), Austria, Holland, Japan, etc.
Konstantin Pluzhnikov is frequently invited as a guest soloist at major American and European Opera houses, such as the Metropolitan Opera House, San Francisco Opera, La Scala, La Fenice, La Bastille among others.

Recordings:

1992 with Philips Classics and NHK - audio and video - Khovanshchina (Scrivener and Golitsyn)
1993 with Philips Classics - audio and video - The Fiery Angel - (Mephistoheles)
1993 with Philips Classics - audio - Prince Igor - (Yeroshka)
1995 - with Philips Classics and RM Arts - Ruslan and Liudmila (Finn)
1997 - with Philips Classics - audio - Boris Godunov
Furthermore he has recorded more than ten discs, featuring romances by Russian composers.


© State Academic Mariinkiy Opera and Ballet theatre