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 
order by frs_timestamp desc
limit 10;
SELECT * from flaggedrevs_stats 
order by total desc
limit 10;
SELECT * from flaggedrevs_stats2 
limit 10;
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;
                           
SELECT * from page join flaggedrevs on fr_page_id = page_id left join flaggedpages on fp_page_id = page_id where fp_page_id is null limit 20;
SQL

Checking query status...
