SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,authname,perftitleclean,commentcclean,commentpclean) "Mr La Riche"/1) | (@(roleclean,performerclean) "Mr La Riche")') 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 4364 matches on Event Comments, 2822 matches on Performance Title, 1498 matches on Performance Comments, 22 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: The English Merchant

Afterpiece Title: The Hermit

Performances

Mainpiece Title: The English Merchant

Afterpiece Title: Harlequin Dr Faustus

Dance: III: The Irish Lilt, as17670921

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Statesman Foild

Dance: As17680530

Performances

Mainpiece Title: The English Merchant

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: The English Merchant

Afterpiece Title: Harlequin Skeleton

Performances

Mainpiece Title: The English Merchant

Afterpiece Title: Harlequin Dr Faustus

Dance: III: The Wapping Landlady, Double Hornpipe, as17690408

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Cooper

Dance: As17730630

Performances

Mainpiece Title: The Fashionable Lover

Afterpiece Title: The Genii

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Register Office

Performances

Mainpiece Title: The Fashionable Lover

Afterpiece Title: A Peep behind the Curtain

Dance: End: The Lilliputian Camp-, not performed these 6 years

Performances

Mainpiece Title: All For Love

Afterpiece Title: High Life below Stairs

Dance: End: The Grand Garland Dance, as17760311

Performances

Mainpiece Title: The Rivals

Afterpiece Title: The Man of Quality

Dance: End: Mirth and Jollity, as17760102

Performances

Mainpiece Title: News From Parnassus

Afterpiece Title: She Stoops to Conquer

Afterpiece Title: The Padlock

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: The Mock Doctor

Dance: As17761123

Performances

Mainpiece Title: Alcina

Dance: As17770313

Song: With the Alterations of two new songs-Sga Sestini; a favourite one-Sga Sestini

Performances

Mainpiece Title: The Advertisement Or A Bold Stroke For A Husband

Afterpiece Title: The Citizen

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Comus

Song: Afterpiece: Sweet Echo-Leoni, Mrs Farrell. [This was sung, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: The Rival Queens Or The Death Of Alexander The Great

Afterpiece Title: True Blue

Afterpiece Title: The Commissary

Dance: End 2nd piece: The Poney Races, as17780421

Song: As17780511

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: The Medley or Harlequin At All

Dance: Afterpiece: The dances-Aldridge, Dagueville, Miss Valois. [These were danced, as here assigned, in all subsequent Performances.

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: A Peep behind the Curtain

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Farmers Return from London

Afterpiece Title: Gallic Gratitude or The Frenchman in India

Song: In 3rd piece: the Vocal Parts-Reinhold, Miss Thornton, Mrs Wrighten

Performances

Mainpiece Title: The English Merchant

Afterpiece Title: The Citizen

Dance: As17790610

Performances

Mainpiece Title: The Wives Revenged

Afterpiece Title: Know Your Own Mind

Afterpiece Title: The Touchstone

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Tom Thumb

Performances

Mainpiece Title: The English Merchant

Afterpiece Title: The Silver Tankard or The Point at Portsmouth