Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
old users whose first edit anniversary is today or at a specified date
by
Bulgu
This query is marked as a draft
This query has been published
by
MKar
.
old users whose first edit anniversary is today or at a specified date
Toggle Highlighting
SQL
USE orwiki_p; SET @N = 750; SET @today = mid(replace(now(),"-",""),5,4); /* "0428"; -- */ -- {{subst:ilk düzenleme günü}} select user_name, concat("or.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 < 2010 and kacgun > 30 order by user_editcount desc, rev_user -- */ ; -- {{subst:Vikipedi sizi özledi}} select user_name, concat("or.wikipedia.org/wiki/User talk:", user_name) as url , 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 kacgun = @N 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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...