要約欄での検索

SQL

use jawiki_p;
/*select *
from revision_userindex as ru
inner join (*/
  select
  	topg.page_title as topg_title,
  	topg.page_id as topg_id,
  	frompg.page_title as frompg_title,
    frompg.page_id as frompg_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)
  inner join revision_userindex as ru on topg_id = ru.rev_page
  where
      pl.pl_namespace = 0 and
      frompg.page_title regexp '月間強化記事賞\/20[1-9][0-9]年[0-9]{1,2}月'
#) as kyoka on ru.rev_page = kyoka.topg_id
SQL

Checking query status...
