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 (1408775,1410512,1412239,1414008,1415768,1417516,1419253,1420980,1422697,1424400,1426089,1427763,1429427,1431077,1432717,1434344,1435960,1437595,1439216,1440824,1442426,1444021,1445605,1447178,1448743,1450295,1451835,1453366,1454886,1456398,1457903,1459397,1460876,1462342,1463798,1465244,1466676,1468098,1469507,1470901,1472282,1473650,1475009,1476355,1477706,1479083,1480467,1481839,1483201,1484557,1485901,1487236,1488560,1489866,1491161,1492447,1493761,1495066,1496363,1497661,1498964,1500257,1501540,1502816,1504084,1505346,1506599,1507846,1509083,1510311,1511544,1512769,1513998,1515229,1516452,1517667,1518873,1520076,1521272,1522462,1523644,1524819,1525987,1527148,1528303,1529452,1530597,1531738,1532874,1534006,1535134,1536258,1537377,1538521,1539658,1540789,1541914,1543033,1544144,1545249,1546346,1547431,1548504,1549567,1550621,1551669,1552718,1553763,1554801,1555828,1556846,1557858,1558866,1559866,1561224,1562673,1564516,1566349,1568471,1571383,1574276,1577157,1580031,1582891,1585738,1588577,1591411,1594236,1597115,1599986,1602846,1605694,1608534,1611372,1614197,1617011,1619816,1622606,1625382,1628151,1630912,1633659,1636460,1639313,1642154,1644984,1647800,1650612,1653480,1656337,1659186,1662023,1664846,1667660,1670465,1673324,1676176,1679025,1681863,1684689,1687550,1690415,1693206,1695973,1698734,1701487,1704231,1707008,1709779,1712539,1715323,1718098,1720860,1723608,1726350,1729085,1731801,1734509,1737208,1739896,1742570,1745234,1747892,1750541,1753184,1755817,1758443,1761054,1763657,1766252,1768845,1771430,1774006,1776580,1779139,1781688,1784230,1786762,1789267,1791761,1794237,1796694,1799170,1801629,1804073,1806498,1808910,1811301,1813662,1816011,1818343,1820652,1822933,1825189,1827422,1829634,1831826,1834012,1836207,1838396,1840576,1842738,1844883,1847035,1849189,1851338,1853480,1855623,1857756,1859881,1861994,1864111,1866214,1868304,1870391,1872462,1874526,1876580,1878645,1880718,1882782,1884837,1886914,1888981,1891041,1893117,1895207,1897319,1899476,1901624,1903761,1905897,1908044,1910200,1912345,1914511,1916726,1918934,1921132,1923329,1925535,1927782,1930017,1932237,1934446,1936644,1938836,1941019,1943194,1945358,1947515,1949655,1951789,1953918,1955997,1958066,1960124,1962167,1964199,1966223,1968247,1970259,1972272,1974277,1976270,1978249,1980216,1982214,1984201,1986184,1988154,1990115,1992063,1994002,1995935,1997862,1999781,2001690,2003586,2005469,2007346,2009230,2011110,2012982,2014828,2016660,2018478,2020289,2022094,2023890,2025888,2027883,2029867,2031839,2033801,2035760,2037710,2039653,2041586,2043503,2045407,2047303,2049194,2051072,2052938,2054897,2056936,2058973,2061004,2063028,2065043,2067050,2069048,2071047,2073034,2075011,2076980,2078984,2080980,2082967,2084899)) 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





	Sofia National Ballet (Ballet company) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Sofia National Ballet (Ballet company)

Sofia National Ballet (Ballet company)

The National Ballet celebrated its 80th anniversary. The first professional Bulgarian ballet performance, Coppйlia, set by Atanas Petrov, was given on February 22, 1928.

This date is considered the founding date of the National Ballet Company, part of the National Opera Company since its establishment. Through the years of its development the National Ballet has recorded a number of memorable triumphs, recognized in the nthusiastic reviews and commentaries by the most uncompromising judge - the world critics.

Ever since its first steps the Bulgarian ballet searched to fuse the Russian classical school and the German expressive dance movement.  And while Atanas Petrov presented its reading of the classical ballet works Coppйlia, Chopiniana, Raymonda, Die Puppenfee (The Fairy Doll), Giselle, Swan lake, Esmeralda, as well as the first performance on a national theme Zmey i Yana (Dragon and Yana) by Hristo Manolov /1937/, during this period the remarkable adherent to the German expressive dance movement - Mariya Dimova, found a new way to construe  Bulgarian folklore in her productions of Nestinarka by Marin Goleminov /1942/ and German by Filip Kutev.

