Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Japkiw
.
Toggle Highlighting
SQL
# SELECT * SELECT page_title, rc_timestamp #, categorylinks.* #SELECT COUNT(DISTINCT comment_id) as counter, page_title FROM recentchanges JOIN page ON page_id = rc_cur_id JOIN actor ON rc_actor = actor_id JOIN comment_recentchanges ON rc_comment_id = comment_id # INNER JOIN ip_changes ON rc_cur_id=ipc_rev_id # JOIN categorylinks ON page_id = cl_from WHERE rc_patrolled=0 # changes not yet checked AND rc_bot=0 # not a bot #AND actor_name REGEXP '^[0-9][0-9]?[0-9]?[0-9]?([.]|:)' # anonymous user (ipv4 only) AND actor_name REGEXP '(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)' AND rc_timestamp LIKE '20220309%' AND page_id NOT IN ( SELECT cl_from FROM categorylinks cl WHERE LOWER(cl.cl_to) LIKE '%voetbal%' OR LOWER(cl.cl_to) LIKE '%basketbal%' OR LOWER(cl.cl_to) LIKE '%olleybal%' OR LOWER(cl.cl_to) LIKE '%sport%' OR LOWER(cl.cl_to) LIKE '%bokser%' OR LOWER(cl.cl_to) LIKE '%olympisch%' OR LOWER(cl.cl_to) LIKE '%wielren%' OR LOWER(cl.cl_to) LIKE '%ielerploeg%' OR LOWER(cl.cl_to) LIKE '%ountainbike%' OR LOWER(cl.cl_to) LIKE '%ormule\_1%' OR LOWER(cl.cl_to) LIKE '%afeltennis%' OR LOWER(cl.cl_to) LIKE '%handbal%' ) # OR cl.cl_to IN ('Nederlandse voetbalclub 2020/21', 'Belgisch_olympisch_deelnemer') # GROUP BY page_id # ORDER BY counter DESC
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...