SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Ambrose Philips"/1) | (@(roleclean,performerclean) "Ambrose Philips")') 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 1001 matches on Author, 702 matches on Performance Comments, 89 matches on Event Comments, 80 matches on Performance Title, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: Love His Own Rival

Afterpiece Title: Trick Upon Trick

Dance: As17430509

Performances

Mainpiece Title: The Cruel Uncle; Or, Usurping Monarch

Afterpiece Title: Trick upon Trick

Song: New Song-Johnson upon the glorious Victory at Dettingen

Dance: Morris Dancers

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Lying Valet

Dance: As17451028

Performances

Mainpiece Title: The Intriguing Footman; Or, Jack Spaniard Bit

Afterpiece Title: Trick upon Trick

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: A Duke and no Duke

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Intriguing Chambermaid

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Chaplet

Dance: Devisse, Mad Auretti

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Devil to Pay

Dance: As17521219

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: Harlequin Dr Faustus

Dance: (BBy Particular Desire )Les Charboniers, as17521028; Il Pastore, as17521219

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Oracle

Dance: IIl Pastore, as17521219; Les Sabotiers Tyrolese, as17521028

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Oracle

Dance: II: A Grand Ballet-Devisse, Mlle Auguste; V: L'Entree de Flore, as17521122, but Janeton Auretti seems to replace Mrs Preston

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The What D'ye Call It

Music: Piece on the Welch Harp-Parry

Dance: GGrand Scots Ballet, as17521216

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Lottery

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Devil to Pay

Dance: Entertainments-LeFevre, Mlle Prud'homme, Devisse, Mlle Auguste

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The King and the Miller

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Lottery

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: Flora; or, The Country Wake

Dance: IItalian Peasants, as17531120

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: Harlequin Skeleton

Dance: LLes Taileurs, as17531210

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: Harlequin Skeleton

Dance: LLes Savoyards, as17531210; Les Taileurs, as17531210

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: Lethe

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: Harlequin Skeleton

Dance: Maranesi, Sga Bugiani