SQL
AخA
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT ipb_address, page_title, fr_page_id, rev_page, fr_rev_id, ipb_expiry, rev_user_text,rev_comment,rev_deleted,rev_len,rev_parent_id,rev_timestamp, fr_timestamp, fr_flags
FROM
flaggedrevs JOIN
ipblocks on ipb_user = fr_user
JOIN revision on rev_id = fr_rev_id
JOIN page on page_id = rev_page
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.