Replicas browser and optimizer
Untitled query #37350
This query is marked as a draft
This query has been published
prepat - was previous revision reviewed? pat - review flag for current revision bad = 1 - problems, should not happen
use ruwiki_p; SELECT *, (prepat <> "no") AND (pat <> "auto") as bad FROM (SELECT user_name, page_title, rev_id, rev_timestamp, CASE WHEN rev_parent_id = 0 THEN "new" WHEN f1.fr_timestamp IS NULL THEN "no" ELSE "yes" END as prepat, CASE WHEN f2.fr_flags IS NULL THEN "no" WHEN f2.fr_flags LIKE "%auto%" THEN "auto" ELSE "manual" END as pat FROM (SELECT log_title, MAX(log_timestamp) as time FROM logging WHERE (log_type = "rights") AND (log_action = "rights") AND ((log_params LIKE "%newgroups%autoeditor%") OR (log_params LIKE "%\n%autoeditor%")) GROUP BY log_title) as A INNER JOIN user ON A.log_title = user_name INNER JOIN user_groups ON (user_id = ug_user) AND (ug_group = "autoeditor") INNER JOIN actor ON (user_id = actor_user) INNER JOIN revision ON (rev_actor = actor_id) AND (rev_timestamp > "20191012") AND (rev_timestamp > time) INNER JOIN page ON (rev_page = page_id) AND (page_namespace IN (0, 6, 10, 14, 100, 828)) LEFT JOIN flaggedrevs as f1 ON (rev_parent_id = f1.fr_rev_id) AND (rev_timestamp > f1.fr_timestamp) LEFT JOIN flaggedrevs as f2 ON (rev_id = f2.fr_rev_id)) as B
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