SQL
x
USE trwiki_p;
SELECT zirt.user_name as k, datediff(NOW(),zirt.zaman) as fark
FROM (SELECT *, now() as zaman
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
LEFT JOIN ipblocks
ON ipb_user =latest.rev_user) as zirt limit 10;
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.