Fork of
Bekleyen değişiklikler için
by Bulgu
This query is marked as a draft
This query has been published
by Evolutionoftheuniverse.
SQL
x
USE trwiki_p;
SELECT cl_to, count(*)
from flaggedpage_pending join categorylinks on cl_from = fpp_page_id
join page pc on pc.page_title = cl_to
where pc.page_namespace = 14 and pc.page_id not in (select pp_page from page_props where pp_propname in ("hiddencat") )
and cl_to not rlike "taslakları"
group by 1
having count(*) > 80
order by 2 desc
;
SET @N = -0; -- bekleyen değişiklikler için kaç gün öncesinden itibaren baksın.
SELECT concat("[[",replace(page_title,"_"," "),"]]") as madde
-- , concat("http://tr.wikipedia.org/wiki?curid=",cl_from) as url
,concat("[[:Kategori:",cl_to,"|",replace(cl_to,"_"," "),"]]") as kat
, round(floor(fpp_pending_since/1000000),0) as tarih
, DATEDIFF(NOW(),fpp_pending_since) as kac_gun
, CONCAT("[http://tr.wikipedia.org/w/index.php?diff=cur&oldid=",fpp_rev_id," tüm]") as tumbekleyen
, CONCAT("[http://tr.wikipedia.org/wiki/Özel:Diff/",rev_id," ilk]") as ilkbekleyen
from categorylinks join page on page_id = cl_from
join flaggedpage_pending on fpp_page_id = cl_from
join
(select rev_id, rev_parent_id, rev_deleted, rev_user_text,rev_user,rev_len
from revision_userindex where rev_timestamp > DATE_ADD(NOW(), INTERVAL @N DAY)) as rev on rev.rev_parent_id = fpp_rev_id
where cl_to in ("Fizik", "Bilim", "Biyoloji", "Bilim_tarihi", "Matematik", "Felsefe")
and page_namespace = 0
order by tarih
-- limit 10
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.