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

SQL

AخA
 
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 '%こめんと%'
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...