List of articles suffixed "学部" created in Japanese Wikipedia

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

記事タイトルの最後に「学部」が付く日本語版ウィキペディアの記事の一覧

SQL

use jawiki_p;
select
child.rev_user_text,
child.rev_timestamp,
cast( child.rev_len as signed ) - ifnull( cast( parent.rev_len as signed ), 0 )
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.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...