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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End I: concerto on violin-Master Pinto; End II: concerto on the Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music, From The 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 violoncello-C. Ashley; End II: concerto= on the Piano Forte-Dussek

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End I: Bach's Bach's favourite concertante for flute oboe violin and violoncello-Monzani, W. Parke, G. and C. Ashley

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: The Revenge

Afterpiece Title: No Song No Supper

Song: End: the official news of Nelson's victory at the Nile, on 1 August 1798, was given out; the audience called for Rule Britannia-Kelly, Dignum, Sedgwick, Miss Leak, Mrs Bland; God save the King- [(London Chronicle, 4 Oct.)]

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

Afterpiece Title: Messiah 1

Music: End II: concerto on the Grand 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 II: Bach's concertante for violin oboe viola and violoncello-Messrs [G., R. and C.] Ashley, W. Parke

Performances

Mainpiece Title: 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: As17990213

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 Jealous Wife

Afterpiece Title: Fortune's Frolick

Entertainment: Monologue End: Epilogue pourtraying Characteristick Jealousies of the Spaniard the Italian the Dutchman the Frenchman and the Englishman [by Garrick]-Mrs Mattocks [see cg, 1 May 1798]

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