SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Mr Lampe"/1) | (@(roleclean,performerclean) "Mr Lampe")') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=100, commentpclean=75, commentcclean=75, roleclean=100, performerclean=100, authnameclean=100), ranker=sph04

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?
We found 4270 matches on Event Comments, 1340 matches on Performance Comments, 555 matches on Performance Title, 18 matches on Author, and 6 matches on Roles/Actors.

Performances

Mainpiece Title: The Funeral

Afterpiece Title: La Guinquette

Afterpiece Title: Dido and Aeneas

Performances

Mainpiece Title: The Royal Shepherd

Dance: TThe Faggot Binders, as17640301 Dance, as17640301

Performances

Mainpiece Title: The Royal Shepherd

Dance: TThe Faggot Binders, as17640301 Dance, as17640301

Performances

Mainpiece Title: The Royal Shepherd

Dance: I: New Dance call'd The Sheep Shearers-Grimaldi, Miss Baker; II: The Faggot Binders, as17640224; End Opera: A Dance, as17640224

Performances

Mainpiece Title: The Royal Shepherd

Dance: The Sheep Shearers, as17640308 The Faggot Binders, as17640308 Dance, as17640308

Performances

Mainpiece Title: The Royal Shepherd

Dance: I: The Sheep Shearers, as17640308 but _Grimaldi, Lauchery; II: The +Shepherdesses, as17640113; End Opera: A Dance, as17640301 but _Grimaldi, Tassoni

Performances

Mainpiece Title: Alonzo

Afterpiece Title: A Peep behind the Curtain

Performances

Mainpiece Title: Alexander The Great; Or, The Rival Queens

Afterpiece Title: The Miller of Mansfield

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as 18 Sept

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: The Poor Soldier

Song: End: The Waggoner (composed by Dibdin)-Wathen

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: May Day

Performances

Mainpiece Title: The Wives Revenged

Afterpiece Title: Man and Wife

Afterpiece Title: Poor Vulcan

Dance: End of 2nd piece The Poney Races, as17840504

Song: Procession to conclude with a new Theatrical Glee, composed by Shield, by Reinhold, Brett, Johnstone

Performances

Mainpiece Title: The Runaway

Afterpiece Title: The Gentle Shepherd

Dance: End: L'Amour au Rende'vous; or, The Conflict of Love, in which will be displayed the Customs of the American Indians, to conclude with the War Dance,-the young D'Egvilles, Miss Blanchet, Miss D'Egville, Miss DeCamp; End I afterpiece: A Highland Reel-the young D'Egvilles, Miss Blanchet, Miss DeCamp

Performances

Mainpiece Title: The Hypocrite

Afterpiece Title: The Institution of the Garter

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Witches

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: A Peep behind the Curtain

Dance: V: Comic Dance, as17720922

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Lottery

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Comus

Dance: As17780211

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Comus

Song: In afterpiece: Sweet Echo-Leoni, Mrs Farrell (of cg)

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Catherine And Petruchio

Dance: As17791022

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Tom Thumb

Dance: As17801027

Performances

Mainpiece Title: the Feast Of Thalia; Or, A Dramatic Olio

Afterpiece Title: First Course, a substantial Dish from: Henry IV

Afterpiece Title: Second Courae, a Comic Dish, never serv'd up before: Kensington Gardens; or, The Walking Jockey

Afterpiece Title: Third Course, an Operatic Dish: The Son-in-Law

Afterpiece Title: Also by way of Entremet: Ripe Fruit; or, The Marriage Act

Afterpiece Title: Desert: Tom Thumb

Song: In Second Course: Auld Robin Gray-Miss Harper

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: The Son-in-Law

Dance: As17811101