SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Sandhams Children"/1) | (@(roleclean,performerclean) "Sandhams Children")') 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 591 matches on Performance Title, 241 matches on Performance Comments, 164 matches on Event Comments, 0 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: The Farmer

Afterpiece Title: The Child of Nature

Afterpiece Title: Aladin

Performances

Mainpiece Title: The Farmer

Afterpiece Title: The Child of Nature

Afterpiece Title: Aladin

Performances

Mainpiece Title: Rosina

Afterpiece Title: The Child of Nature

Afterpiece Title: Aladin

Entertainment: Vaudeville. Sparring Match-Ward, Watson

Performances

Mainpiece Title: Love And War

Afterpiece Title: The Child of Nature

Afterpiece Title: The Farmer

Performances

Mainpiece Title: Love And War

Afterpiece Title: The Child of Nature

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Prophet

Afterpiece Title: The Child of Nature

Afterpiece Title: Hide and Seek

Performances

Mainpiece Title: Hide And Seek

Afterpiece Title: The Child of Nature

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: The Death of Captain Cook

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Farmer

Afterpiece Title: The Child of Nature

Afterpiece Title: The Death of Captain Cook

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: The Death of Captain Cook

Afterpiece Title: Marian

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: Poor Vulcan

Afterpiece Title: The Midnight Hour

Performances

Mainpiece Title: The Giant Defeated; Or, The Reward Of Valour

Afterpiece Title: The Child of Nature

Afterpiece Title: The Death of Captain Cook

Song: End 2nd piece: Poor Thomas Day-Edwin, Davies, Bannister

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: The Highland Reel

Afterpiece Title: The Little Hunchback

Performances

Mainpiece Title: The Poor Soldier

Afterpiece Title: The Child of Nature

Afterpiece Title: Harlequin's Chaplet

Dance: As17891221

Performances

Mainpiece Title: Love In Many Masks

Afterpiece Title: The Spoil'd Child

Performances

Mainpiece Title: Love In Many Masks

Afterpiece Title: The Spoil'd Child

Dance: As17900308

Performances

Mainpiece Title: Love In Many Masks

Afterpiece Title: The Spoil'd Child

Dance: As17900308

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: The Spoil'd Child

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: The Busy Body

Afterpiece Title: Thomasand Sally

Dance: As17891128

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Spoil'd Child

Dance: As17891204

Performances

Mainpiece Title: The Crusade

Afterpiece Title: The Child of Nature

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: Modern Breakfast; or, All Asleep at Noon

Afterpiece Title: The Follies of a Day

Dance: End 2nd piece: A Double Hornpipe-Platt, Mrs Goodwin

Performances

Mainpiece Title: The Heiress

Afterpiece Title: The Spoil'd Child

Song: In II: song-Mrs Crouch. [This was sung, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: The Spoil'd Child

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: The Spoil'd Child