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
ಮಲ್ನಾಡಾಚ್ ಕೊಂಕ್ಣೊ
.
Can excludes known maintenance bots
Toggle Highlighting
SQL
/* MalnadachBot - 215006043 (use rev_timestamp < '20220708') WOSlinkerBot - 10819 Ahechtbot - 27270702 NihlusBOT - 46657 */ select case when COUNT(*) > 0 -- If an entry exists, the page has been edited else not edited then 'Yes' else 'No' end as 'Page has been edited?' from revision join page on page_id = rev_page -- link with page table where page_title = '121.208.212.82' -- page title without namespace prefix and page_namespace = 3 -- page namespace and rev_timestamp > '20170504000000' -- check if it received edits after this timestamp and rev_actor not in (46657, 27270702, 10819, 215006043); -- exclude edits by these users
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...