SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Apollo Ed Issea"/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: L'allegro Ed Il Pensieroso

Afterpiece Title: L'Allegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: The Double Gallant

Afterpiece Title: The Court of Apollo [i

Afterpiece Title: The Critic

Performances

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

Afterpiece Title: A Grand Miscellaneous Act

Music: As17930220

Performances

Mainpiece Title: L'allegro Ed Il Penseroso [, Part I Only]; Grand Selection 0

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

Song: In 1st piece: Sweet bird-Mrs Ferguson (her 1st performance); accompanied on the violin-Shaw; End 2nd piece: an Italian Scena-Mrs Ferguson

Performances

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

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso

Music: As17940319athi

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso

Music: End of Part II 1st concerto, Op. 3, composed by Geminiani, by G. Ashley

Performances

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

Afterpiece Title: A Grand Miscellaneous Act

Music: End Part II: 3rd concerto of Giardini on the violin-G. Ashley

Performances

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

Afterpiece Title: L'Allegro ed Il Pensieroso 3; Alexander's Feast 3

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

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 Of Sacred Music 0; L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: A Grand Selection of Sacred Music 1

Afterpiece Title: A Grand Selection of Sacred Music 2

Afterpiece Title: A Grand Selection of Sacred Music 3

Music: End I: concerto on the oboe-W. Parke; End II: concerto on Piano Forte-Dussek

Performances

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

Afterpiece Title: Acis and Galatea 3

Music: End I: Handel's 4th concerto on the organ-J. Ashley; End II: concerto on Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: A Grand Selection of Sacred Music 1

Afterpiece Title: A Grand Selection of Sacred Music 2

Afterpiece Title: A Grand Selection of Sacred Music 3

Music: As17970315

Performances

Mainpiece Title: L'allegro [ed] Il Pensieroso 0; Messiah

Afterpiece Title: L'Allegro Il Pensieroso 3