SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "2 The Lottery"/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: Grand Selection 0 Of Music, From The Works Of handel, boyce, arne, And purcell

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the violoncello-Charles Ashley

Performances

Mainpiece Title: Grand Selection 0 Of Scared Music, From The Works Of handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: the favourite Military Concerto on the Grand Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Selection 0 Of Music, From The Works Of handel, boyce And purcell

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17990306

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17990215

Performances

Mainpiece Title: The London Hermit

Afterpiece Title: The Spoil'd Child

Afterpiece Title: The Prize; or, 2, 5, 3, 8

Song: End I 2nd piece: The Country Club-Wathen

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: The Prize; or, 2, 5, 3, 8

Performances

Mainpiece Title: 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 II: concerto on the grand piano@forte-Master Neate

Performances

Mainpiece Title: 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 II: concerto on the violoncello-Charles Ashley

Performances

Mainpiece Title: 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 I: sonata on the Grand Piano Forte-Miss Reinagle (1st appearance in public); with accompaniment for flute and violoncello obligata-Woidner, C. Ashley; End II: concerto on violin-G. Ashley

Performances

Mainpiece Title: I Zingari In Fiera

Dance: Between Acts: Divertisement-(1st time); End Opera: a Grand Fairy Ballet in 2 acts, Laura et Lenza; ou, Le Troubadour-all the principal Dancers see18000628