SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "La Costanza Di Rosinella"/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: The Committee

Afterpiece Title: The Padlock

Song: III: Moody will introduce the Celebrated song in Love a@la@Mode-Moody

Dance: End: As17700428

Performances

Mainpiece Title: The West Indian

Afterpiece Title: The Deserter

Song: II: (By Desire) the Song from Love a@la@Mode-Moody

Dance: End Entertainment: The Irish Fair, as17730918

Monologue: Between Play and Entertainment: (By Desire and for the last time this season) Linco's Travels. As 14 March

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Country Madcap

Dance: End: A New Comic Dance, call'd The Portraits A@la@Mode-Dagueville, Helme, Sga Vidini

Performances

Mainpiece Title: The West Indian

Afterpiece Title: The Jubilee

Song: I: Moody (By Desire) will introduce the song in Love a@la@Mode-Moody