SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "A Grand Selection 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 Grand Selection From The Works Of handel 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the violin-Weichsel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900219

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: As17900219; End I: Miserere Mei Deus-, composed by Sg Gregorio Allegri, in the Year 1650, from an authentic Copy brought from Italy by Greatorex. A Translation of this Work (the 51st Psalm in English) will be printed in the Books of the Night

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: As17900224; End Part I: Miserere Mei Deus, as17900317

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900219

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3 Entirely selected from The Messiah

Music: As17900219

Performances

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

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

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Performances

Mainpiece Title: Judas Maccabaeus; Grand Selection 0

Performances

Mainpiece Title: L'allegro Ed Il Penseroso; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: PART III

Performances

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

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast; Grand Selection 0

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: Alexander's Feast 2

Afterpiece Title: PART III

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Performances

Mainpiece Title: Israel In Egypt; Messiah; Grand Selection 0

Afterpiece Title: A New Selection

Performances

Mainpiece Title: The First Act Of Alexander's Feast; Grand Selection 0

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: A Selection from Acis and Galatea

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: Alexander's Feast 0; Redemption 0; L'allegro Ed Il Pensieroso 0

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: Alexander's Feast 2

Afterpiece Title: Grand Miscellaneous Act

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: A Grand Selection 0, Composed By g

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0principally From The Works Of handel; Redemption 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0principally From The Works Of handel; Redemption 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3