SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "1 The Lying Valet"/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 Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: 6th concerto of Giordani on the violin-C. Ashley

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music Chiefly From The Works Of handel Debora And Sisara

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part II: violin concerto by Giardini-G. Ashley

Performances

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

Afterpiece Title: Grand Selection 1

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

Music: End Part I: concerto on the violincello-C. Ashley; End Part II: concerto on the harp-Mme Delaval

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: As17960219

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 Part II: concerto on the harp-Mme Delaval

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 Part I: concerto on the violin-G. Ashley; End Part II: concerto on the Grand Piano Forte-Miss M'Arthur

Performances

Mainpiece Title: Speculation

Afterpiece Title: Harlequins Treasure 0 or Jewels New Set

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

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 Part I: concerto on the Piano Forte-Miss M'Arthur; End Part II: concerto on the harp-Mme Delaval

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Performances

Mainpiece Title: The Lie Of The Day Or A Party At Hampton Court

Afterpiece Title: Catharine and Petruchio

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Performances

Mainpiece Title: Speculation

Afterpiece Title: Harlequin Captive

Song: As17960312

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Performances

Mainpiece Title: The Lie Of The Day

Afterpiece Title: Lock and Key

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Performances

Mainpiece Title: The Lie Of The Day

Afterpiece Title: Lock and Key

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Performances

Mainpiece Title: The Lad Of The Hills

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Performances

Mainpiece Title: King Henry The Fourth First Part

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Performances

Mainpiece Title: The Widow Of Malabar

Afterpiece Title: The Doldrum

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Performances

Mainpiece Title: King Henry The Fourth First Part

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2

Song: End: An Ode, selected from Ben Jonson, as17960516

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequins Treasure 0

Afterpiece Title: Harlequins Treasure 1

Afterpiece Title: Harlequins Treasure 2