example query

gistfile1.txt

SELECT DISTINCT(rc_user_text) AS bfuser,
               user_editcount AS edits,
               min(rev_timestamp) AS firstedit
               FROM recentchanges INNER JOIN user ON rc_user = user_id
               INNER JOIN revision ON rc_user = rev_user
               WHERE rc_type IN (1,0)
               AND rc_bot = 0
               AND rc_user > 0
               GROUP BY bfuser