SQL
x
USE mlwiki_p;
SET @N = 250;
SET @today = mid(replace(now(),"-",""),5,4); /*
"0428";
-- */
-- {{subst:ilk düzenleme günü}}
select user_name, concat("tr.wikipedia.org/wiki/User talk:", user_name) as url, mid(min(rev_timestamp),5,4) as aygun
, datediff(now(), max(rev_timestamp)) as kacgun
, user_editcount as ec, mid(min(rev_timestamp),1,4) as yil
, ipb_expiry
from revision_userindex join user on user_id = rev_user
left join ipblocks on ipb_user = user_id
where
-- rev_timestamp < 20160000000000 and
rev_user > 0 and user_editcount > 100
-- and rc_id is null
group by rev_user having aygun = @today and yil < 2016 and kacgun > 30
order by user_editcount desc, rev_user
-- */
;
-- {{subst:Vikipedi sizi özledi}}
select user_name, concat("tr.wikipedia.org/wiki/User talk:", user_name) as url
, round(datediff(now(), max(rev_timestamp))) as kacgun
, user_editcount as ec, ipb_expiry
from revision_userindex join user on user_id = rev_user
left join ipblocks on ipb_user = user_id
where rev_user > 0 and user_editcount > 100
group by rev_user having mod(kacgun,@N) = 0 and kacgun>0
order by user_editcount desc, rev_user
-- */
;
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.