This query is marked as a draft This query has been published by 軽快.

SQL

AخA
 
use jawiki_p;
select
child.rev_user_text,
child.rev_timestamp,
cast( child.rec_len as signed ) - cast( parent.rec_len as signed )
from (
  select *
  from revision
  where rev_page = (
    select page_id
    from page
    where
    page_title = "CIE図書館" and page_namespace = 0
  )
) as child
left outer join (
  select *
  from revision
  where rev_page = (
    select page_id
    from page
    where
    page_title = "CIE図書館" and page_namespace = 0
  )
) as parent on child.rev_parent_id = parent.rev_id
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...