SELECT * FROM cms_1_contents_en WHERE SUB='0' AND ACTIVE='1' AND (MODULE="menu_fullwidth" OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu') AND MODULE!='home' ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='96' AND ACTIVE='1' AND (MODULE="menu_fullwidth" OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu') ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='111' AND ACTIVE='1' AND (MODULE="menu_fullwidth" OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu') ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='97' AND ACTIVE='1' AND (MODULE="menu_fullwidth" OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu') ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='103' AND ACTIVE='1' AND (MODULE="menu_fullwidth" OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu') ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='100' AND ACTIVE='1' AND (MODULE="menu_fullwidth" OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu') ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='98' AND ACTIVE='1' AND (MODULE="menu_fullwidth" OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu') ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='107' AND ACTIVE='1' AND (MODULE="menu_fullwidth" OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu') ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='104' AND ACTIVE='1' AND (MODULE="menu_fullwidth" OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu') ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='105' AND ACTIVE='1' AND (MODULE="menu_fullwidth" OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu') ORDER BY NO ASC
SELECT * FROM cms_1_contents_en WHERE SUB='92' AND ACTIVE='1' AND (MODULE="menu_fullwidth" OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu') ORDER BY NO ASC
SELECT * FROM cms_1_sidebar WHERE CONTENTID="105" ORDER BY POSITION ASC
SELECT * FROM cms_1_contents_en WHERE ACTIVE="1" AND SUB="105" ORDER BY NO ASC
SELECT * FROM cms_1_pictures WHERE CONTENTID='105' AND CONTENTTYPE='1' AND MAIN!='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='105' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='105' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='105' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_discography_en WHERE ACTIVE="1" ORDER BY PUBDATE DESC
SELECT * FROM cms_1_pictures WHERE CONTENTID='30' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='29' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='15' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='24' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='14' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='13' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='10' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='11' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='12' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='9' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='26' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='7' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='6' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='5' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='22' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='23' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='20' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='4' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='21' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='19' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='18' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='2' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='3' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='8' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='16' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='17' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='1' AND MAIN='1' AND CONTENTTYPE='41'
SELECT * FROM cms_1_pictures WHERE CONTENTID='25' AND MAIN='1' AND CONTENTTYPE='41'
Discography | andrearost.com
SELECT * FROM cms_1_news_en WHERE ACTIVE='1' AND CATEG='1' ORDER BY PUBDATE DESC LIMIT 2
SELECT * FROM cms_1_contents_en WHERE ACTIVE='1' AND SUB='0' AND (MODULE="menu_fullwidth" OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='home'OR MODULE='content'OR MODULE='content'OR MODULE='content'OR MODULE='menu_fullwidth'OR MODULE='menu_fullwidth'OR MODULE='repertoire'OR MODULE='videos'OR MODULE='gallery'OR MODULE='menu'OR MODULE='press'OR MODULE='discography'OR MODULE='calendar'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu_fullwidth'OR MODULE='home'OR MODULE='landing_mesterkurzus'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu'OR MODULE='menu') ORDER BY NO DESC LIMIT 1
SELECT * FROM cms_1_templates_en WHERE EXTRA="0"
Discography
Publisher : Kossuth-Mojzer
Publisher : Hungarian State Opera
Participants : Erika Gál, Levente Molnár, Adorján Pataki, Andrea Ulbrich, Zoltán Gradsach, Bernadett Wiedermann, Andrea Rost and Hungarian State Opera Chorus and Orchestra
Track list:
I'm leaving, I'm leaving
From the leaves and branches of the lemon tree
This is the kind of young lad I should have
My empty chest int the doorway
The sad willow tree
I went to the market
The girls are good ones, not bad
Pantomime
I'm sure I'll die
Shoo fly! Don't land on me
Far away, my rose
I've just come from Transylvania
The big-nosed flea
Beneath the mountains of Csitár
Tempo di marcia
It's time to leave
Oh! Come home, dear mother
That's where I'm going
Pantomime
That's how my days are filled
Intermezzo
How lovely the leaves sound
Publisher : Deutsche Grammophon
Participants : Magdalena Kozená, Matthew Polenzani, Thomas Quasthoff, Andrea Rost, Yefim Bronfman, James Levine
Track list:
1. Botschaft
2. Wie bist du, meine Königin
3. Junge Lieder I "Meine Liebe ist grün wie der Fliederbusch"
4. An eine Äolsharfe
5. Feldeinsamkeit
6. Immer leiser wird mein Schlummer
7. Rede, Mädchen, allzu liebes
8. Am Gesteine rauscht die Flut
9. O die Frauen, o die Frauen
10. Wie des Abends schöne Röte
11. Die grüne Hopfenranke
12. Ein kleiner, hübscher Vogel nahm den Flug
13. Wohl schön bewandt war es vorehe
14. Wenn so lind dein Auge mir
15. Am Donaustrande, da steht ein Haus
16. O wie sanft die Quelle sich
17. Nein, es ist nicht auszukommen
18. Schlosser auf! und mache Schlösser
19. Vögelein durchrauscht die Luft
20. Sieh, wie ist die Welle klar
21. Nachtigall, sie singt so schön
22. Ein dunkler Schacht ist Liebe
23. Nicht wandle, mein Licht, dort aussen
24. Es bebet das Gesträuche
25. Das Mädchen spricht
26. Wir wandelten
27. Unbewegte laue Luft
28. Mit vierzig Jahren (Rückert)
29. Steig auf, geliebter Schatten
30.Mein Herz ist schwer
31. Sapphische Ode
32. Kein Haus, keine Heimat
33. Verzicht, o, Herz auf Rettung
34. Finstere Schatten der Nacht
35. An jeder Hand die Finger
36. Ihr schwarzen Augen
37. Wahre, wahre deinen Sohn
38. Rosen steckt mir an die Mutter
39. Vom Gebirge, Well' auf Well'
40. Weiche Gräser im Revier
41. Nagen am Herzen
42. Ich kose süss
43. Alles, alles in den Wind
44. Schwarzer Wald, dein Schatten ist so düster!
45. Nein, Geliebter, setze dich
46. Flammenauge, dunkles Haar
47. Zum Schluss: Nun, ihr Musen genug!
Publisher: Deutsche Grammophon
Buying : Deutsche Grammophon
Publisher : Kossuth-Mojzer
Publisher : Kossuth-Mojzer
Index:
1. Gianni Schicchi 2. Die Entführung aus dem Serail 3. Aida 4. Pagliacci 5. Madama Butterfly
Publisher : Kossuth-Mojzer
Index: The Magic Flute Turandot The Barber of Seville The Marriage of Figaro
Label: Kossuth-Mojzer
Publisher : MTVA
Participants : János Kovács, Katalin Gémes
Conductor: János Kovács Participant: Katalin Gémes - mezzosopran
Track list: 1. Gounod : Romeo and Juliet - ''Je veux vivre..." (3:56) 2. Gounod : Romeo and Juliet - "Dieu, quel frisson court dons mes vienes?...Amour ranime mon courage" (5:50) 3. Gounod : Faust - "Ah! Je ris de me voir si belle en ce miror (2:33) 4. Offenbach : The Tales of Hoffmann - "Elle a fui, la tourterelle!" (4:54) 5. Bizet : Carmen - "C'est des contrebandiers le refuge ordinaire... Je dis que rien ne m'épouvante." (6:16) 6. Puccini : La bohéme - "Si, mi chiamano Mimi" (4:52) 7. Puccini : La bohéme - "Donde lieta usci" (3:18) 8. Puccini : Turandot - "Signore, ascolta..." (2:27) 9. Leoncavallo : Pagliacci - "Qual fiamma avea nel guardo...Strono lassu liberamente" (4:28) 10. Verdi : Otello - "Era piu calmo...Piangea cantando" (11:35) 11. "Ave Maria" / Desdemona (4:41)
Label: MTVA
Buying: Bookline.hu
Publisher : Viva la Musica
Participants : Szokolay Dongó Balázs, Bolya Mátyás, Lukács Miklós, Glaser Péter, Budapest Klezmer Band
Track list:
1. The cherry is ripening 2. Hommage á Zoltán Kodály 3. Oyfn Pripetshik 4. Dojna 5. Dance with sticks 6. Ustyi sheje 7. Three Orphans 8. Variations on Transylvanian dance melody 9. Holy Maria 10. Song from the Pannonian Basin - Song of Wandering 11. Love songs I. 12. Love songs II. 13. Love songs III. 14. Dona, dona 15. Tumbalajka 16. S'Yiddishe Meydele 17. Di mekhutonim
Publisher : Warner Music
Participants : Izabella Simon
1. Tiszán innen, Tiszán túl 2. Erdők, völgyek, szűk ligetek 3. Olvad a hó 4. Ha bemegyek a csárdába 5. Fehér László lovat lopott 6. Megittam a piros bort 7. Ez a kislány gyöngyöt fűz 8. Sej, mikor engem katonának visznek 9. Még azt mondják 10. Kis kece lányom 11. Fekete főd, fehér az én zsebkendőm 12. Istenem, áraszd meg a vizet 13. Asszonyok, asszonyok, had’ legyek társatok 14. Annyi bánat a szívemen 15. Ha kimegyek arra magos tetőre 16. Töltik a nagyerdő útját 17. Eddig való dolgom a tavaszi szántás 18. Olvad a hó 19. Mónár Anna 20. Kitrákotty mese 21. A rossz feleség 22. Kocsi, szekér… 23. Virágos kenderem… 24. Akkor szép az erdő… 25. A nővérek 26. A csitári hegyek alatt 27. Táncol a hold fehér ingben 28. Gyümölcs-fürt 29. Kalmár jött nagy madarakkal 30. Csalfa sugár 31. A legszebb virág 32. A csendes dalokból 33. A bujdosó 34. Az ördög elvitte a fináncot
Publisher : RCA Victor Europe
Participants : Walter Jurmann
1. Mein schönes Wien 2. Ein Lied aus meiner Heimat 3. Ninon 4. You and The Walz and I 5. The One I love 6. In the Spirit of the Moment 7. Walter Jurmann in Hollywood 8. Ces't ton amour 9. Ich suche einen, der mir allein gehört 10. In dich hab ich mich verliebt 11. Die Augen der Liebe 12. Du bisdt nicht der Erste 13. Frauen brauchen immer einen Hausfreund 14. Walter Jurmann and Jazz 15. San Francisco 16. Veronika, der Lenz ist da 17. NinonBuying : amazon.com
Publisher : Warner Classics
1. Le nozze di Figaro - "Non so piú cosa son, cosa faccio" [Cherubino, Act 1] (2:56) 2. Le nozze di Figaro - "Porgi, amor, qualche ristoro" [Contessa Almaviva, Act 2] (3:13) 3. Le nozze di Figaro - "Voi che sapete che cosa e amor" [Cherubino, Act 2] (2:44) 4. Le nozze di Figaro - "Venite, inginocchiatevi" [Susanna, Act 2] (2:54) 5. Le nozze di Figaro - "E Susanna non vien... Dove sono i bei momenti" [Contessa Almaviva, Act 3] (6:20) 6. Le nozze di Figaro - "L'ho perduta, me meschina!" [Barbarina, Act 4] (1:49) 7. Le nozze di Figaro - "Il capro e la capretta" [Marcellina, Act 4] (3:58) 8. Le nozze di Figaro - "Giunse alfin il momento... Deh vieni, non tardar" [Susanna, Act 4] (4:21) 9. Don Giovanni - "Ah, fuggi il traditor" [Donna Elvira, Act 1] (1:13) 10. Don Giovanni - "Or sai chi l'onore" [Donna Anna, Act 1] (2:43) 11. Don Giovanni - "Batti, batti o bel Masetto" [Zerlina, Act 1] (3:55) 12. Don Giovanni - "Vedrai, carino se sei buonino" [Zerlina, Act 2] (3:17) 13. Don Giovanni - "Mi tradi, quell' alma ingrata" [Donna Elvira, Act 2] (5:54) 14. Don Giovanni - "Non mí dir, bell'idol mio" [Donna Anna, Act 2] (6:27)
Publisher : Warner Music Hungary
A Bánk bán Erkel Ferenc háromfelvonásos operája. Szövegkönyvét Egressy Béni írta Katona József azonos című drámája alapján. Elsőként a Tisza-parti jelenetet hallhatta a közönség 1861. január 6-án, Pesten, a Nemzeti Múzeum dísztermében. A teljes mű ősbemutatójára 1861. március 9-én került sor a Nemzeti Színházban. A Káel Csaba rendezte operafilm anyaga alapján készült CD kiadás. Gertrúd – Marton Éva II. Endre – Kováts Kolos Ottó – Gulyás Dénes Bánk bán – Kiss B. Atilla Melinda – Rost Andrea Tiborc – Miller Lajos Petúr bán – Sólyom-Nagy Sándor Biberach – Réti Attila Sólom mester – Asztalos Bence Közreműködik a Magyar Millennium zenekara és a Magyar Nemzeti Énekkar, vezényel Pál Tamás. A felvétel helye és ideje: Budapest 2002, a kiadás éve CD-n: 2003.
Publisher : Sony Classical
Participants : Andrea Rost, Luciano Pavarotti, Jane Eaglen, Plácido Domingo, Karita Mattila, Inva Mula, et al.
Publisher : Koch Int'l Classics
Publisher : Sony Classical
Participants : Eva Marton, Luciano Pavarotti, Ileana Cotrubas, Ying Huang, Richard Troxell, Dame Te Kanawa Kiri, Richard Tucker, Andrea Rost, Marcelo Alvarez
Publisher : Deutsche Grammophon
Participants : José Carreras, Andrea Rost, Placido Domingo, Thomas Hampson, Lind
Lucia has not exactly been neglected on records, and Andrea Rost is not as dramatic a Lucia as Maria Callas nor as vocally opulent as Joan Sutherland. Still, she is vocally satisfactory and dramatically effective, and she is supported by a first-class cast, notably the elegant Bruce Ford as her doomed lover Edgardo and Anthony Michaels- Moore as her tormented, manipulative brother Enrico.
The primary attractions of this edition, however, are the period-instrument orchestra and Sir Charles Mackerras, who not only conducts a compelling treatment but has also taken the trouble of consulting and following Donizetti's original manuscript, scraping away a century and a half of "performing tradition"--i.e., changes introduced by singers more interested in showing off their voices than in following the composer's wishes. This is closer to the original inspiration than any previous recording, and more structurally coherent if less vocally spectacular. The recorded sound is very impressive. --Joe McLellan
Buying : amazon.com
Publisher : Sony
Participants : Levente Szörényi
Publisher : Sony Classical
Track list:
1. Rigoletto: Caro name 2. La Traviata: Ah! fors'e lui...Sempre liber 3. La Traviata: Addio del passato 4. La Boheme: Si. Mi chiamano Mimi 5. La Boheme: Quando m'en vo' 6. Gianni Schicchi: O mio babbino caro 7. L'Elisir d'Amore: Prendi, per me sie libero 8. Don Pasquale: Quel guardo il cavalicere 9. Lucia di Lammermoor: Regnava nel silenzio 10. Lucia di Lammermoor: Il dolce suono mi colpi...Ardon gl'incensi
Publisher : Deutsche Grammophon
Participants : Berliner Philharmoniker, Bryn Terfel, Cheryl Studer, Claudio Abbado, Andrea Rost, és Sylvia McNair
Publisher : Deutsche Grammophon
Publisher : Sony Classical
Participants : Riccardo Muti, Andrea Rost, Roberto Alagna, Coro e Orchestra del Teatro alla Scala
DEVELOPER BAR
Generated: 0.0576 sec
DB prefix: _andrearostcom
Page group: 1
Skin: andrearostcom
Language:
Generated files: core.min.generated.js style.min.generated.css