Replicas browser and optimizer
This query is marked as a draft
This query has been published
use hewiki_p; select * from page inner join revision_userindex inner join user as u1 on rev_id = page_latest and locate(user_name, page_title) = 1 and locate("/", page_title) = length(user_name) + 1 where page_namespace = 2 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(), rev_timestamp) > 182 and datediff(now(), (select max(day) from user_daily_contribs as udc where udc.user_id = u1.user_id)) > 91
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in