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 (3002648,3004944,3007176,3009363,3011544,3256886,3258892,3260890,3262874,3264853,3266833,3268816,3270865,3272993,3275105,3277196,3279285,3281421,3283547,3285667,3287817,3289950,3292068,3294172,3296273,3298365,3300453,3302526,3304588,3306638,3308684,3310724,3312762,3314779,3316791,3318789,3320780,3322765,3324913,3327177,3329570,3331946,3334312,3336669,3339018,3341356,3343696,3346052,3348407,3350744,3353063,3355384,3357711,3360061,3362418,3364775,3367114,3827417,3827757,3828097,3828425,3828753,3829077,3829400,3829720,3830035,3830342,3830645,3869476,3870243,3871006,3871767,3872499,3873253,3874009,3874761,3875511,3876260,3877005,3877750,3878493,3879234,3879976,3880718,3881463,3882206,3882948,3883689,3884428,3885167,3885904,3886639,3887373,3888106,3888836,3889566,3890292,3891016,3891735,3892453,3893168,3893885,3894605,3895323,3896036,3896744,3897451,3898156,3898858,3899558,3900259,3900978,3901692,3902405,3903117,3903825,3904528,3905229,3905927,3906620,3907312,3908000,3908689,3909372,3910051,3910742,3911428)) 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





	Pavel Teplov (Principal Chorus Master) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Pavel Teplov (Principal Chorus Master)

Pavel Teplov (Principal Chorus Master)

Born in St Petersburg. Graduated from the Glinka Choral School in 2005 and from the St Petersburg State Rimsky-Korsakov Conservatoire (conducting faculty) in 2010.
Since 2007 he has been a soloist with the Mariinsky Academy of Young Singers.
In 2009 he became Chorus Master of the Mariinsky Academy of Young Singers and has been involved in the theatre’s productions of operas including Nikolai Rimsky-Korsakov’s May Night and Christmas Eve (2009) and Antonin Dvorak’s Rusalka (2009) as well as a consert perfomance of Jules Massenet’s opera Don Quichotte featuring Ferruccio Furlanetto (2010).