要約欄での検索

SQL

use jawiki_p;
select *
from revision_userindex as ru
inner join (
  select
  	topg.page_title as topg_page_title,
  	topg.page_id as topg_page_id,
  	frompg.page_id as frompg_page_title,
  	frompg.page_title as frompf_page_id
  from pagelinks as pl
  inner join page as frompg on pl.pl_from = frompg.page_id and (frompg.page_namespace = 4)
  inner join page as topg on pl.pl_title = topg.page_title and (topg.page_namespace = 0)
  where
      pl.pl_namespace = 0 and
      frompg.page_title regexp '月間強化記事賞\/[0-9]{4}年[0-9]{1,2}月'
) as kyoka on ru.rev_page = kyoka.topg_page_id
SQL

Checking query status...
