SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "A Grand Sacred Selection 0 Messiah 0"/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 Second 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

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Afterpiece Title: The Coronation Anthem

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Afterpiece Title: The Messiah 1

Afterpiece Title: The Messiah 2

Afterpiece Title: The Messiah 3

Song: End Part I: Captivity (supposed to be sung by the unfortunate Marie Antoinette, Queen of France, during her confinement in the Tower of the Temple; composed by Percy)-Master Welsh

Music: End Part II: concerto on the violin-Janiewicz

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Song: End oratorio: Captivity [see17930220]-Incledon

Music: End Part II: the favourite concerto of Geminiani on the violin-G. Ashley

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 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah , Part I; Grand Selection 0

Afterpiece Title: The Resurrection

Afterpiece Title: A New Grand Selection

Song: End 2nd piece: Ye spotted Snakes-(Stevens)

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Music: End Part II: concerto on the Grand Piano Forte-Dussek

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 Chiefly From The Works Of handel; Debora And Sisara

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Performances

Mainpiece Title: The Messiah; Alexander's Feast; Grand Selection 0

Music: End Part I: 3rd concerto of Giardini on the violin-G. Ashley; End Part II: concerto on the Piano Forte-Dussek

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

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 violin-G. Ashley; End Part II: concerto on the Grand Piano Forte-Miss M'Arthur

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Music: End Part I: 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: End Part I: concerto on the Piano Forte-Miss M'Arthur; End Part II: concerto on the harp-Mme Delaval

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Music: End Part I: concerto on the violin-G. Ashley

Performances

Mainpiece Title: Alexander's Feast 0; Or, the Power Of Music Messiah 0

Afterpiece Title: Alexander's Feast 3

Music: Preceding II: concerto for two violins and violoncello obligato- , as originally composed for this Ode by Handel, and performed under his Direction in the year 1736; End II: concerto on the Grand Piano Forte-Dussek

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: L'Allegro ed Il Penseroso 3

Music: End I: concerto on the Grand Piano Forte-Miss MacArthur; End II: concerto on the clarionet-John Mahon

Performances

Mainpiece Title: A Grand Selection 0 From The Most Favourite Works Of Handel; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17980309

Performances

Mainpiece Title: A Grand Selection 0 From The Most Favourite Works Of Handel; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End I: concerto on the oboe-W. Parke; End II: concerto on the violin-G. Ashley

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