SQL
AخA
USE trwiki_p;
SELECT user_name, last_edit, user_editcount, ug_group, ipb_id
FROM (SELECT *, MAX(rev_timestamp) AS last_edit FROM revision WHERE rev_user > 0 GROUP BY rev_user) AS latest
JOIN user
ON user_id = latest.rev_user
JOIN user_groups
ON ug_user = latest.rev_user
JOIN ipblocks
ON ipb_user = latest.rev_user
WHERE user_name ='Monsters60'
LIMIT 200;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.