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: Rosina

Afterpiece Title: MY GRANDMOTHER

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: THE PURSE

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett

Performances

Mainpiece Title: Rosina

Afterpiece Title: MY GRANDMOTHER

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: THE PURSE

Performances

Mainpiece Title: The Citizen

Afterpiece Title: THE FIRST FLOOR

Afterpiece Title: HARLEQUIN PEASANT

Cast
Role: Pierrot Actor: Delpini

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett

Performances

Mainpiece Title: Rosina

Afterpiece Title: MY GRANDMOTHER

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: THE CHILDREN IN THE WOOD

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett

Performances

Mainpiece Title: The Tender Husband; Or, The Accomplished Fools

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett

Performances

Mainpiece Title: The Life And Death Of King Richard The Iiid

Afterpiece Title: MY GRANDMOTHER

Cast
Role: Pierrot Actor: Delpini

Performances

Mainpiece Title: The Box-lobby Challenge

Afterpiece Title: ROSINA

Cast
Role: Pierrot Actor: Delpini

Performances

Mainpiece Title: The Box-lobby Challenge

Afterpiece Title: MY GRANDMOTHER

Cast
Role: Pierrot Actor: Delpini

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett

Dance: As17940225

Performances

Mainpiece Title: Rosina

Afterpiece Title: MY GRANDMOTHER

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: THE CHILDREN IN THE WOOD

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett

Performances

Mainpiece Title: Rosina

Afterpiece Title: MY GRANDMOTHER

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: THE CHILDREN IN THE WOOD

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett

Dance: As17940225

Performances

Mainpiece Title: The Quaker

Afterpiece Title: MY GRANDMOTHER

Cast
Role: Pierrot Actor: Delpini

Afterpiece Title: THE CHILDREN IN THE WOOD

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett

Performances

Mainpiece Title: The Prodigal

Afterpiece Title: THE HAUNTED TOWER

Afterpiece Title: THE PURSE

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett

Dance: As17940225

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: THE HAUNTED TOWER

Afterpiece Title: THE CITIZEN

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: THE SAILOR'S FESTIVAL; or, All Alive at Portsmouth

Afterpiece Title: MARIAN

Cast
Role: Pierrot Actor: Follett

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett

Dance: As17940225

Performances

Mainpiece Title: King Lear

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pierrot Actor: Follett