This is my query:
SELECT username, trust_level, last_seen_at from users WHERE trust_level_locked = true AND trust_level != 4 GROUP BY users.trust_level, users.last_seen_at, users.username ORDER BY trust_level asc
It returns a list among which, 821 TL1s. < groan >
If I understand correctly, that’s because we assign customers to TL1 even if they haven’t earned it, so there’s some sort of auto-lock going on.
So I start working my way through the list to unlock them.
I unlock several and re-run the query.
Everyone I’ve unlocked still shows up on the query results. I’ve double-checked, each profile in admin/users/ is unlocked.
How do I write a query that will show me only those users whose trust level is currently locked?