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.