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_id = 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

;