bos degil - Quarry

SQL

USE trwiki_p;
set @ad= "Emir Çoban";
SET @pl = 18327518;
SET @id = 1634373;
SET @uid = 174948;

SELECT * from page where page_latest = @pl;
SELECT * from user where user_name = "Mirada";

SELECT * from flaggedpage_config left join page on fpc_page_id = page_id where page_id = @id;
SELECT * from flaggedpage_pending left join page on fpp_page_id = page_id where page_id = @id;
SELECT * from flaggedpages left join page on fp_page_id = page_id where page_id = @id;
SELECT * from flaggedrevs left join page on fr_page_id = page_id where page_id = @id;
SELECT * from flaggedrevs_promote left join user on frp_user_id = user_id where user_id = @uid;
SELECT * from flaggedrevs_statistics limit 5;
SELECT * from flaggedrevs_stats limit 5 order by frs_timestamp desc;
SELECT * from flaggedrevs_stats2 limit 5 order by total desc;
SELECT *, count(*), concat("tr.wikipedia.org/wiki?curid=",ftr_from) as url
                           from flaggedrevs_tracking group by ftr_from order by count(*) desc limit 10;
SELECT *, count(*), concat("tr.wikipedia.org/wiki/Özel:Diff/",ft_rev_id) as url
                           from flaggedtemplates group by ft_rev_id order by count(*) desc limit 10;
SQL

Checking query status...
