bek cok - Quarry

SQL

USE trwiki_p;
SET @N = 15;

SELECT fpp_page_id as id, round(timediff(now(),fpp_pending_since)/27,3) as since from flaggedpage_pending 
where fpp_page_id <> 26386
limit 10
;


/*
SELECT concat("tr.wikipedia.org/wiki/Dosya:",replace(p.page_title," ","_")), c.cl_to, p.page_is_redirect
from page p left join categorylinks c  on c.cl_from = p.page_id 
where  p.page_namespace = 6 and p.page_id NOT IN (select pp.page_id from page pp left JOIN categorylinks cc ON cc.cl_from = pp.page_id  where cc.cl_to IN ("Tüm_adil_kullanım_dosyaları", "Adil_kullanım_sembolleri"))
and c.cl_to is NULL and p.page_is_redirect = 0
limit 10;
-- */ /*
SELECT * 
from page p join iwlinks iwl on iwl.iwl_from = p.page_id
where p.page_namespace = 6 and iwl.iwl_prefix like "c%"
and iwl.iwl_title rlike "Image:"
limit 10;
*/
SQL

Checking query status...