After 1945 the influence of the Russian classical school increased. Even ballets on national themes were choreographed by foreign, mostly Russian choreographers. This is how Haydushka pesen (Rebel's song) by Aleksandar Raychev choreographed by Nikolay Holfin was created as well as Legenda za ezeroto (Legend of the lake) by Aleksandar Raychev choreographed by Nina Anisimova, Madaskiyat konnik (The Madara horseman) by Dimitar Sagaev choreographed by Jiří Němeček, Papesa Yoanna (Popess Joan) by Veselin Stoyanov choreographed by Witold Borkowski. At the same time Bulgarian choreographers, drawing on the experience of the past decades of development, occupied respected positions in the National Ballet Company: Nina Kiradzhieva with Nestinarka, Bakhchisaraisky fontan (The Fountain of Bakhchisarai) and Laurencia, Bogdan Kovahcev with Petrushka, Daphnis et Chloй, Haydushka pesen (Rebel's song)  and Izvorat na belonogata (The white-legged girl's spring), Galina and Stefan Yordanovi with Romeo and Juliet, Asen Gavriov with A csodбlatos mandarin (The Miraculous Mandarin), Spartacus and Coppйlia, Petar Lukanov with Dashteryata na Kaloyana (Kaloyan's daughter), Koziyat rog (The goat horn), Legenda o liubvi (Legend of love) and Notre-Dame de Paris, Romeo and Juliet, Margarita Arnaudova with her productions Satvorenieto na sveta (The creation of the world), Syankata (The shadow) and Nestinarka.

The trends of maintaining and developing the classical repertoire on one part combined with creation of new modern works on another, still continues today.  Together with Giselle, The sleeping beauty, Swan lake, Chopiniana, Paquita, La Sylphyde, Don Quixote, a number of world known masterpieces were included in the repertoire of the National Ballet, such as Romeo and Juliet /choreography by Oleg Vinogradov/, The Tale of the Stone Flower and  The Nutcracker /choreography by Yuriy Grigorovitch/, The Prodigal Son /choreography by Jiří Němeček/, Spring Fairy Tale and Esquisses /choreography by Atanas Petrov/, Boomerang /choreography by Boris Eifman/ , La fille mal gardйe (The Unchaperoned Daughter) /choreography by Alberto Alonso/,  Phиdre, Romeo and Juliet and  Suite en blanc /choreography by Serge Lifar/, Cinderella and Unfinished symphony /choreography by Peter Van Dyk/, La Pйri /choreography by George Skibin/, La Dame aux camйlias /choreography by Pierre Lacotte/, Zorba the Greek /choreography by Lorca Massine/, a number of experimental works were created by Boryana Sechanova, Donvena Pandurski, Hikmet Mehmedov and by the young choreographers - dancers in the company, Anna Pampulova, Mariana Krancheva, Yordan Krastev.

The artists of the National Ballet - choreographers and performers, have played an essential part in the establishment of the national ballet performance tradition. The pioneers Atanas Petrov, Nina Kiradzhieva, Lili Beron, Lyuba Kolchakova, Valya Verbeva, Penka Encheva, Zhivko Biserov, Asen Gavrilov, Krum Yankov, formed the disciples who deservedly took their places on the stage - Vera Kirova, Krasimira Koldamova, Kalina Bogoeva, Margarita Dimitrova, Tsveta Dzhumalieva, Ichko Lazarov, Anton Stoynov, Emiliya Kirova, Atanas Samev. On their part they trained the new ballet generations - Biser Deyanov, Evgeniya Krasteva, Boyko Nedelchev, Mariana Deneva, Yasen Valchanov, Milena Simeonova, Rumen Rashev, Silviya Tomova, Mariya Ilieva and the young Dilyana Nikiforova, Vesa Tonova-Krastanova, Darina Bedeva, Mariyana Krancheva, Rosen Kanev, Trifon Mitev, Sara-Nora Krasteva. The dancers of the National Ballet received their training in the National School of Dance Art - Sofia and in the Russian academic ballet schools in Moscow and Sankt Petersburg. During recent years eminent Bulgarian ballet masters have been at the head of the company: Petar Lukanov, Hikmet Mehmedov, Yasen Valchanov, Mariya Ilieva, Biser Deyanov.
The National Ballet has performed entire productions and concert programmes at tours abroad with great success. Its participation in a number of international festivals is regarded with high esteem.