Extension:FlaggedRevs

SQL

desc flaggedrevs_promote;
 /*
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;
SQL

Checking query status...
