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.