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

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Miss in Her Teens

Dance: IV: Country Amusements-Devisse, Mlle Auretti; End: A Hornpipe-Mathews, the Little Swiss

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: Othello The Moor Of Venice

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: The Twin Rivals

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: Volpone; Or, The Fox

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: L'amanti Gelosi

Dance: [Unspecified.]

Performances

Mainpiece Title: Entertainment Of Vocal And Instrumental Music

Performances

Mainpiece Title: Attilio Regolo

Performances

Mainpiece Title: Eliza

Performances

Mainpiece Title: The Funeral; Or, Grief A-la-mode

Afterpiece Title: The Double Disappointment

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The King and Miller

Performances

Mainpiece Title: L'arcadia In Brenta

Performances

Mainpiece Title: Coriolanus; Or, The Roman Matron

Performances

Mainpiece Title: Penelope

Performances

Mainpiece Title: L'olimpiade

Performances

Mainpiece Title: Merope

Afterpiece Title: a new farce call'dLa new farce call'dLilliput

Performances

Mainpiece Title: None

Performances

Mainpiece Title: Merope

Afterpiece Title: The Author

Performances

Mainpiece Title: Solimano

Dance: Signora Forti, Signora Bonomi, Grimaldi, Signora Lescot

Performances

Mainpiece Title: The Roman Father

Afterpiece Title: The Englishman in Paris

Performances

Mainpiece Title: Belshazzar

Performances

Mainpiece Title: Jeptha

Performances

Mainpiece Title: The Messiah

Performances

Mainpiece Title: Acis And Galatea

Music: First Violin-Brown; Second Violin-Froud; First Violoncello-Gordon; Harpsichord-Cooke; Between I and II: a Concerto on Hautboy-Vincent

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Anatomist

Dance: I: A comic Dance call'd The German Hunters-Master Settree, Miss Twist