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