要約欄での検索

SQL

use jawiki_p;
select *
from page as frompg
inner join pagelinks as pl on frompg.page_id = pl.pl_from and (pl.pl_from_namespace = 4)
inner join page as topg on topg.page_title = pl.pl_title and (topg.page_namespace = 0)
where frompg.page_title = "月間強化記事賞/2010年1月"
/*

from pagelinks as pl
inner join page as frompg on pl.pl_from = frompg.page_id and (frompg.page_namespace = 4 and frompg.page_title = "月間強化記事賞/2010年1月")
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.page_id = ru.rev_page*/
SQL

Checking query status...
