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 (-1)) 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





	The Saint-Petersburg State Leonid Yacobson Ballet Theatre (Ballet company) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters The Saint-Petersburg State Leonid Yacobson Ballet Theatre (Ballet company)

The Saint-Petersburg State Leonid Yacobson Ballet Theatre (Ballet company)

The Saint-Petersburg State Leonid Yacobson Ballet Theatre is a one-of-a-kind ballet company, and the only theatre in the world to have a repertoire that celebrates the diverse heritage of Leonid Yacobson, a remarkably talented choreographer of the twentieth century.

It was Leonid Yacobson who brought the company together, and to this day, many of his unique ballet productions can only be seen here, at this theatre. The ballet master's choreography is passed on to every new generation of dancers with all of its nuances completely preserved, and every facet of his original artistic concepts gets fully developed — for the theatre's teachers and tutors once had the honour of performing under Yacobson's guidance at the dawn of his ballet company.

Since 2011, the theatre's activity has been managed by art director Andrian Fadeev, Honoured Artist of the Russian Federation, who builds upon the heritage of the Russian ballet's traditions. He believes that his main tasks are to ensure that Leonid Yacobson's best-known choreographic works are carefully preserved in the theatre's repertoire; to revive the master's less renowned creations; to continue sustaining and honing the traditions of classical ballet; and to expand the theatre's repertoire, covering diverse areas of classical and modern choreography.

Today, the theatre is proud to present a large number of Leonid Yacobson's choreographic masterpieces, including Rodin; The Bedbug; The Wedding Cortиge; Spartacus; various lyrical miniatures and genre scenes; world-famous classical ballets, such as Giselle, Swan Lake, and The Nutcracker; and modern choreography shows.

The theatre's dancers perform at the city's top venues, take part in international festivals, and often share the stage with world-class ballet stars. The company has been honoured with the Golden Mask National Theatre Award and the Golden Soffit Saint-Petersburg Theatre Award.

Productions by the Leonid Yacobson Ballet Theatre are familiar to audiences from nations around the globe, including Japan, the USA, Mexico, Italy, Spain, and Croatia.