SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Mr Champnes"/1) | (@(roleclean,performerclean) "Mr Champnes")') 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 4236 matches on Event Comments, 1226 matches on Performance Comments, 535 matches on Performance Title, 18 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: The Refusal

Afterpiece Title: The Englishman in Paris

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Lying Valet

Dance: II: New Dutch Dance, as17531117; V: Gipsey Tambourine, as17531012

Performances

Mainpiece Title: George Barnwell

Afterpiece Title: Fortunatus

Song: I: Beard

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: Fortunatus

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Chaplet

Dance: III: A Hornpipe-Granier

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Fortunatus

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: Harlequin Skeleton

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: Fortunatus

Performances

Mainpiece Title: Philoclea

Performances

Mainpiece Title: Lo Studente A La Moda

Dance: As17540118

Performances

Mainpiece Title: Philoclea

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Englishman in Paris

Dance: HHornpipe-the Little Swiss

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Knights

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: The Knights

Performances

Mainpiece Title: Constantine

Performances

Mainpiece Title: Admeto

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: The Englishman in Paris

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Harlequin Sorcerer

Dance: LLes Taileurs, as17531210

Performances

Mainpiece Title: Love's Last Shift

Afterpiece Title: The London Prentice

Dance: Devisse, Mlle Auretti

Performances

Mainpiece Title: Ara

Afterpiece Title: The Englishman in Paris

Performances

Mainpiece Title: The Old Woman's Oratory

Performances

Mainpiece Title: Virginia

Afterpiece Title: Lethe

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: The Shepherd's Lottery

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Shepherd's Lottery

Performances

Mainpiece Title: Creusa, Queen Of Athens