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 (1915752,1917962,1920166,1922365,1924552,1926801,1929040,1931269,1933488,1935687,1937883,1940072,1942251,1944422,1946583,1948731,1950867,1952999,1955119,1957195,1959263,1961312,1963350,1965379,1967398,1969418,1971428,1973440,1975435,1977423,1979392,1981393,1983385,1985367,1987348,1989318,1991273,1993209,1995149,1997078,1998997,2000911,2002814,2004706,2006580,2008466,2010351,2012227,2014091,2015931,2017760,2019568,2021375,2023176,2024972,2026962,2028952,2030931,2032898,2034855,2036812,2038757,2040695,2042621,2044530,2046430,2048317,2050200,2052073,2053938,2055889,2057926,2059959,2061987,2064007,2066017,2068019,2070025,2072017,2073993,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





	Sergei Prokofiev (Composer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Sergei Prokofiev (Composer)

Sergei Prokofiev (Composer)

Sergei Prokofiev, as he writes in his memoirs, "first saw the light of day on Wednesday 23rd April at five in the afternoon." The year was 1891, the centenary of Mozart’s death, the place a small village in the Ukraine, Sontsovka. Prokofiev’s father, originally from Moscow, was an agricultural engineer in this important region, his mother was, in Gliere’s words, "a tall woman with magnificent, intelligent eyes... who knew how to create around herself a warm, natural atmosphere." Having lost two daughters she devoted her life to music and spent two months a year in Moscow or St. Petersburg taking piano lessons. It was she who was the musical influence on young Sergei, beginning to teach him the piano at age 3. He wrote his first composition when he was six, The Indian Galop. After a trip to Moscow at age 8 where he was exposed to The Sleeping Beauty, Faust and Prince Igor, he declared "I want to write an opera." Three or four months later he presented his parents with The Giant, an opera in three acts and six tableau for solo piano. Prokofiev eventually was tutored by young Reinhold Gliere for whom he developed a great affection, especially after he had accepted Prokofiev’s challenge to a duel with pistols. From time to time he also took trips to Moscow to visit Taneyev (a composer and the future director of the Bolshoi Theater).
By age twelve it was decided that Prokofiev should continue his studies at a Conservatoire. Eventually, in 1904 he was sent to the St. Petersburg Conservatoire so that his mother could be close to him. The Conservatoire at this time was under the direction of Rimsky-Korsakov. He was also introduced to Glazounov. Despite a faltering first meeting Glazounov dedicated his Fantasy Waltz "To my dear colleague, Sergei Prokofiev, from Glazounov."
Against the established thinking of the Conservatoire, Prokofiev became a committed anti-Romantic, not liking the music of Chopin and Liszt. In 1914, despite not playing one of the prescribed Classical concertos, he won the Rubenstein Prize for piano performance playing his own composition.
The year of the Russian Revolution, 1917, turned out to be a creative time for Prokofiev producing the Violin Concerto in D major and the Classical Symphony. Prokofiev moved to the United States in 1918 where he gave his first recital November 11th. In America he was greatly discussed, somewhat admired but little liked being variously described as "the Bolshevik pianist" or "Steel fingers, steel biceps, steel triceps - he is a tonal steel trust." The lack of success for his opera The Love of Three Oranges, commissioned by the Chicago Opera in 1921, was enough to spur Prokofiev’s relocation to Europe.
On return trips to Russia in 1927 and 1929 Prokofiev was enthusiastically received. Following a comparative lack of success in Europe and the United States, he returned to Stalin’s Soviet Union for good in 1932. The next years produced Lieutenant Kije, Romeo and Juliet, War and Peace and Cinderella. In his homeland he was celebrated and honored until the 1948 crackdown on Soviet composers by the Central Committee under Stalin’s orders. (This was also the year of his marriage to Mira Mendelson.) After that time all music had to conform to strict criteria to "advance Soviet musical culture so as to lead to the creation, in all fields of music, of high-quality works worthy of the Soviet people." The result was uncontroversial music of artistic inconsequence.
Prokofiev died of a cerebral hemorrhage in Moscow, March 5, 1953, the same day that Stalin died. He was buried near Scriabin and Chekov.