Extension:FlaggedRevs

SQL

desc flaggedpages;
 /*
select flaggedpage_pending.*, page.page_title from flaggedpage_pending
inner join page on page.page_id = flaggedpage_pending.fpp_page_id
where fpp_page_id in (3711625)
limit 10;
*/
/*
select flaggedrevs.*,user.user_name from flaggedrevs
inner join user on flaggedrevs.fr_user = user.user_id
where fr_page_id in (3711625)
order by fr_timestamp
*/

/*
select flaggedrevs_promote.*,user.user_name from flaggedrevs_promote 
inner join user on flaggedrevs_promote.frp_user_id = user.user_id
where user_name in ("لوقا")
limit 10;
*/

select flaggedpages.*,page.page_title from flaggedpages 
inner join page on page.page_id = flaggedpages.fp_page_id
where fp_page_id in (224598)
limit 10
SQL

Checking query status...
