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 (1256589,1258552,1260507,1262449,1264378,1266298,1268224,1270140,1272044,1273937,1275814,1277673,1279527,1281376,1283216,1285046,1286867,1288669,1290454,1292266,1294072,1915713,1915752,1917925,1917962,1920126,1920166,1922325,1922365,1924516,1924552,1926764,1926801,1929005,1929040,1931234,1931269,1933449,1933488,1935648,1935687,1937844,1937883,1940033,1940072,1942212,1942251,1944383,1944422,1946544,1946583,1948693,1948731,1950828,1950867,1952960,1952999,1955081,1955119,1957157,1957195,1959221,1959263,1961273,1961312,1963311,1963350,1965342,1965379,1967361,1967398,1969382,1969418,1971391,1971428,1973404,1973440,1975398,1975435,1977387,1977423,1979355,1979392,1981356,1981393,1983348,1983385,1985330,1985367,1987311,1987348,1989281,1989318,1991236,1991273,1993172,1993209,1995113,1995149,1997042,1997078,1998960,1998997,2000874,2000911,2002777,2002814,2004671,2004706,2006543,2006580,2008432,2008466,2010317,2010351,2012194,2012227,2014054,2014091,2015894,2015931,2017723,2017760,2019531,2019568,2021338,2021375,2023139,2023176,2024932,2024972,2026925,2026962,2028915,2028952,2030894,2030931,2032858,2032898,2034818,2034855,2036771,2036812,2038716,2038757,2040654,2040695,2042580,2042621,2044493,2044530,2046389,2046430,2048280,2048317,2050161,2050200,2052034,2052073,2053900,2053938,2055851,2055889,2057888,2057926,2059921,2059959,2061948,2061987,2063968,2064007,2065978,2066017,2067981,2068019,2069986,2070025,2071977,2072017,2073957,2073993,2075929,2075965,2077929,2079927,2081919,2083904,2085829,2087742,2089651)) 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





	Peter Tchaikovsky (Composer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Peter Tchaikovsky (Composer)

Peter Tchaikovsky (Composer)

Peter Ilyich Tchaikovsky was born on May 7, 1840 at Votkinsk, in the government of Vyatka, Russia. He was close to his family - his father (a mine inspector,) his mother, four brothers, and a sister. At the age of five, he began to study piano, soon revealing his amazing gifts. It wasn't until he was 21, however, that he began to study music seriously. In 1863, Tchaikovsky entered the St. Petersburg Conservatory and undertook some private training. The young Tchaikovsky was a master at improvisation, but so unschooled he was unaware of such simple musical tenets as the possibility of modulating to different keys. Tchaikovsky frequently attended the opera and fell in love with the music of Mozart. His diligence became apparent when his composition teacher, Anton Rubinstein, assigned variations as homework. Tchaikovsky sat up all night and prepared 200. In 1866, Tchaikovsky moved permanently to Moscow where he accepted a teaching position in a new conservatory established by Anton Rubinstein's brother, Nicholas. It was there that his First Symphony was created, receiving a warm reception by Moscow audiences in 1868. It was also there that Tchaikovsky had his first nervous breakdown, due to the stress of composing the First Symphony. Interestingly, Tchaikovsky had asked his former teacher, Anton Rubinstein, to premiere the work in St. Petersburg, a request which was ultimately denied. Other works followed with less success, including Tchaikovsky's first opera, The Voyevoda, in 1869, later re-worked into The Oprichnik in 1874. By then Tchaikovsky's Second Symphony had begun winning acclaim, as had his First Piano Concerto . Following these compositions were his Third Symphony and Swan Lake , the tone poem Francesca da Rimini in 1875, and the Rococo Variations for cello and orchestra in 1876. By the end of 1876, Tchaikovsky was contacted by a wealthy admirer, Nadejda Fillaretovna von Meck, who gave him several commissions and became his sponsor for the next 12 years. Throughout this period, Tchaikovsky continued to struggle with his homosexuality. Although Tchaikovsky had a brief affair with opera singer Desiree Artot, he was clearly inclined to deny his own nature. In a letter to his brother, Tchaikovsky wrote, "I am aware that my inclinations are the greatest and most unconquerable obstacle to happiness; I must fight my nature with all of my strength. I shall do everything possible to marry this year." Indeed, he did marry a young woman, Antonina Ivanovana Milyukoff, on July 6, 1877. However, within a month, he discovered they were incompatible and spent the next few months running away from his new wife. He also made a failed attempt at suicide by walking into the Moska River in the hopes of contracting pneumonia. It was at this point, in the late 1870s, that he wrote some of his greatest works, the opera Eugene Onegin , the Violin Concerto , and the Fourth Symphony. Based on Alexander Pushkin‘s novel in verse, Eugene Onegin (1878) tells the story of a girl fascinated by a man who ultimately rejects her and his later remorse. That same year, Tchaikovsky also wrote the Violin Concerto . He wrote Manfred in 1885; the Fifth Symphony in 1888; another successful opera, Pique Dame (The Queen of Spades) in 1890; and the Casse-Noisette ballet in 1891. These successes made Tchaikovsky famous throughout the world. He temporarily surrendered his shyness to conduct and, in 1888, made an international conducting tour. In 1891, Tchaikovsky came to New York and conducted his own works at the ceremonies of the opening of Carnegie Hall. By 1890, the inevitable break with Madame von Meck had occurred and, while Peter gained his financial independence, he felt his loss on a more personal than professional level. Madame von Meck, in addition to an income of 6,000 roubles, had provided Tchaikovsky an outlet to air his opinions, beliefs, hopes, and dreams. There has been no particular reason recorded as to why the break between them occurred. In 1893, Tchaikovsky completed the Pathetique Symphony (No. 6) and conducted it at St. Petersburg to a rather apathetic response. Unfortunately, Peter would not live to see its ultimate success. By most accounts, Tchaikovsky drank an unfiltered (unboiled) glass of water, contracted cholera, and died on November 6, 1893. In recent years, some have proffered another theory: that Tchaikovsky was forced to take arsenic to preserve his school‘s honor when his homosexuality was to become public. However Tchaikovsky died, 8,000 mourners attended his funeral. He was buried at St. Petersburg‘s Alexander Nevsky Monastery.