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: At King's The Heiress

Afterpiece Title: Richard Coeur de Lion

Song: Probably as17921016

Performances

Mainpiece Title: At King's The Tempest

Afterpiece Title: Harlequin's Invasion

Dance: In afterpiece: Dances, as17921227

Song: Vocal Parts, as17921213, but Sedgwick, Mrs +Crouch

Opera: Masque of Neptune and Amphitrite. As17921213, but Neptune-Sedgwick

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Harlequin's Museum

Performances

Mainpiece Title: At King's The Haunted Tower

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Performances

Mainpiece Title: At Hay Coriolanus

Afterpiece Title: The Divorce

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Song: End oratorio: Captivity [see17930220]-Incledon

Music: End Part II: the favourite concerto of Geminiani on the violin-G. Ashley

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: Oscar and Malvina

Performances

Mainpiece Title: At Hay The Merchant Of Venice

Afterpiece Title: The Humourist

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Governor; or, The Creolian Insurrection

Performances

Mainpiece Title: At King's The Rival Sisters

Afterpiece Title: The Prisoner

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Relief of Williamstadt; or, The Return from Victory

Afterpiece Title: Hartford Bridge

Dance: In 2nd piece: Byrn, Holland, Mrs Watts, Mme Rossi

Entertainment: Monologue. A new Occasional Address in the character of Goldfinch ,-Lewis

Performances

Mainpiece Title: The Armourer

Afterpiece Title: Lovers' Quarrels

Performances

Mainpiece Title: At Hay The Country Girl

Afterpiece Title: The Pannel

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: The Poor Soldier

Dance: End: The Bouquet, as17930415

Performances

Mainpiece Title: At Hay Othello

Afterpiece Title: The Prize

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Hartford Bridge

Dance: As17930418

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: The Midnight Wanderers

Dance: As17930418

Performances

Mainpiece Title: At Hay The Fair Penitent

Afterpiece Title: The Cheats of Scapin

Performances

Mainpiece Title: At King's Love For Love

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: At King's The Chapter Of Accidents

Afterpiece Title: The Prize

Performances

Mainpiece Title: At Hay The Grecian Daughter

Afterpiece Title: The Prize

Performances

Mainpiece Title: At King's The Gamester

Afterpiece Title: The Romp

Performances

Mainpiece Title: At King's All In The Wrong

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: At King's The School For Scandal

Afterpiece Title: The Mariners

Song: As17921030