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 (-1)) 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





	Robert Schumann (Composer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Robert Schumann (Composer)

Robert Schumann (Composer)

Schumann, Robert (Alexander) (b Zwickau, 1810; d Endenich, 1856). Ger. composer, pianist, cond., and critic. Studied law at Leipzig and Heidelberg Univs., but main interests were mus. and Romantic literature, e.g. Jean-Paul Richter. In 1828 met Clara Wieck, to whose father Friedrich he went for pf. lessons in 1829, lodging with him and beginning to compose. In 1832 permanently injured hand by device he had invented to keep 4th finger immobile while practising. Was already contributing mus. criticism to Ger. papers and in 1831 called attention to Chopin‘s genius. Depressed by mus. situation in Ger., founded ‘David Club’ in 1834 to fight artistic philistines, and periodical Neue Zeitschrift fьr Musik, which he ed. for 10 years. In writings and comps., gave himself dual personality: Florestan for his impetuous self and Eusebius for his contemplative side. In 1838 visited Vienna and discovered MS of Schubert‘s ‘Great’ C major sym., which he sent to Mendelssohn. Married Clara Wieck 1840 after long opposition from her father, this being followed by outpouring of songs and song-cycles. In 1841 concentrated on syms., in 1842 on chamber mus., and in 1843 choral works. Taught comp. at Leipzig Cons. Toured Russia with Clara, 1844. On return had severe attack of depression. Moved to Dresden in search of quiet, living there until 1850. In 1846 Clara gave f.p. of his pf. conc. and Mendelssohn cond. f.p. of 2nd Sym. In 1850 moved to Dьsseldorf in hope of earning more by conducting, but was not a success. Met 20-year-old Brahms in 1853, acclaiming him in article ‘New Paths’. The next year his mental health failed and he threw himself into Rhine, but was saved and taken to private asylum where he lived another 2 years.

Schumann was one of the greatest composers for pf., enriching its literature with a series of poetic works in which classical structure and Romantic expression are combined. His vocal and chamber mus. is of comparable quality, with the freshness, vitality, and lyricism which also characterize the orch. works. His orchestration is sometimes criticized for its thickness and lack of fluency, and various attempts have been made to ‘improve’ the scoring, e.g. by Mahler, but the present-day tendency is to prefer the spontaneity of Schumann‘s own. His songs, particularly his song-cycles, are among the glories of Lieder. His works contain many musical quotations and allusions and a number of his themes have been shown to be musical cryptograms. Prin. comps.:

OPERA: Genoveva, Op.81 (1847-9).

INCIDENTAL MUSIC: Manfred, Op.115 (Byron) (1848-9).

ORCH.: syms.: No.1 in Bb (Frьhling, Spring), Op.38 (1841), No.2 in C, Op.61 (1845-6), No.3 in Eb (Rhenish), Op.97 (1850), No.4 in D minor (begun 1841, 2nd in order of comp., rev. 1851), Op.120; Overture, Scherzo, and Finale, Op.52 (1841, rev. 1845); Overture to Shakespeare‘s Julius Caesar, Op.128 (1851); Overture on Goethe‘s Hermann and Dorothea, Op.136 (1851).

CONCERTOS, etc.: pf. conc. in A minor, Op.54 (1st movt. written as Fantasie 1841, rest added 1845); Konzertstьck, 4 hn., in F, Op.86 (1849); Introduction and Allegro appassionato, pf., Op.92 (1849); vc. conc. in A minor, Op.129 (1850); Fantasy in C, vn., Op.131 (1853); Concert-Allegro and Introduction in D minor, pf., Op.134 (1853); vn. conc. in D minor, Op.2 posth. (1853).

CHORUS AND ORCH.: Das Paradies und die Peri (Paradise and the Peri), Op.50 (1843); Requiem fьr Mignon, Op.98b (1849); Nachtlied, Op.108 (1849); Der Rose Pilgerfahrt, Op.112 (1851); Der Kцnigssohn, Op.116 (1851): Des Sдngers Fluch, Op.139 (1852); Mass, Op.147 (1852); Requiem, Op.148 (1852); Scenes from Goethe‘s Faust (1844-53).

CHAMBER MUSIC: str. qts.: Op.41, No.1 in A minor, No.2 in F, No.3 in A (1842); pf. qts.: in C minor (1829), in Eb, Op.47 (1842); pf. quintet in Eb, Op.44 (1842); pf. trios: No.1 in D minor, Op.63 (1847), No.2 in F, Op.80 (1847), No.3 in G minor, Op.110 (1851); vn. sonata No.1 in A minor, Op.105 (1851), No.2 in D minor, Op. 121 (1851); Adagio and Allegro in Ab, hn. (or vn. or vc.), pf., Op.70 (1849); Fantasiestьcke, cl. (or vn. or vc.), pf., Op.73 (1849); Fantasiestьcke, pf., vn., vc., Op.88 (1842); 3 Romanzen, ob. (or vn. or cl.), pf., Op.94 (1849); Mдrchenbilder, va. (or vn.), pf., Op.113 (1851); 5 Pieces in Folk Style, vc. (or vn.), pf., Op.102 (1849); Mдrchenerzдhlungen, pf., cl. (or vn.), va., Op.132 (1853); pf. accs. to 6 vn. sonatas and partitas by J. S. Bach (1854).

PIANO: Abegg Theme with Variations, Op.1 (1830); Papillons, Op.2 (1829-31); 12 Concert Studies on Paganini Caprices, Set I, Op.3 (1832), Set II, Op.10 (1833); 6 Intermezzi, Op.4 (1832); Impromptus on a Theme by Clara Wieck, Op.5 (1833, rev. 1850); 18 Davidsbьndlertдnze, Op.6 (1837, rev. 1850); Toccata in C, Op.7 (1830); Allegro in B minor, Op.8 (1831); Carnaval: Scиnes mignonnes sur 4 notes, Op.9 (1834-5); sonatas: No.1 in F# minor, Op.11 (1833-5), No.2 in G minor, Op.22 (1833-8), No.3 in F minor, Op.14 (1835, rev. 1853); 8 Fantasiestьcke, Op.12 (1837-8); Йtudes symphoniques (Symphonic Studies), Op.13 (1834-7, rev. 1852); Kinderscenen, Op.15 (1838); Kreisleriana, Op.16 (1838, rev. 1850); Fantasy in C, Op.17 (1836); Arabeske in C, Op.18 (1839); Blumenstьck in Db, Op.19 (1839); Humoreske in Bb, Op.20 (1839); 8 Novelletten, Op.21 (1838); 4 Nachtstьcke, Op.23 (1839); Faschingsschwank aus Wien, Op.26 (1839); 3 Romanzen, Op.28 (1839); Album fьr die Jugend, Op.68, Book I containing 18 pieces, Book II, 25 (1848); Waldscenen, Op.82 (1848-9); Bunte Blдtter, Op.99 (1852); 3 Fantasiestьcke, Op.111 (1851); 3 pf. sonatas ‘fur die Jugend’, Op.118 (1853); Albumblдtter, Op.124 (1832-45); 7 Piano Pieces in the form of fugues, Op.126 (1853); 5 Gesдnge der Frьhe, Op.133 (1853).

PIANO DUETS: 6 Impromptus, Op.66 (1848), Ball-Scenen, Op.109 (1851).

ORGAN: 6 Fugues on the Name of Bach, Op.60 (1845).

PART-SONGS: mixed: 5 Lieder, Op.55 (1846); Romanzen und Balladen, 4 vols., Opp. 67, 75, 145, 146 (1846-9); women‘s: Romanzen, 2 vols., Opp. 69, 91 (1849); men‘s: 6 Lieder, Op.33 (1840); 5 Hunting-Songs, with 4 optional hn., Op.137 (1849).

SONGS & SONG-CYCLES: Liederkreis (Heine), Op.24 (1840); Myrthen, cycle of 26 songs, Op.25 (1840); Lieder und Gesдnge, I, Op.27 (1840), II, Op.51 (1842), III, Op.77 (1840 and 1850), IV, Op.96 (1850); 12 Gedichte, Op.35 (1840); 6 Gedichte, Op.36 (1840); 12 Gedichte aus Liebesfrьhling, Op.37 (1840); Liederkreis (Eichendorff), Op.39 (1840); Frauenliebe und -Leben, song-cycle, Op.42 (1840); Romanzen und Balladen, I, Op.45 (1840), II, Op.49 (1840), III, Op.53 (1840), IV, Op.64 (1841 and 1847); Dichterliebe, song-cycle, Op.48 (1840); Liederalbum fьr die Jugend, Op.79 (1849); 3 Gesдnge, Op.83 (1850); 6 Gesдnge, Op.89 (1850); 6 Gedichte, Op.90 (1850); 3 Gesдnge, Op.95 (1849); 9 Lieder und Gesдnge aus Wilhelm Meister, Op.98a (1849); 7 Lieder, Op.104 (1851); 6 Gesдnge, Op.107 (1851-2); 4 Husarenlieder, Op.117 (1851); 3 Gedichte, Op.119 (1851); 5 Heitere Gesдnge, Op.125 (1851); 5 Lieder und Gesдnge, Op.127 (1850-1); Gedichte der Kцnigin Maria Stuart, Op.135, (1852); 4 Gesдnge, Op.142 (1852).