Got it, thanks Simon. So that answers part of my question! Do you have any suggestions for getting to the root of why the ‘2’ appended to usernames might be happening here.
I have a bunch of these, where name = 'string' and username = 'string2'
But when I run:
SELECT *
FROM users u
WHERE username like '%string%'
Only one result comes back, the one where username is string2. So I don’t know where the conflicting usernames would come in. Could they have been somehow temporarily created then deleted? Or some other reason the ‘2’ might be appended.
Also, can you think of why some of these users could be active and have visits / posts read, but still no SSO data? Maybe from initial visit from confirmation email not requiring the SSO login or something like that?