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 (1911092,1913236,1915394,1917606,1919806,1922003,1924195,1926443,1928683,1930912,1933130,1935329,1937525,1939714,1941893,1944064,1946224,1948371)) 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





	Artem Golubev (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Artem Golubev (Tenor)

Artem Golubev (Tenor)

Artyom Golubev graduated from the Omsk State Dostoevsky University as a vocal singer in 2010. He participated in masterclasses held by Dmitry Vdovin (Bolshoi Theatre), Sergey Murzaev (Vishnevskaya Opera Centre), and Paata Burchuladze (Omsk Philharmonic Society) among others.

In 2001–2010, he was a soloist of the Omsk Philharmonic Society. In 2010, he was a soloist of the Novosibirsk Opera and Ballet Theatre. In 2011, he was a soloist of the Chelyabinsk Opera and Ballet Theatre. In 2012, he was a soloist of the Ekaterinburg Opera and Ballet Theatre. In 2013, he was invited to join the New Opera Company in Moscow. Since 2015, he was a soloist of the Bashkir Opera and Ballet Theatre. Nowadays, he is a guest soloist of the Perm Opera and Ballet Theatre and Tatar Opera and Ballet Theatre.

He has toured to Germany, Spain, Thailand, and USA. He collaborates with Fabio Mastrangelo, Michael Guettler, Teodor Currentzis, Thomas Sanderling, Marco Boemi, and other conductors. He was a soloist of the project Tenors of the 21st century (Moscow). In 2015, he made his debut with the Bolshoi Opera Company as Faust in Gounod’s opera under the baton of Andrey Anikhanov. Artyom Golubev appears in many festivals and concerts in Russia and abroad.