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: David's Lamentation Over Saul And Jonathan

Performances

Mainpiece Title: Hurlothrumbo

Performances

Mainpiece Title: Comus

Dance: LLe Boufon-the Fausans; Le Genereux Corsaire, as17411021

Performances

Mainpiece Title: Richard Iii

Afterpiece Title: The Mock Doctor

Performances

Mainpiece Title: Penelope

Performances

Mainpiece Title: Penelope

Performances

Mainpiece Title: The Provoked Wife

Afterpiece Title: Miss Lucy in Town

Dance: II: Grand Comic Dance, as17421130; V: Les Moisoneurs de la Styrie-Checo, Signora Chiaretti

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Devil to Pay

Music: I: Concerto on German Flute-Burk Thumoth; IV: Concerto-Piantanida

Song: II: Baard

Performances

Mainpiece Title: The Wedding Day

Performances

Mainpiece Title: Samson

Performances

Mainpiece Title: Sampson

Performances

Mainpiece Title: Messiah

Music: Concerto on Organ-; Violin Solo-DuBourg

Performances

Mainpiece Title: Samson

Music: Concerto on Organ-; Violin Solo-DuBourg

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: The Mourning Bride

Song: II: Song-Sullivan

Dance: III: Dance, as17431013; V: a New Dance-Muilment, Desse, Liviez, Mrs Walter

Performances

Mainpiece Title: Rosalinda

Performances

Mainpiece Title: Saul

Music: Concerto on Organ-

Performances

Mainpiece Title: Aristodemo

Performances

Mainpiece Title: Alceste

Performances

Mainpiece Title: Mahomet

Afterpiece Title: The Amorous Goddess

Performances

Mainpiece Title: Romeo And Juliet

Performances

Mainpiece Title: Cymbeline

Performances

Mainpiece Title: Deborah

Music: Concerto on the Organ-