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 (549517,550960,552395,553819,555234,556641,558043,559440,560833,562220,563602,564971,566332,567691,569045,570393,571733,573112,574484,575845,577203,578555)) 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





	Nikolai Rimsky-Korsakov (Composer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Nikolai Rimsky-Korsakov (Composer)

Nikolai Rimsky-Korsakov (Composer)

Nikolai Rimsky-Korsakov was a celebrated Russian composer and music teacher. His symphonic suite Scheherazade (1888) ranks as one of the most popular orchestral works ever written.
Rimsky-Korsakov became famous for his imaginative blend of orchestral sounds. Examples include Capriccio Espagnol (1887) and the Russian Easter Overture (1888). Rimsky-Korsakov based many of his 15 operas on Russian history and folklore. Only one of them, Le Coq d‘Or (The Golden Cockerel, completed in 1907), won international fame. But his operas The Snow Maiden (1882), Sadko (1898), and Tsar Saltan (1900) are popular in the Soviet Union. Two of his most famous pieces come from his operas "Song of India" from Sadko and "The Flight of the Bumblebee" from Tsar Saltan.
Nikolai Andreyevich Rimsky-Korsakov was born in Tikhvin, near Novgorod. From 1856 to 1862,he attended the Naval Academy in St. Petersburg. In 1861, Rimsky-Korsakov met the composer Mily Balakirev and joined a group of young composers who later became known as The Five. This group, led by Balakirev, urged Russian composers to stress their national heritage in their music.
In 1862, Rimsky-Korsakov sailed on a three-year naval cruise, during which he visited the United States. He completed his first symphony aboard ship. After returning to St. Petersburg in 1865, he revised the symphony under Balakirev‘s supervision. It had its first performance that same year.
In 1871, Rimsky-Korsakov left the navy and joined the faculty of the St. Petersburg Conservatory. He realized that he knew almost no music theory, and so he taught himself counterpoint, harmony, and music form. He became one of the world‘s greatest music theorists. He taught several students who achieved fame as composers, including Sergei Prokofiev and Igor Stravinsky.
Rimsky-Korsakov also edited and revised compositions that his friends Alexander Borodin and ModestMussorgsky had left unfinished when they died. Orchestras and opera companies usually perform Rimsky- Korsakov‘s version of Mussorgsky‘s opera Boris Godunov. Borodin‘s opera Prince Igor is usually performed in the version completed by Rimsky-Korsakov and the Russian composer Alexander Glazunov.