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
IKhitron
.
Toggle Highlighting
SQL
use hewiki_p; select * from page inner join revision as r1 inner join user inner join revision as r3 on page_id = 783449 and r1.rev_id = 8817289 and r3.rev_id = 8820009 and user_name = "Avivht" and r1.rev_id = page_latest and locate(user_name, page_title) = 1 and locate("/", page_title) = length(user_name) + 1 and r3.rev_user_text = user_name where page_namespace = 2 and page_title like "%/%" and not page_title like "%/%/%" and not page_title like "%טיוטה%" and not page_title like "%ארגז_חול%" and not page_title like "%ארכיון%" and not page_title like "%פתיח%" and not page_title like "%מדיניות%" and not page_title like "%ויקיפדיה%" and page_len > 1023 and datediff(now(), r1.rev_timestamp) > 182 and datediff(now(), r3.rev_timestamp) > 91 and not exists (select * from revision as r5 where r5.rev_user_text = user_name and r5.rev_timestamp > r3.rev_timestamp) limit 1
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...