SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "C Clarke"/1) | (@(roleclean,performerclean) "C Clarke")') 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 1728 matches on Performance Comments, 1404 matches on Event Comments, 117 matches on Performance Title, 12 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Devil to Pay

Song: I: Let Me Wander not Unseen-Beard; III: Song-Lowe; V: Bumper Squire Jones-Beard

Dance: II: A Dutch Dance-Phillips; IV: The Swiss, as17410926

Performances

Mainpiece Title: The Orphan

Afterpiece Title: The King and Miller of Mansfield

Song: I: Song with French Horns-Beard; II: Sweet Bird from Milton-Mrs Arne; III: A Ballad-Lowe; IV: War he sung was Toil and Trouble-Mrs Clive

Dance: V: A New Running Footman's Dance-Phillips

Performances

Mainpiece Title: Richard Iii

Afterpiece Title: The King and Miller of Mansfield

Song: I: Song with French Horns-Beard; IV: War he sung was Toil and Trouble-Mrs Clive

Dance: III: New Running Footman's Dance-Phillips; V: a Hornpipe-Phillips

Performances

Mainpiece Title: The Orphan

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: Comus

Afterpiece Title: The Mock Doctor

Dance: I: Running Footman's Dance-Phillips; III: The Drunken Peasant-Phillips

Entertainment: AA Lesson on the Welch Harp-Mr Jones

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The King and Miller of Mansfield

Dance: IV: Celladon and Phyllis-Master Matthews, Miss Wright; V: The Medley of Jokes-Master Matthews, Miss Wright

Performances

Mainpiece Title: The Committee; Or, The Faithful Irishman

Dance: II: a New Comic Dance La Mascarada-Brunoro, Borromeo, Mlle Bonneval, Sga Costanza; V: New Comic Dance Les Matelotes-Brunoro, Borromeo, Mlle Bonneval, Sga Constanza

Song: III: Song-Beard

Music: IV: Concerto-Veracini

Performances

Mainpiece Title: The Spanish Fryar

Dance: I: Italian Gardeners, as17421231; III: a New Serious Dance-Sga Aquilanti; V: A New Sicilian Peasant-Checo, Chiaretta

Performances

Mainpiece Title: Hamlet

Dance: TThe Happy Lovers, as17421006; Characters of Dancing, as17421025; Grand Comic Ballet, as17430407

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Virgin Unmask'd

Dance: DDutch Skipper, as17421025; Grand Comic Ballet, as17430407 Le Rendezvous Gallant, as17421217

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: Joseph And His Brethren

Music: Concerto on Organ-

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: The Jovial Crew

Dance: Muilment, Mrs Auguste

Song: BBritons Strike Home-

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Lying Valet

Song: I, IV: Morland

Dance: III: Mlle Auguste

Performances

Mainpiece Title: Mahomet

Afterpiece Title: The School Boy

Song: Lowe

Dance: Muilment

Performances

Mainpiece Title: Alfred The Great

Music: I: a Concerto new by Arne on the Violin-Gordon; II: a Concerto on the Organ-Burgess

Performances

Mainpiece Title: Lady's Last Stake

Afterpiece Title: Orpheus and Eurydice

Dance: SScotch Dance, as17441012; Louvre, Minuet-Villeneuve, Mrs Delagarde

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Tragedy of Tragedies

Dance: I: Sga Bettini; III: Muilment

Song: II: Lowe; V: Nanny O (By Desire)-Lowe

Performances

Mainpiece Title: The Relapse

Song: I: Leveridge; II: Song of Diana, as17460313 IV: New Ballad Mirth gives Courage-Leveridge; V: The Wisdom of the Ancients-Leveridge

Dance: II: Drunken Tyrolese, as17460405 V: The Peasants, as17460405

Performances

Mainpiece Title: The Lying Lover

Afterpiece Title: The Anatomist

Song: II: Cantata-Lowe; IV: Colin and Phebe-Lowe, Miss Edwards

Performances

Mainpiece Title: The Humours Of The Army

Afterpiece Title: The Anatomist

Performances

Mainpiece Title: The Lady's Last Stake

Afterpiece Title: Orpheus and Eurydice

Dance: DDrunken Tyrolese-Sodi; being last time of his performing. Also dancing-Cooke, Sga Campioni=

Performances

Mainpiece Title: The Lying Lover

Afterpiece Title: The Anatomist

Song: Bibby

Dance: The Mechels