Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Contributions by IP octet (subnet invariant)
by
Alfa80
This query is marked as a draft
This query has been published
by
Alfa80
.
Manually Configure Date Range and IP Portion to search
Toggle Highlighting
SQL
#ویکیپدیا:گزارش دیتابیس/کاربران غیر فعال در گروههای کاربری #https://fa.wikipedia.org/wiki/%D9%88%DB%8C%DA%A9%DB%8C%E2%80%8C%D9%BE%D8%AF%DB%8C%D8%A7:%DA%AF%D8%B2%D8%A7%D8%B1%D8%B4_%D8%AF%DB%8C%D8%AA%D8%A7%D8%A8%DB%8C%D8%B3/%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1%D8%A7%D9%86_%D8%BA%DB%8C%D8%B1_%D9%81%D8%B9%D8%A7%D9%84_%D8%AF%D8%B1_%DA%AF%D8%B1%D9%88%D9%87%E2%80%8C%D9%87%D8%A7%DB%8C_%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1%DB%8C ####################################################################### # Configuration # ####################################################################### SET @ip_parts = '81'; #as int 192.51.181.1 or 2001:db8::3815 SET @begin_date = '20010101'; SET @end_date = '20140101'; SET @max_record = 31; SET @namespace = 0; # for (main) article namespace use 0 ####################################################################### # Pre-Execution # ####################################################################### SET SQL_SELECT_LIMIT = @max_record; SET @ip_search = CONCAT('%', @ip_parts, '%'); ####################################################################### # Execution # ####################################################################### SELECT a.actor_name as userName, max(r.rev_timestamp) as lastEdit FROM revision r INNER JOIN actor a ON r.rev_actor=a.actor_id AND r.rev_timestamp <= @end_date #group by a.actor_name ####################################################################### # Whishlist # #######################################################################
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...