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 (1478452,1478457,1479836,1479841,1481208,1481213,1482569,1482574,1483925,1483930,1485269,1485274,1486604,1486609,1487933)) 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 Bukharaev (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Stanislav Bukharaev (Dancer)

Stanislav Bukharaev (Dancer)

Graduated from the Bashkir Rudolf Nureyev Choreographic College in 1995. In 2003 he graduated from the Russian Academy of Theatre Arts (GITIS).

Since 2001 he has been the soloist of the K.S. Stanislavsky and Vl.I. Nemirovich-Danchenko Moscow Academic Music Theatre. In the repertoire: Prince Siegfried, Rothbart ("Swan Lake" by P. Tchaikovsky, choreography by Vl. Burmeister), Nutcracker-Prince, Mr. Stahlbaum ("The Nutcracker" by P. Tchaikovsky, choreography by V. Vainonen), Albert, Hans, Duke ( "Giselle" by A. Adam), Arman ("Lady of the Camellias" by Dm . Bryantsev to the music by G. Verdi - P. Korchagin), Mizgir, Berendey ("The Snow Maiden" by Vl. Burmeister to the music by P. Tchaikovsky), Phoebus ("La Esmeralda" by C. Pugni, R. Gliere, S. Vasilenko, choreography by Vl. Burmeister), Espada ("Don Quixote" by L. Minkus, choreography by A. Chichinadze) Dugmanta ("La Bayadere" by L. Minkus, choreography by N. Makarova), Mr. GM ("Manon" by K. McMillan to the music by J. Massenet), Prince N. ("Tatiana" by L. Auerbach, choreography by J. Neumeier), the solo parts in "Petite mort" and "Sechs Tänze" by Jiří Kylián.

Participated in tours of the "Moscow City Ballet" and the Stanislavsky and Nemirovich-Danchenko Music Theatre.

Previous work experience

  • Bashkirian Opera and Ballet Theatre (1992 — 1996)
  • Tatar Opera and Ballet Theatre (1996 — 1997)
  • Moscow City Ballet (1997 — 2001)
  • Stanislavsky and Nemirovich-Danchenko Moscow Academic Music Theatre (since 2001)

Education

  • Bashkir Institute of Choreography (Ufa) (till 1995)
  • Russian Academy of Theatre (RATI-GITIS) (1998 — 2003)