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 (2697937,2701011,2704093,2707165,2710201,2713233,2716257,2719322,2722396,2725495,2759394,2762409,2765418,2768408,2771382,2774352,2777311,2780295,2783320,2786401,2789480,2792539,2795595,2798664,2801723,2804773,2807740,2810684,2813608,2816524,2819503,2822473,2825455,2828424,2831375,3655393,3657123,3658846,3660566,3662290,3664006,3665707,3667405,3669092,3670772)) 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





	Mikhail Glinka (Composer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Mikhail Glinka (Composer)

Mikhail Glinka (Composer)

Glinka is commonly regarded as the founder of Russian nationalism in music. His influence on Balakirev, self-appointed leader of the later group of five nationalist composers, was considerable. As a child he had some lessons from the Irish pianist John Field, but his association with music remained purely amateur, until visits to Italy and in 1833 to Berlin allowed concentrated study and subsequently a greater degree of assurance in his composition, which won serious attention both at home and abroad. His Russian operas offered a synthesis of Western operatic form with Russian melody, while orchestral music, with skilful instrumentation, offered a combination of the traditional and the exotic. Glinka died in Berlin in 1857.
Glinka‘s first Russian opera, A Life for the Tsar, was well received at its first staging in 1836. His second full opera, Ruslan and Lyudmila, with a libretto by Pushkin, proved less acceptable at its first staging in St. Petersburg in 1842. The Overtures to these operas make effective curtain-raisers.
Travel abroad inspired the Spanish mood of Jota aragonesa, a Capriccio brillante also known as the First Spanish Overture. The second of the series was expanded from Recuerdos de Castilla, Souvenirs of Castile, into Souvenir d‘une nuit d‘ete a Madrid (Memory of a Summer Night in Madrid). Kamarinskaya, written in Warsaw, uses Slav thematic material.