SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Lallegro Ii Penseroso"/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 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: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Conquest Of Granada, Part Ii

Performances

Mainpiece Title: The Conquest Of Granada, Part Ii

Performances

Mainpiece Title: The Conquest Of Granada, Part Ii

Performances

Mainpiece Title: The Conquest Of Granada, Part Ii

Performances

Mainpiece Title: The Conquest Of Granada, Part Ii

Performances

Mainpiece Title: The Destruction Of Jerusalem By Titus Vespasian, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Rover, Part Ii

Performances

Mainpiece Title: The Destruction Of Jerusalem By Titus Vespasian, Part Ii

Performances

Mainpiece Title: The Destruction Of Jerusalem, Part Ii

Performances

Mainpiece Title: The Comical History Of Don Quixote, Part Ii

Performances

Mainpiece Title: Aesop, Part Ii

Performances

Mainpiece Title: Love Makes A Man

Dance: End II: a French Scaramouch-