要約欄での検索

SQL

use jawiki_p;
select
concat( 
  case page_namespace
    when 0 then ""
    when 1 then "ノート"
    when 2 then "利用者"
    when 3 then "利用者‐会話"
    when 4 then "Wikipedia"
    when 5 then "Wikipedia‐ノート"
    when 6 then "ファイル"
    when 7 then "ファイル‐ノート"
    when 8 then "MediaWiki"
    when 9 then "MediaWiki‐ノート"
    when 10 then "Template"
    when 11 then "Template‐ノート"
    when 12 then "Help"
    when 13 then "Help‐ノート"
    when 14 then "Category"
    when 15 then "Category‐ノート"
    when 100 then "Portal"
    when 101 then "Portal‐ノート"
    when 102 then "プロジェクト"
    when 103 then "プロジェクト‐ノート"
    when 828 then "モジュール"
    when 829 then "モジュール‐ノート"
  end, page_title ) as "ページ名",
rev_user_text as "利用者名",
rev_id as "oldid",
rev_timestamp as "投稿日時"
rev_comment as "要約欄",
rev_minor_edit as "細部の編集か？"


from revision_userindex
inner join page on rev_page = page_id
where 
    rev_user_text = "軽快" and
    rev_minor_edit = 0 and
    rev_comment like '%こめんと%'
SQL

Checking query status...
