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

Performances

Mainpiece Title: The Farmer

Afterpiece Title: The Midnight Hour

Afterpiece Title: Aladin

Cast
Role: Pierrot Actor: Delpini

Performances

Mainpiece Title: The Death Of Captain Cook

Afterpiece Title: The Pharo Table

Afterpiece Title: Aladin

Cast
Role: Pierrot Actor: Delpini

Performances

Mainpiece Title: He Wou'd Be A Soldier

Afterpiece Title: Aladin

Cast
Role: Pierrot Actor: Delpini

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Dance: As17890101

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: Marian

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: The Little Hunchback

Performances

Mainpiece Title: Rosina

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: The Little Hunchback

Performances

Mainpiece Title: The Farmer

Afterpiece Title: The Child of Nature

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Dance: As17890101

Performances

Mainpiece Title: The Prophet

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: The Highland Reel

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Dance: As17890101

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Dance: End IV: Fortune's Favor-Byrn, Mrs Goodwin, Mrs Ratchford

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: Marian

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: Annette and Lubin

Dance: As17890101

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: The Cheats of Scapin

Performances

Mainpiece Title: Fontainbleau

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: Annette and Lubin

Song: As17890520

Performances

Mainpiece Title: The Comedy Of Errors

Afterpiece Title: The Feast of Anacreon

Afterpiece Title: The Cheats of Scapin

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: Tom Thumb

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: Annette and Lubin

Performances

Mainpiece Title: The Giant Defeated; Or, The Reward Of Valour

Afterpiece Title: The Child of Nature

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pierrot Actor: Delpini

Song: End 2nd piece: Poor Thomas Day-Edwin, Davies, Bannister

Performances

Mainpiece Title: The Brothers

Afterpiece Title: The Farmer

Cast
Role: Pierrot Actor: Delpini

Ballet: End: The Wapping Landlady. Jack in Distress-Blurton; Orange Woman-Mrs Watts; Landlady-Mr King

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: The Touchstone

Cast
Role: Pierrot Actor: Reeve

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: The Picture of Paris

Cast
Role: Pierrot Actor: Follett

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett