SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Old Troop; Or Monsieur Raggou"/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: Poor Old Drury

Afterpiece Title: The Rivals

Afterpiece Title: The Spoil'd Child

Performances

Mainpiece Title: Poor Old Drury

Afterpiece Title: As You Like It

Afterpiece Title: The Critic

Song: V 2nd piece: song-Miss Hagley

Performances

Mainpiece Title: Poor Old Drury

Afterpiece Title: Know Your Own Mind

Afterpiece Title: The Romp

Performances

Mainpiece Title: Poor Old Drury

Afterpiece Title: The Country Girl

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: Poor Old Drury

Afterpiece Title: The Haunted Tower

Afterpiece Title: The Liar

Performances

Mainpiece Title: Poor Old Drury

Afterpiece Title: A Trip to Scarborough

Afterpiece Title: Bon Ton; or, High Life above Stairs

Performances

Mainpiece Title: Poor Old Drury

Afterpiece Title: The School for Scandal

Afterpiece Title: No Song No Supper

Song: As17910927

Performances

Mainpiece Title: Poor Old Drury

Afterpiece Title: The Siege of Belgrade

Afterpiece Title: The Citizen

Performances

Mainpiece Title: Poor Old Drury

Afterpiece Title: King Henry the Fifth

Afterpiece Title: Comus

Performances

Mainpiece Title: Poor Old Drury

Afterpiece Title: The Wonder

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: Poor Old Drury

Afterpiece Title: A Trip to Scarborough

Afterpiece Title: Don Juan

Dance: As17911202

Performances

Mainpiece Title: Poor Old Drury

Afterpiece Title: Know Your Own Mind

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: Poor Old Hay-market; Or, Two Sides Of The Gutter

Afterpiece Title: The Young Quaker

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: Poor Old Hay-market

Afterpiece Title: The Battle of Hexham; or, Days of Old

Afterpiece Title: Seeing is Believing

Performances

Mainpiece Title: Poor Old Hay-market

Afterpiece Title: The Battle of Hexham

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: Poor Old Hay-market

Afterpiece Title: The Suicide

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: The Battle of Hexham

Afterpiece Title: Poor Old Hay-Market

Performances

Mainpiece Title: Poor Old Hay-market

Afterpiece Title: The Surrender of Calais

Performances

Mainpiece Title: The Suicide

Afterpiece Title: Young Men, and Old Women

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: Young Men, and Old Women

Performances

Mainpiece Title: I'll Tell You What

Afterpiece Title: Young Men, and Old Women

Performances

Mainpiece Title: The Battle Of Hexham

Afterpiece Title: Poor Old Hay-Market

Performances

Mainpiece Title: Poor Old Hay-market

Afterpiece Title: The Suicide

Afterpiece Title: All in Good Humour

Performances

Mainpiece Title: The Young Quaker

Afterpiece Title: Young Men, and Old Women

Performances

Mainpiece Title: The Battle Of Hexham

Afterpiece Title: Young Men, and Old Women

Dance: End: As17920627