Thanks Ray - that pointed me in the right direction to look. It was one of those things I knew was working, so didn't immediately think how it could have broken.
I realised now it was from a recent change to allow multiple users be associated with a lodge, when it had been a one-to-many relationship. Where I'd edited the SQL it looks like I had taken out the join to the users table. So all fixed - although I need to revisit it when I have a chance to change it to send that email to multiple users.