SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Chelsea Pensioner"/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: Fatal Falshood

Afterpiece Title: The Chelsea-Pensioner

Performances

Mainpiece Title: Fatal Falshood

Afterpiece Title: The Chelsea-Pensioner

Performances

Mainpiece Title: Fatal Falshood

Afterpiece Title: The Chelsea-Pensioner

Performances

Mainpiece Title: Fatal Falshood

Afterpiece Title: The Chelsea-Pensioner

Performances

Mainpiece Title: La Frascatana

Dance: End I: an entire new ballet, composed by Didelot, La Bonte du Seigneur-[see17880531]; End Opera: [an entire new ballet in 5 acts, Richard Coeur de Lion [also composed by Didelot] [in which-Sga Perez[, pensioner to the Duke of Parma,

Music: II 2nd ballet: will be introduced a new French instrument, Le Cistre-Lefevre; End IV: concerto on French Horn-Ponto who will likewise accompany the principal dancers last Act

Performances

Mainpiece Title: The College Of Physicians; Or, Doctor Last's Examination

Afterpiece Title: The Heiress

Afterpiece Title: The Doctor and the Apothecary

Song: End II 2nd piece: The Greenwich Pensioner-Dignum

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Piety in Pattens

Afterpiece Title: The Quaker

Song: End II: The Lass of Richmond Hill (composed by Hook)-Dignum; End IV: The Greenwich Pensioner-Dignum; End: Poor Jack-Dignum

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: Piety in Pattens

Afterpiece Title: Miss in her Teens

Song: In course: a song-Miss Barnes; The Greenwich Pensioner-Dignum

Entertainment: Vaudeville. End: an Epilogue in the character of Harlequin-Banks

Performances

Mainpiece Title: Oroonoko

Afterpiece Title: The Doctor and the Apothecary

Dance: As17900308

Song: End II: The Greenwich Pensioner-Dignum; End IV: Poor Jack-Dignum

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: The Spoil'd Child

Song: End I: When on board our trim Vessel-Cooke (composed by Carter); End IV: Chelsea Quarters (composed by Schroeder)-Cooke

Entertainment: Imitations. End: a Variety of Imitations-Caulfield

Ballet: Following Imitations: The Scotch Ghost. As17961221