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 (8426,10130,11713,13296,14650,16103,34196,35581,35629,37122,37172,38674,38723,38728,40171,40175,153413,155144,156865,158576,160302,162029,163761,165503,167234,168955,170667,172371,174065,175749,177421,179089,180743,182390,184030,185661,187283,188895,190495,192084,193662,196421,197728,199045,200362,202044,203721,205390,457358,458924,460480,462027,463579,465127,466669,468366,478041,479611,485605,485614,486344,486349,487067,487073,487782,487788,488493,488500,489207,489213,489915,489922,490617,490624,491316,491323,492009,492010,492687,492694,493368,493376,494046,494054,494718,494726,495383,495391,496039,496044,496686,497338,497492,498802,498955,500258,500413,501712,501864,503358,504838,506310,507782,509251,510714,512170,513615,515090,516553,518007,519451,520893,522330,523760,525178,526587,527991,529395,530795,532189,533574,535007,536433,537862,539286,540701,542135,543576,545046,546505,547961,549412,549418,549476,549540,550864,550919,550986,552300,552357,552421,553780,553845,555196,555261,556603,556668,558006,558068,559402,559465,560795,560857,562182,562244,563563,563626,564933,564995,566298,566357,567657,567716,569007,569070,570418,571758,573135,574507,575869,577227,578579,579920,581253,582578,583901,585215,902544,902545,902606,902607,905170,905171,905233,905235,907850,907851,910464,910466,913077,913078,915708,915709,918412,918413,921105,921106,923784,923785,926475,926476,929192,929193,931900,931901,934608,934609,937313,937314,940044,940045,2104983,2106934,2108873,2110802,2196831,2196850,2198358,2198373,2199874,2199889,2201395,2201416,2202935,2202954,2204485,2206005,2207533,2698049,2701123,2704205,2707277,2710315,2713348,2716372,2719437,2722511,2725610,2728699,2731785,2734895,2737986,2741068,2744140,2747191,2750221,2753248,2756272,2759285,2762300,2765309,2768299,2771273,2774243,2777202,2780186,2783211,2955315,2957801,2960276,2962738,2965176,2967596,2970013,2972422,2974815,2977196,2979561,2981941,2984312,2986677,2989057,2991429,2993797,2996152,2998490,3000810,3003128,3005425,3007658,3009851,3012030,3014188,3016333,3018472,3020666,3056799,3058257,3059705,3061144,3062884,3064616,3066336,3068046,3069744,3071432,3073113,3074783,3076440,3078092,3079755,3081401,3083043,3084670,3086321,3087965,3089597,3091222,3092831,3094431,3096023,3097608,3099185,3100757,3102315,3103858,3122331,3124028,3357746,3360091,3362452,3364807,3367146,3369477,3371802,3374119,3376431,3378738,3381035,3383304,3536271,3538302,3540326,3542395,3544450,3546492,3548531,3550563,3552601,3554636,3556675,3558701,3560713,3562715,3564716,3566734,3918941,3918943,3919631,3919634,3920319,3920321,3920997,3921000,3921675,3921679,3922351,3922352,3923028,3923031,3923707,3923709,3924381,3924382)) 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





	Stanislav Kochanovsky (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Stanislav Kochanovsky (Conductor)

Stanislav Kochanovsky (Conductor)

Stanislav Kochanovsky was born in St Petersburg in 1981. He studied at the Glinka Choral School and later at the St Petersburg State Rimsky-Korsakov Conservatoire, graduating with distinction in three fields – choral conducting (class of Professor Tatiana Khitrova, 2004), organ (class of Professor Nina Oksentyan, 2004) and opera and symphony conducting (class of Professor Alexander Titov, 2008). After graduating from the Conservatoire he was awarded a special diploma as “Best Graduate of a St Petersburg Higher Education Institution in 2004.”
Prize-winner at the All-Russian Choral Conductors’ Competition in Salavat (2002) and the I All-Russian Conductors’ Competition in Moscow  (2011).

In 2005, Stanislav Kochanovsky made his debut with the St Petersburg State Conservatoire Orchestra, conducting the opera Iolanta. From 2007-2010 he was a conductor at the Mikhailovsky Theatre with which he toured to the English National Opera (London) and the Teatro la Fenice (Venice).

As a guest conductor, he has worked on productions at the Mariinsky Theatre, the Novaya Opera Theatre (Moscow), the St Petersburg Chamber Opera, the St Petersburg State Theatre of Musical Comedy) and the Flemish Opera (Belgium). The conductor’s repertoire includes over thirty operas and ballets.

As a symphony conductor, Stanislav Kochanovsky works with major Russian ensembles, among them the Svetlanov State Academic Symphony Orchestra of Russia, the National Philharmonic Orchestra of Russia, the Moscow and St Petersburg Philharmonic Orchestras, the St Petersburg State Academic Capella, the State Hermitage Orchestra and the Volgograd Academic Symphony Orchestra. He has also conducted the Finnish Radio Symphony Orchestra, the Haydn Orchestra of Bolzano and Trento (Italy), the Arturo Toscanini Philharmonic Orchestra (Italy), the Maggio Musicale Fiorentino Symphony Orchestra (Italy), the Frankfurt Radio Symphony Orchestra (Germany), the Silesian Philharmonic Orchestra (Poland), the Lithuanian State Symphony Orchestra and the Tallinn Chamber Orchestra (Estonia).

Since 2006 Stanislav Kochanovsky has collaborated with the St Petersburg House of Music. In 2010 and 2012 he took part in Yuri Temirkanov’s Step Towards! festival.
Since 2012 he has regularly helped prepare programmes of symphony music for Vladimir Jurowski and the Svetlanov State Academic Symphony Orchestra of Russia in Moscow.

Since the 2010–2011 season Stanislav Kochanovsky has been Principal Conductor of the Academic Symphony Orchestra of the State Philharmonic in Mineralnye Vody, with which he made his debut at the Tchaikovsky Concert Hall in Moscow and the Saydashev Concert Hall in Kazan in 2011.