SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Humourous Lieutenant"/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: The Humorous Lieutenant

Afterpiece Title: Harlequin Skeleton

Dance: As17561216

Performances

Mainpiece Title: The Humorous Lieutenant

Afterpiece Title: Harlequin Skeleton

Dance: As17561216

Performances

Mainpiece Title: The Humorous Lieutenant

Afterpiece Title: Colombine Courtezan; or, Harlequin Restor'd

Dance: II: Fingalian Dance (for 2nd time)-Miss Toogood, apprentice to Lalauze; IV: By Desire a Ball Dance, call'd Queen Caroline, with a Minuet-Miss Toogood, Lalauze; End: A Harlequin Dance-Miss Toogood, 1st time

Performances

Mainpiece Title: The Humourous Physician; Or, A Cure For All Ills

Afterpiece Title: The Restoration and Adventures of Harlequin

Song:

Dance:

Performances

Mainpiece Title: The Humourous Physician

Afterpiece Title: The Restoration and Adventures of Harlequin

Performances

Mainpiece Title: The Humorous Lieutenant

Afterpiece Title: Florizel and Perdita

Dance: [Unspecified in the bill]

Performances

Mainpiece Title: The Humorous Lieutenant

Performances

Mainpiece Title: He Whimsical Battle Of The Greybeards; Or, The Humourous History Of A Covent Garden Adventure; Containing The Ridiculous Behaviour Of shela O'flannegan The First Irish Woman Introduced At Any Fair, The Odd Resentment Of col

Dance: CComic Dance-Signora Florentina, a capital performer from the Opera House at Turin

Performances

Mainpiece Title: The Humorous Lieutenant

Afterpiece Title: Harlequin Dr Faustus

Performances

Mainpiece Title: Alexander The Great

Afterpiece Title: St Patrick's Day; or, The Scheming Lieutenant

Dance: End: The Vintage Festival, as17741007

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: St Patrick's Day; or, The Scheming Lieutenant

Performances

Mainpiece Title: The Knight Of Malta; Or, The Humourous Dane

Afterpiece Title: The Ghost, or, The Devil to do about Her

Dance: As17821231

Song: In the Ceremony, by Reinhold, Mrs Martyr, and others

Performances

Mainpiece Title: The 1st Act Of La Frascatana

Afterpiece Title: The 2nd Act of Gli Schiavi per Amore

Dance: As17880614

Song: In 2nd piece: a Humourous Song in German-Morelli

Ballet: The Deserter. As17880614