Worked out how to get it; I'll be able to get the list to you de-duped, but working out what their "native" wiki is is...not an easy task.

Thank you. Rather than seeing you add the Epic tag to this task, I'll probably live anyway if I can only deliver to their mw.org talk pages.

Doesn't look right? This user, for example, is a regular there, and he's not on the list.

Thaat's interesting. Hrm.

Okay, this is REALLY WEIRD. @werdna how the heck does this setup work?

At the moment I'm running:

SELECT th_user_text AS username, COUNT(*) AS edits FROM thread_history WHERE th_id IN(SELECT DISTINCT(thread_id) FROM thread WHERE thread_article_title = 'VisualEditor/Feedback')
AND th_user > 0 AND th_user_text NOT LIKE('%WMF%') GROUP BY th_user_text ORDER BY COUNT(*) DESC;

And it's missing a ton of users.

I dunno, have the pages been moved around a lot? You might also want to check thread_article_id (WHERE thread_article_title=X OR thread_article_id=X).

Check the Threads::articleClause method for the "correct" way to see if a thread is on a particular talk page.

Yeah, I've been using *_id too; same problem. This is really weird :/.

Yo, @Halfak, do you have any ideas for this task? Thanks!

Sorry. I've never done any analysis of LQT before.

@Ironholds I'm happy to play with this with you if we get a chance.

Sure; how/when/etc?

I have data! Because Werdna is werdnaful :D.

(Elitre: the user you highlighted isn't in the set because they're in the "switched" dataset, looks like)