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 (1915732,1917944,1920145,1922343,1924532,1926780,1929022,1931251,1933465,1935664,1937860,1940049,1942228,1944399,1946560,1948708,1950843,1952974,1955102,1957178,1959242,1961290,1963328,1965356,1967377,1969395,1971407,1973417,1975414,1977400,1979371,1981369,1983361,1985346,1987324,1989294,1991252,1993188,1995129,1997057,1998976,2000890,2002793,2004684,2006559,2008446,2010331,2012207,2014070,2015910,2017736,2019547,2021354,2023155,2024948,2026941,2028931,2030910,2032874,2034834,2036788,2038737,2040675,2042601,2044509,2046409,2048296,2050181,2052053,2053916,2055867,2057906,2059939,2061966,2063986,2065996,2067998,2070004,2071995,2073974,2075946,2077910,2079908,2081899)) 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





	Viktor Chernomortsev (Baritone) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Viktor Chernomortsev (Baritone)

Viktor Chernomortsev (Baritone)

Baritone

•Honoured Artist of Russia (1981).
•Recipient of the Golden Mask, Russia?s highest theatre prize, for his interpretation of Alberich in Wagner?s Das Rheingold (2001).
•Recipient of the Golden Sophit, St Petersburg?s highest theatre prize (2000).
• Laureate of BALTIKA prize (2000).

Graduated from the Moscow State Tchaikovsky Conservatoire (class of Professor V. G. Shushlin) and joined the Saratov Opera and Ballet Theatre in 1973.
Soloist with the Kuibyshev Opera and Ballet Theatre from 1974.
Soloist with the Wiener Staatsoper from 1992.
First performed at the Mariinsky Theatre as Scarpia in the 1994 premiere of Tosca, and he joined the company in 1995.

Repertoire at the Mariinsky Theatre includes:
Shaklovity (Khovanshchina),
Prince Igor (Prince Igor),
Apparition (Sadko),
Grigory Gryaznoi (The Tsar?s Bride),
Mazepa (Mazepa),
Prince Nikita (The Enchantress),
Tomsky and Zlatogor (The Queen of Spades),
Robert (Iolanta),
the Emperor of China (The Nightingale),
Tsarev (Semyon Kotko), Matveev (War and Peace),
Giorgio Germont (La traviata),
Renato (Un ballo in maschera),
Marquis of Posa (Don Carlo),
Amonasro (Aida),
Telramund (Lohengrin),
Alberich (Das Rheingold, Gotterdammerung),
Amfortas (Parsifal),
Jokanaan (Salome),
Michele (Il tabarro).

Repertoire also includes: Alfio (Cavalleria rusticana), Rigoletto (Rigoletto), Di Luna (Il trovatore), Nabucco (Nabucco), Scarpia (Tosca), Gasparo (Rita, ou mari battu), Dikoj (Katya Kabanova).

Has toured with the Mariinsky Theatre throughout Europe, Israel, the USA and Japan.

Died at the age of 66 on 4 November 2014.