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="" ORDER BY POSITION ASC
SELECT * FROM cms_1_slider_en WHERE ACTIVE="1" ORDER BY NUMBER DESC
SELECT * FROM cms_1_shop_en WHERE MAINPAGE='1'
SELECT * FROM cms_1_contents_en WHERE ACTIVE='1' AND MODULE='home'
SELECT * FROM cms_1_videos_en WHERE ACTIVE='1' AND MAINPAGE='1' ORDER BY ID DESC LIMIT 1
SELECT * FROM cms_1_galleries_en WHERE ACTIVE='1' ORDER BY RAND() LIMIT 7
SELECT * FROM cms_1_pictures WHERE CONTENTID='15' AND MAIN='1' AND CONTENTTYPE='3'
SELECT * FROM cms_1_pictures WHERE CONTENTID='14' AND MAIN='1' AND CONTENTTYPE='3'
SELECT * FROM cms_1_pictures WHERE CONTENTID='25' AND MAIN='1' AND CONTENTTYPE='3'
SELECT * FROM cms_1_pictures WHERE CONTENTID='11' AND MAIN='1' AND CONTENTTYPE='3'
SELECT * FROM cms_1_pictures WHERE CONTENTID='2' AND MAIN='1' AND CONTENTTYPE='3'
SELECT * FROM cms_1_pictures WHERE CONTENTID='5' AND MAIN='1' AND CONTENTTYPE='3'
SELECT * FROM cms_1_pictures WHERE CONTENTID='28' AND MAIN='1' AND CONTENTTYPE='3'
SELECT * FROM cms_1_calendar_en WHERE ACTIVE='1' AND EVENTDATE>NOW() ORDER BY EVENTDATE ASC LIMIT 3
SELECT * FROM cms_1_pictures WHERE CONTENTID='1' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_contents_en WHERE ACTIVE='1' AND MODULE='home' AND SUB='0'
Rost Andrea honlapja | 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"

Radiant talents break down walls and build bridges between the music and the audience.

Programs

April 27

Andrea Rost's aria evening

Zsinagóga

April 28

"Gyökérből rügyfakadás” - Herendi porcelán kiállítás ünnepélyes megnyitója

Zsinagóga

May 18

Hannfried Lucke and Andrea Rost's concert

Zeneakadémia

ARTISTS:Hannfried Lucke - organAndrea Rost - sopranoPROGRAMME:Liszt: 'Lob und Ehre und Preis...

Download Press Kit

Bio + Works + Photos

DEVELOPER BAR