SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Alexander Balus"/1)') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: New Concerto on Organ

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: New Concerto on Organ

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Dragon of Wantly

Song: I: Go Rose-Miss Falkner; II: Italian Song-Miss Falkner; III: Softly sweet in Lydian Measures, The Prince unable to conceal his Pain out of the Oratorio of Alexander's Feast-Miss Falkner; IV: Cantata set by Arne-Miss Falkner

Dance: As17510117

Performances

Mainpiece Title: Alexander's Feast

Music: CConcerto-Stanley who is to conduct the performance

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: The Choice of Hercules

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: The Choice of Hercules

Performances

Mainpiece Title: Alexander's Feast

Performances

Mainpiece Title: Mrs Midnight's Rout

Afterpiece Title: La Pantomime du Charpentier

Entertainment: BBurlesque Ode- after the manner of Alexander's Feast

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: The Choice of Hercules

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: The Choice of Hercules

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: Charlottenburg Festeggiante

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Afterpiece Title: The Contrivances

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: Charlottenburg Festegiante

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Afterpiece Title: The Contrivances

Dance: As17561023

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Afterpiece Title: The Devil to Pay

Dance: FFingalian Dance, as17571013

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Afterpiece Title: The Lottery

Dance: As17581111

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Afterpiece Title: Thomasand Sally

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: Beauty and Virtue

Music: I: Concerto on Violincello-Siprutini; II: Concerto on German Flute-Florio

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: Beauty and Virtue

Music: As17620226

Performances

Mainpiece Title: Alexander's Feast

Music: As17620226; Handel's Coronation Anthem-

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Afterpiece Title: Florizel and Perdita

Music: IV: A Solo on the Violin-Mr Piffit (his second performance in England)

Dance: TThe Pleasures of Spring, as17620212

Performances

Mainpiece Title: Alexander's Feast

Music: As17620226; Coronation Anthem-set by Handel

Performances

Mainpiece Title: Alexander's Feast

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Afterpiece Title: The Mock Doctor

Performances

Mainpiece Title: Alexander's Feast

Music: As17630218; Handel's Coronation Anthem-