SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Johnstone"/1) | (@(roleclean,performerclean) "Johnstone")') 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 3631 matches on Roles/Actors, 631 matches on Performance Comments, 90 matches on Performance Title, 50 matches on Event Comments, and 7 matches on Author.

Performances

Mainpiece Title: Notoriety

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: The Miser

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Johnstone

Dance: As17911112

Music: As17911024

Performances

Mainpiece Title: The Prussian Festival

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: The Dramatist

Cast
Role: Valentine Actor: Johnstone

Music: As17911122

Performances

Mainpiece Title: The Woodman

Cast
Role: O'Donnel Actor: Johnstone

Afterpiece Title: Animal Magnetism

Performances

Mainpiece Title: The Prussian Festival

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Notoriety

Cast
Role: Captain Patrick Actor: Johnstone

Afterpiece Title: Oscar and Malvina

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Notoriety

Cast
Role: Captain Patrick Actor: Johnstone

Afterpiece Title: Love and War

Cast
Role: Captain Patrick Actor: Johnstone
Role: Farquhar Actor: Johnstone

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Love a-la-Mode

Performances

Mainpiece Title: The Prussian Festival

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Oscar and Malvina

Cast
Role: Captain Patrick Actor: Johnstone

Music: In 3rd piece: The Harp and Pipes-Weippert, Courtney

Performances

Mainpiece Title: The Duenna

Cast
Role: Ferdinand Actor: Johnstone

Afterpiece Title: The Midnight Hour

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Inkle Actor: Johnstone

Afterpiece Title: Blue Beard

Dance: As17911102

Performances

Mainpiece Title: The Duenna

Cast
Role: Ferdinand Actor: Johnstone

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Johnstone

Afterpiece Title: Blue Beard

Dance: As17911112

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Johnstone

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: Notoriety

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: Wild Oats

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: The Woodman

Cast
Role: O'Donnel Actor: Johnstone

Afterpiece Title: Blue Beard

Dance: In afterpiece: Byrne, Mlle St.Amand

Performances

Mainpiece Title: Notoriety

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Notoriety

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Notoriety

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Wild Oats

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: The Woodman

Cast
Role: O'Donnel Actor: Johnstone

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Johnstone

Afterpiece Title: Love a-la-Mode

Performances

Mainpiece Title: Notoriety

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Oscar and Malvina

Music: In afterpiece: As17911219

Performances

Mainpiece Title: Wild Oats

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: The Poor Soldier

Cast
Role: Patrick Actor: Johnstone