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 user, p.page_title as page, r.rev_timestamp as timestamp, c.comment_text as summary FROM actor a #Actor INNER JOIN revision r #Revision ON r.rev_actor=a.actor_id AND a.actor_user IS not NULL #NULL for IP AND r.rev_timestamp >= @begin_date AND r.rev_timestamp <= @end_date AND a.actor_name like @ip_search INNER JOIN page p #Page ON r.rev_page=p.page_id AND p.page_namespace = @namespace INNER JOIN comment c #Comment on c.comment_id=r.rev_comment_id 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...