The developer wrote this pretty little query to show us which accounts are up for review (which in our case means they have a “30” flag).
SELECT account, balance, 'For review' AS [status]
FROM #accounts WHERE account IN (SELECT account FROM #accountFlags WHERE flag=30) ORDER BY account;
Did you spot it?
I did, but in fairness, I’ve been burned enough times by this that I check for it.