Fork of Untitled query #49153 by IKhitron
This query is marked as a draft This query has been published by IKhitron.

SQL

​x
 
use hewiki_p;
select t.rev_len, t.rev_parent_id, t.rev_page, parent.rev_len from
(select rev_len, rev_parent_id, rev_page from revision_userindex cur
 where cur.rev_actor = 2370184
/* and exists
 (select page_id from page
  where page_id = cur.rev_page
  and page_namespace = 0)*/) t
join revision parent
on parent.rev_id = t.rev_parent_id
​
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
All SQL code is licensed under CC0 License.

Checking query status...