SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Sacred Canons"/1)') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Music: End of Part II concerto on the organ by C. Wesley (1st appearance in public)

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Music: End of Part II concerto on the organ by J. Ashley

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred

Music: Principal Vocal Performers, Leader, Organ omitted, but see17940307ART I. As17940312but added: Holy, holy Lord; omitted: o worse than death and Angels ever bright. PART II. As17940312but Eighth Concerto of Corelli in place of Eleventh Grand Concerto; omitted: O sleep. PART III. As17940312athi

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Music: End of Part II concerto on the violin by Giornovichi

Performances

Mainpiece Title: A Grand Selection Of Sacred

Music: As17940326athi

Performances

Mainpiece Title: Redemption: A Sacred Oratorio Selected From The Great And Favourite Works Of Handel

Music: As17940409

Performances

Mainpiece Title: A Grand Selection Of Sacred

Music: Principal Vocal Performers, Leader, Organ as17940307ART I. As17940326but added: He was eyes unto the blind; also O worse than death; Angels ever bright (THEODORA); omitted: Grateful hearts; For joys so vast; Happy they. PART II. As17940326but 6th violin concerto (composed by Giardini) by G. Ashley in place of Fourth Organ Concerto; added: Sweet Bird, accompanied on the violin by G. Ashley (L'ALLEGRO); also He rebuked the Red Sea (ISRAEL IN EGYPT); also In sweetest harmony; O fatal day (SAUL); omitted: He was eyes; He led them thro'; Ye sons of Israel; Weep, Israel, weep. PART III. As17940326but added to O liberty: accompanied on the violoncello by C. Ashley; to Let the bright: accompanied on the trumpet by Sarjant; also Sin not O King (SAUL); also So when the last (DRYDEN'S ODE); omitted: O beauteous Queen; The dead shall live

Performances

Mainpiece Title: A Grand Selection 0 Main Of Sacred Music, From The Works Of handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music Chiefly From handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music From The Works Of handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: In Part II: 1st concerto [of Geminiani]-G. Ashley

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: 6th concerto of Giordani on the violin-C. Ashley

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music Chiefly From The Works Of handel; Debora And Sisara

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part II: violin concerto by Giardini-G. Ashley

Performances

Mainpiece Title: A Grand Selection 0of Sacred Music From The Works Of handel; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music From The Works Of Handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part I: concerto on the violincello-C. Ashley; End Part II: concerto on the harp-Mme Delaval

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music From The Works Of Handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17960219

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music From The Works Of Handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part II: concerto on the harp-Mme Delaval