Poznáte Beethovena?Do you know Mr. Beethoven?

select DISTINCT cf.fid as fid, cf.f_name as f_name, cfepc.f_ord from c_co_rel ccr LEFT join c_perf_co cpc ON cpc.co_id = ccr.co_id LEFT JOIN c_functions_extra_perf_co cfepc ON cfepc.co_id_r = cpc.id LEFT JOIN c_functions cf on cf.f_id = cfepc.fid WHERE cpc.c_id = 285 and cpc.p_id = 333 and not isnull(cf.fid) AND (ccr.co_database_only !=1 OR isnull(ccr.co_database_only)) UNION select cf.fid, cf.f_name, cfe.f_ord from c_perf_rel cpr left join c_perf_co cpc ON cpc.p_id = cpr.p_id and cpc.c_id =cpr.c_id left join c_functions_extra cfe ON cfe.p_id = cpr.p_id and cfe.c_id = cpr.c_id LEFT JOIN c_functions cf on cf.fid = cfe.fid WHERE cpr.c_id = 285 and cpr.p_id = 333 and isnull(cpc.p_id) ORDER by f_ord select DISTINCT cf.fid as fid, cf.f_name as f_name, cfepc.f_ord from c_co_rel ccr LEFT join c_perf_co cpc ON cpc.co_id = ccr.co_id LEFT JOIN c_functions_extra_perf_co cfepc ON cfepc.co_id_r = cpc.id LEFT JOIN c_functions cf on cf.f_id = cfepc.fid WHERE cpc.c_id = 285 and cpc.p_id = 4 and not isnull(cf.fid) AND (ccr.co_database_only !=1 OR isnull(ccr.co_database_only)) UNION select cf.fid, cf.f_name, cfe.f_ord from c_perf_rel cpr left join c_perf_co cpc ON cpc.p_id = cpr.p_id and cpc.c_id =cpr.c_id left join c_functions_extra cfe ON cfe.p_id = cpr.p_id and cfe.c_id = cpr.c_id LEFT JOIN c_functions cf on cf.fid = cfe.fid WHERE cpr.c_id = 285 and cpr.p_id = 4 and isnull(cpc.p_id) ORDER by f_ord

Program

Ludwig van Beethoven (1770–1827)

Symfónia č. 5 c mol „Osudová“, op. 67 – Allegro con brio Symphony No. 5 C minor, “Fate”, Op. 67 – Allegro con brio

Bagatela č. 25 a mol „Pre Elišku“ Bagatelle No. 25 in A minor “Für Elise”

Symfónia č. 7 A dur, op. 92 – Allegretto Symphony No.7 in A major, Op. 92 – Allegretto

Symfónia č. 9 d mol, op. 125, s Ódou na radosť – Presto – Allegro molto assai (Alla marcia) – Andante maestoso – Allegro energico, sempre ben marcato Symphony No. 9 in D Minor, Op. 125, Choral Ode to Joy – Presto – Allegro molto assai (Alla marcia) – Andante maestoso – Allegro energico, sempre ben marcato

Symfónia č. 7 A dur, op. 92 – Presto – Assai meno presto (trio) Symphony No.7 in A major, Op. 92 – Presto – Assai meno presto (trio)

Sonáta pre klavír č. 14 cis mol, op. 27 č. 2, „Quasi una fantasia“ – Adagio sostenuto Piano Sonata No. 14.in C sharp minor, Op. 27 No. 2, “Quasi una fantasia” – Adagio sostenuto

Symfónia č. 7 A dur, op. 92 – Allegro con brio Symphony No.7 in A major, Op. 92 – Allegro con brio