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

;