SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "three eldest Princesses"/1) | (@(roleclean,performerclean) "three eldest Princesses")') 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 1260 matches on Event Comments, 484 matches on Performance Title, 175 matches on Performance Comments, 0 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: King Richard Iii

Dance: As17421108

Song: Beard, Lowe

Event Comment: By Command of Their Royal Highnesses the Duke, and Princesses Amelia, Caroline, Louise. Mainpiece: Written by Shakespear,

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Song: II: Song-Beard

Music: Concerto-Piantinada

Dance: IV: Grand Serious Ballet, as17421005

Performances

Mainpiece Title: The Double Dealer

Dance: As17421026

Event Comment: By Command of their Royal Highnesses the Duke, and the Princesses Amelia, Caroline, and Louisa

Performances

Mainpiece Title: King Lear

Dance: II: Grand Comic Dance, as17421117; IV: Les Moisoneurs de la Styrie, as17421122

Performances

Mainpiece Title: Hamlet

Song: I: Beard; III: A Duet-Beard, Lowe

Dance: II: Grand Comic Dance, as17421117; IV: Les Moisoneurs de la Styrie, as17421122

Event Comment: By Command of their Royal Highnesses the Duke, and the Princesses Amelia, Caroline, and Louisa

Performances

Mainpiece Title: Love Makes A Man

Dance: II: Grand Comic Dance, as17421117; IV: Les Moisoneurs de la Styrie, as17421201

Event Comment: By Command of their Royal Highnesses the Duke and the Princesses Amelia, Caroline, and Louisa

Performances

Mainpiece Title: The Rehearsal

Dance: I: Les Moisoneurs de la Styrie, as17421201; III: La Recrue des Houssars, as17421211

Event Comment: BY Command of their Royal Highnesses the Duke, and the Princesses Amelia, Caroline, and Louisa. New Habits and decorations for the dances

Performances

Mainpiece Title: The Stratagem

Dance: II: a New Comic Dance call'd Neopolitan Punch-Checo Torinese, Sga Chiaretta Aquilanti, Boromeo, Mlle Bonneval; IV: A New Comic Dance call'd Italian Gardeners-Checo, Chiaretta

Event Comment: By Command of Their Royal Highnesses the Duke and the Princesses Amelia, Carolina, and Louisa

Performances

Mainpiece Title: Hamlet

Song: As17430103

Music: III: Concerto on Violincello-Cervetti

Event Comment: By Command of their Royal Highnesses the Duke, and the Princesses Amelia, Caroline, and Louisa

Performances

Mainpiece Title: Richard Iii

Song: II, IV: Lowe

Music: III: Concerto on German Flute-Burk Thumoth

Event Comment: By Command of the Duke and the Princesses Amelia, Caroline, and Louisa

Performances

Mainpiece Title: The Stratagem

Dance: As17430120

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: The Necromancer

Performances

Mainpiece Title: The Honest Yorkshireman

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Necromancer

Dance: LLa Provencale, as17421105; Dutch Skipper, as17421025; Peasants, as17421230

Event Comment: By Command of their Highnesses the Duke, and the Princesses Amelia, Caroline, and Louisa

Performances

Mainpiece Title: The Committee

Afterpiece Title: The Devil to Pay

Dance: As17430120

Event Comment: Benefit for a Gentleman in Distress, and by Command of their Royal Highnesses the Duke, and the Princesses Amelia, Caroline, and Louisa

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Mock Doctor

Dance: As17430120

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Lying Valet

Song: IV: Beard

Performances

Mainpiece Title: Richard Iii

Dance: LLes Boufons du Cour, as17430305 Characters of Dancing, as17421108; Grand Ballet, as17421108

Performances

Mainpiece Title: Comus

Afterpiece Title: The Lying Valet

Dance: Boromeo, Desse, Mlle Bonneval

Performances

Mainpiece Title: The Fair Penitent

Dance: DDutch Skipper, as17421025; Characters of Dancing, as17421025; Grand Ballet, as17421108

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The School Boy

Event Comment: By Command of their Royal Highnesses the Duke, and the Princesses Amelia, Caroline, and Louisa

Performances

Mainpiece Title: Venice Preserved

Dance: II: Sicilian Peasant, as17430310 IV: Neopolitan Punch, as17430324

Song: III: Stella and Flaviaa Ballad-Beard

Performances

Mainpiece Title: The Spanish Fryar

Dance: I: Scotch Dance-Delamain, Anne Auretti; II: Tambourine-Anne Auretti; III: Characters of Dancing, as17421025; IV: Un Pas de Deux-Anne and Janneton Auretti; V: L'Aimable Vainqueur, Minuet-Picq, Anne Auretti

Event Comment: By Command of their Royal Highnesses the Duke, and the Princesses Amelia, Caroline, and Louisa

Performances

Mainpiece Title: Jane Shore

Song: As17430120

Music: II: Concerto on German Flute-Burk Thumoth

Dance: IV: Sicilian Peasant, as17430310

Event Comment: By Command of their Royal Highnesses the Princesses Amelia, Caroline, and Louisa

Performances

Mainpiece Title: Richard Iii

Song: As17430413

Dance: III: La Florana, as17430408